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 […]
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 […]
Create a drop-down list in Excel. Easier and more efficiently use of Excel with drop-down lists in key fields.
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.
Straightforward way to move entire rows or columns in Microsoft Excel. The quick & easy way to reorder rows or columns in Excel.
Learn some nice Microsoft Excel keyboard and mouse shortcuts
User manual describing how to change the menu language in Excel or other Microsoft Office products.
First blog on Office‐Tips.net giving the intention with the blog. It is a place for tips to make use of office and software products easier.
