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

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

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

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:

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

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

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

Regards

Trevor


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

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

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

"jwwj232" skrev i melding
...
I tried the steps illustrated in the help file but I am still unable to
unhide the first three rows of a worksheet.

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

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

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

are you sure you dont have the sheet frozen?
go to Window-Unfreeze panes

"jwwj232" wrote:

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

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

Can I tell you a short cut key for this?

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

"Trevor Shuttleworth" wrote:

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

Regards

Trevor


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

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

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

"Jaleel" wrote:

Can I tell you a short cut key for this?

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

"Trevor Shuttleworth" wrote:

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

Regards

Trevor


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