• Excel Tips and Support - Hiding rows or columns

  • Excel support

    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).

    Hiding rows and columns 1

    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.

    Hiding rows and columns 2