Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can not see: sheet 2 1

Status
Not open for further replies.

kenguru

Programmer
May 14, 2004
173
0
0
RO
Hello,

I have an excel file. I can see the sheet1, but no the sheet2. And I know that it is there. HOw could i see it?

Thank you,
Kenguru
 




Hi,

Is there a Sheet2?

Try Fromat/Sheet/Unhide...

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
At the bottom of your screen, you may have dragged across the horizontal scroll bar too far to the left, therefore only showing one tab/sheet.

 
[Ctrl]+[Page Up] and [Ctrl]+[Page Down] will scroll through non-hidden worksheets.

If you still can't find the sheet, go to Format > Sheet > Unhide to see if Sheet2 was hidden.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 
Hey, if it hasn't been mentioned yet, try:

Format ->
Sheet ->
Unhide

[LOL] [WINK] [WINK]

If that fixes it, PLEASE don't acknowledge me - I was just throwing a bit of sarcasm in here, since the same thing's been mentioned twice. [smile]

--

"If to err is human, then I must be some kind of human!" -Me
 
Thank You! That was what i was looking for (Fromat/Sheet/Unhide).
Kenguru
 
Sorry about that, Skip - I didn't meant to repeat you. Hey, it was only 3PM.... I was still waking up. [wink]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 



Its the Secret, not well known Fromat feature. ;-)

Skip,
[sub]
[glasses] [red][/red]
[tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top