Support Centre

Quickly Hide all Rows in an Excel Worksheet

Last Updated: Dec 10, 2013 03:05PM GMT
If you have an excel worksheet that has all rows showing, you may want to neaten it up and hide all un-necessary rows.

To do this, follow these steps:
  1. Click the row number that you'd like to hide at the bottom of your worksheet.
    Make sure the whole row is selected, by clicking within the grey-margin.
  2. To select all rows below, press CTRL+Shift+Down arrow.
  3. Right click within all the highlighted rows and select hide.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found