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!

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

Hide and unhide all

Status
Not open for further replies.
ohmbru

ohmbru

Technical User
Jul 13, 2001
161
0
0
US
I have a document, and for reasons to lengthy to get into here, I hid all rows and columns one of the sheets. Now I can't fihure out how to unhide them. It is not allowing me to select all and get the shortcut menu.

This is a development copy of the document, so I have not lost anything. But, I sure would like to know if I can get the rows/columns back. Some code perhaps?


Brian
 
Sort by date Sort by votes
Brian,

Format/Row/Unhide

:)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
 
Upvote 0 Downvote
Scratch the Ctrl+A...
I should have said...

Window > Unhide
Select the workbook name in the window
OK
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
259
combo
combo
cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
189
cneill
cneill
ladyck3
  • Locked
  • Question
EXCEL - I'm starting a new project but have to say... to all...
Replies
2
Views
113
ladyck3
ladyck3
pendle666
  • Question
Microsoft Word - removing index entries with find/replace and wildcards
Replies
4
Views
477
pendle666
pendle666
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
120
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top