Hiding rows or columns in Excel

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.

Contact us for a free consultation

Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.