Thread: Hiding and unhiding Excel rows

might have rows in your worksheet which are an essential part of your data, but may not be of much relevance to be displayed or printed. Such rows can be hidden while viewing or printing. These hidden rows are not deleted, their row height is merely set at zero. To hide/unhide rows using Excel 2003, follow the steps below:

Select the rows or one or more'cells from the rows to be hidden.

Go to the 'Format I Row I Hide' menu option. The selected rows are hidden. To unhide rows, select the rows on both sides of those that are hidden.

Go to the 'Format I Row I Unhide' menu option.

To hide/unhide rows using Excel 2007, select the cells or the complete row that you wish to hide.

Go to the 'Home' tab.



Click the 'Format' option appearing under the 'Cells' group.

Click 'Hide & Unhide' from the dropdown menu that appears.

Click 'Hide Rows' from the sub

menu. The selected rows are hidden.

To un hide rows, select the rows on both sides of those that are hidden.

Go to the 'Home' tab.

Click the 'Format' option appearing under the 'Cells' group.

Click 'Hide & Unhide' from the drop down menu that appears.

Click 'Unhide Rows' from the sub menu. The hidden rows are now displayed.