How do you do a global unhide in Excel?

[Guest]

I have a spreadsheet that a user has hidden a large number of rows and then
saved the spreadsheet with the rows hidden. I now need to work with all the
rows doing a V-lookup based on criteria I import from a database each month.
Bottom line is there a way to do a golbal unhide in Excel?

Thank you in Advance.
Leslie

 

[RagDyer]

Start by selecting the entire sheet.

Click in the small box which is to the left of Column A, and above Row1
OR
<Ctrl> <A>

Then, right click in the selection and choose "Unhide" to bring out all the
rows.
Next, while the sheet is *still* selected, from the menu bar,
<Format> <Columns> <Unhide>
To display everything else.

 

[Tyro]

In Excel 2007, select the whole spreadsheet (Ctrl+A) or click just above the
Row 1 header and to the left of Column A header (where the row headers and
column headers intersect). Then Home/Cells group/Format/Hide & Unhide/Unhide
Rows. In previous versions of Excel, select the whole sheet, then
Format/Row/Unhide.

 

[spartan76_98]

I'm using Excel 2003 and this solution didn't work. It didn't "unhide"
anything. Other suggestion?

 

[Gord Dibben]

Maybe the rows aren't hidden but merely set to a tiny row height?


Gord Dibben MS Excel MVP

 

[spartan76_98]

I tried making all row heights standard earlier without success. I stumbled
onto a solution. I highlighted the entire page and moved the curser in a
"hidden" cell until I saw the = sign and then rapidly left clicked. I don't
know if this was the right answer, but all rows became visible.

 

[tamejia]

Random. The last post about the rapid left click worked for me, when the other solutions didn't. Noted! I have Excel 2010.