Quick Tip for Microsoft Excel 2010

Here is how you Hide and Unhide Rows and Columns Microsoft Excel 2010

Sometimes you might want to present your information but choose not to show one or more columns of data. In Excel you can hide one or more columns so the information is still used in calculations on the sheet, but is not visible.

To Hide a Column

1. Right-Click on the Column Heading of the column you wish to hide (1)
2. In the menu that appears, Click on Hide (2)

To hide more than one Column

1. Click and drag across the Column Headings to select the Columns you want to hide (1)

1. Right-click on the Column Headings to bring up a menu (2)
2. Select Hide from the menu (3)

Unhide a Column

1. Click and drag across the Column Headings (e.g. H-J in this example) to select the columns around the hidden column

1. Right Click on the Column Heading (2)
2. Select Unhide from the menu (3)

Hide a Row or Rows

Sometimes you might want to present your information but choose not to show one or more rows of data. In Excel you can hide one or more rows so the information is still used in calculations on the sheet, but is not visible.

To Hide a Row

1. Right-Click on the Row Heading of the row you wish to hide (1)
2. In the menu that appears, Click on Hide (2)

To hide more than one Row

 

1. Click and drag down the Row Headings to select the rows you want to hide (1)

1. Right-click on the Column Headings to bring up a menu (2)
2. Select Hide from the menu (3)

To Unhide a Row

1. Click and drag down the Row Headings (e.g. 2-4 in this example) to select the rows above and below the hidden row

1. Right Click on the selected area (2)
2. Select Unhide from the menu (3)

[callout]To learn more about Rows and Columns and to see how we can help your organisation improve their performance with Microsoft Excel give us a call 020 8203 1774[/callout]