In this tutorial we are going to look at how to hide rows and columns in Excel. This technique is very useful if you only want to look at part of your list or if you only want to print some of your spreadsheet ( you can hide the rows or columns you want to omit)
What we will cover in this tutorial is the following
- How to hide columns (including the shortcut Ctrl and 0 – the number)
- How to unhide columns – not as simple as you would think – Ctrl and Shift and 0 – the number)
- How to hide rows (including the shortcut Ctrl and 9)
- How to unhide the rows (easier than unhiding columns and a shortcut – Ctrl and Shift and 9)
As always here is the file to practise on.