Hiding/Unhiding a Row(s) or Column(s) in Excel

sparksspace | Wednesday, April 09, 2008 | 0 comments

Microsoft Excel

Hiding/Unhiding a Row(s) or Column(s)

Using keyboard shortcuts

To hide/unhide a row(s):

To hide a row(s), select a cell(s) and press Ctrl+9.

To unhide a row(s), select the cells containing the range of the hidden row(s) and press Ctrl+Shift+(.

To hide/unhide a column(s):

To hide a column(s), select a cell(s) and press Ctrl+0.

To unhide a column(s), select the cells containing the range of the hidden column(s) and press Ctrl+Shift+).

To unhide rows & columns in a sheet:

1. Press Ctrl+A to select all cells in the sheet (in Excel 2003, press Ctrl+A+A from a cell in the Current Region/List range) or click Select All at the top-left intersection of the rows and columns.

2. Press Ctrl+Shift+( and then Ctrl+Shift+).

To unhide rows & columns in all sheets in the workbook at once:

1. Group the sheets in the workbook by selecting Select All Sheets from the sheet tab's shortcut menu.

2. Press Ctrl+A to select all cells in the sheets (in Excel 2003, press Ctrl+A+A from a cell in the Current Region/List range) or click Select All at the top-left intersection of the rows and columns.

3. Press Ctrl+Shift+( and then Ctrl+Shift+).

Category: , ,

Welcome to SparksSpace . This blog launched on Dec 2007 with a focus on Technology.You can find latest Computer Software, Tutorials, Tricks,Tips & Software promotions here!

0 comments