18/03/2019 04:06 /
Hide and unhide rows in Excel The article today “Hide and Unhide rows and columns” is just a quick introduction to hide and unhide rows. The first section covers hiding and showing a continuous series of rows. There are several methods, but we keep it to one and a series of rows this time. In …
Categories: Excel Microsoft Office Office Tips
17/03/2019 23:02 /
4 steps to Unhide everything – Quick tips Left Click with the mouse in field A1. Press [Ctrl] + [A] to select everything. Right click anywhere in the sheet. Select unhide from the pop-up menu All hidden rows should now be visible
Categories: Excel Microsoft Office Office Tips
17/03/2019 22:39 /
1 look-up function, Index and Match In today’s article the focus are the lookup functions Index and Match, and how they can be used together. Attached to the Article you will find a PDF version for printout. There is also an Excel file that have one sheet containing a dataset (booklist with columns author, title …
Categories: Excel Microsoft Office Office Tips
16/03/2019 04:10 /
5 steps to create a drop-down list The topic of today is to make a drop-down list in Excel. In this article we will reuse the example Excel file we used in the “Look up a value” article and work in the second sheet, dataset containing the 99 recommended books list. The first thing we …
Categories: Excel Microsoft Office Office Tips
14/03/2019 02:36 /
Look up a value The article today is the first explanation for use of a nested Excel function on Office-Tips.net. There are several ways of looking up values in Excel, our example is finding a value based on a set of given criteria’s.
Categories: Excel Microsoft Office Office Tips
13/03/2019 21:34 /
Move rows or columns One function that certainly is handy to know is the one that makes you able to move columns or rows where you want them by use of drag and drop. Before we learned this function the most used way to move columns or rows was by cut and paste. The steps …
Categories: Excel Microsoft Office Office Tips
12/03/2019 07:03 /
Calendar 2019 Today’s post is just a calendar for 2019. So why did we make that one, well there was just a need to get an overview of the year for planning purposes. The one year calendar is at all time fixed on the wall above the desk. Old fashion maybe, but an easy way of …
Categories: Excel Microsoft Office Office Tips
12/03/2019 02:24 /
How to unhide all rows & columns in Excel (mouse version) In this article we will explain an easy way of unhiding all rows and columns in Excel by use of the mouse. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A Right …
Categories: Excel Microsoft Office Office Tips
11/03/2019 21:26 /
How to remove Hyperlinks. Have you ever imported data into Excel exported from internet? Then you know how annoying it can be that some fields act as HTML links and open ups the internet browser when clicking in those fields. At lest do we often meet that problem, sheet clean of linked fields are often …
Categories: Excel Microsoft Office Office Tips
10/03/2019 23:09 /
One mouse click to select all. You might know how to select everything in a workbook sheet by use of the key combination [Ctrl] + [A]. But not all knows that one click on the corner button in a workbook sheet does the same. Everything will be selected by clicking the upper left corner square …
Categories: Excel Microsoft Office Office Tips
08/03/2019 20:51 /
Change language in Office Among users of Office products that doesn’t have English as their native language there is often a wish to change language. They find it easier and handier to use their native language in Office. What we are looking at then is not to change the spellcheck or synonyms language, it is …
Categories: Excel Microsoft Office Office Tips
