I recently helped a client reduce the size of an Excel file. The file took a while to save which was frustrating and time consuming. I thought I would share this reasonably easy solution.
Tag Archives: unhide
Unhide all sheets in Excel
In Excel if you need to hide data or workings sheets you can hide multiple sheets in one action. Unfortunately Excel won’t let you unhide multiple sheets in one step (even in the latest version). To get around this limitation you can use a macro that unhides all the sheets.
Summing Coloured Cells in Excel
A SUBTOTAL trick worth learning
In my training sessions I sometimes get asked about summing cells based on their colour. A SUMIF based on colour.
Quickly and easily hiding and unhiding rows and columns in Excel
Excel's Grouping technique
Hiding rows and columns is a common process in spreadsheets. Excel’s grouping feature can make the process easier and make it more apparent when rows or columns have been hidden.
Unhide all sheets in a file macro [VIDEO]
Adding functionality with a macro
Excel allows you to easily hide a group of sheets BUT frustratingly, it won’t let you unhide a group of sheets. You have to unhide them one sheet at a time.