Excel Support - Hiding rows or columns
Sometimes when you have a large spreadsheet, you may want to hide some of the information from view.
Simply highlight the row or column by clicking the appropriate header, right-click and select ‘Hide’ from the menu.
You can even select multiple rows or columns by selecting the first row or column, then holding down the SHIFT key select the last row or column. If you want to be more selective, hold down the CTRL key instead and select each row or column before hiding them (Please note that you cannot hide both rows and columns at the same time).
If you want to unhide a row or column, simply select each row or column on each side of the hidden item, right-click and select ‘Unhide’ from the menu.