How do you unhide the first three rows of a worksheet?

J

jwwj232

I tried the steps illustrated in the help file but I am still unable to
unhide the first three rows of a worksheet.
 
E

excelent

in my version excel 2003 this way

move mousepointer leftmost just under the kolumnheader where
pointer become to a cross width 2 horisontale lines
press left botton and pull down



"jwwj232" skrev:
 
T

Trevor Shuttleworth

Press F5 (Go To) | Reference: 1:3 | Format | Row | Unhide

Regards

Trevor
 
H

Harald Staff

Excel versions behave differently when it comes to this, which one are you
using ? Anyway, here's a pretty universal macro solution:

Sub Unhidem()
Dim R As Long
For R = 1 To 100
If Rows(R).Hidden = True Then
If MsgBox("Wanna see " & R & " ?", _
vbYesNo + vbQuestion) = vbYes Then
Rows(R).Hidden = False
End If
End If
Next
End Sub

HTH. Best wishes Harald
 
K

Ken Johnson

Has the sheet's scroll area property been altered?

The first three rows will remain hidden if they are not part of the
sheet's scroll area.

Right click that sheet's tab then select "View Code" from the popup
menu. This takes you to the VBA Editor. In the VBA Editor go
View|Properties window. If the ScrollArea value is not blank then you
will have to delete the address to reveal the top three rows.

Ken Johnson
 
J

Jaleel

Can I tell you a short cut key for this?

First press Control + shift
and then presss Control + shift + 9 (not numerical key)
 
J

Jaleel

Sorry, first press control + a (to select all)

Jaleel said:
Can I tell you a short cut key for this?

First press Control + shift
and then presss Control + shift + 9 (not numerical key)
Click to expand...
 
Top