How do you do a global unhide in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
I'm using Excel 2003 and this solution didn't work. It didn't "unhide"
anything. Other suggestion?
 
Maybe the rows aren't hidden but merely set to a tiny row height?


Gord Dibben MS Excel MVP
 
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.
 
Random. The last post about the rapid left click worked for me, when the other solutions didn't. Noted! I have Excel 2010.:thumb:
 
Back
Top