Paul Wherly

Hide and Unhide Rows and Columns Microsoft Excel 2010

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

ExcelHide1

  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

ExcelHide2

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

ExcelHide3

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

Unhide a Column

ExcelHide4

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

ExcelHide5

  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

ExcelHide7

  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

ExcelHide8

 

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

ExcelHide9

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

To Unhide a Row

ExcelHide10

  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

ExcelHide11

  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]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More