Unhide rows 1 - 9
 

I have hidden rows 1 - 9 and cannot find how to unhide these rows. Help.

W. Wolfe

Unhide rows 1 - 9
 

PS I am using Excel 2007.


"W Wolfe" wrote in message
...
I have hidden rows 1 - 9 and cannot find how to unhide these rows. Help.

W. Wolfe

Unhide rows 1 - 9
 

If those are the only rows that are hidden, just select the entire worksheet
(click the blank box where the row and column header meet), right-click the
selection and click on Unhide. If there are other hidden rows that you want
to keep hidden, click on the 10 in Row 10's header and drag up to the blank
box where the row and column headers meet, then release the mouse button.
Next, right-click the selection and click on Unhide.

Rick


"W Wolfe" wrote in message
...
I have hidden rows 1 - 9 and cannot find how to unhide these rows. Help.

W. Wolfe

Unhide rows 1 - 9
 

Sub Unhideonetonine()
ActiveSheet.Rows("1:9").Hidden = False
End Sub

"W Wolfe" wrote:

PS I am using Excel 2007.


"W Wolfe" wrote in message
...
I have hidden rows 1 - 9 and cannot find how to unhide these rows. Help.

W. Wolfe