How do you do a global unhide in Excel?

L

Leslie

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
 
R

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.
 
T

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.
 
S

spartan76_98

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

Gord Dibben

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


Gord Dibben MS Excel MVP
 
S

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.
 
Top