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 […]
Category Archives: Excel
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.
How to remove hyperlinks from a dataset in Microsoft Excel. How to remove internet links from a dataset in a Microsoft Excel file.