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 […]
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.
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 […]
Unhide everything in Excel, show all data in a spreadsheet in Microsoft Excel. Easy way to show all data in Excel.
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.
How to create an A3 calendar in Excel. In this article we show how to make your own calendar with a customized touch in a Excel spreadsheet.
How to remove hyperlinks from a dataset in Microsoft Excel. How to remove internet links from a dataset in a Microsoft Excel file.
How to remove hyperlinks from a dataset in Microsoft Excel. How to remove internet links from a dataset in a Microsoft Excel file.
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.
