How do you do a global unhide in Excel?
 

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

How do you do a global unhide in Excel?
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Leslie" wrote in message
...
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

How do you do a global unhide in Excel?
 

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.

"Leslie" wrote in message
...
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

How do you do a global unhide in Excel?
 

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

"RagDyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Leslie" wrote in message
...
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

How do you do a global unhide in Excel?
 

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


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 09:04:00 -0800, spartan76_98
wrote:

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

"RagDyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Leslie" wrote in message
...
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

How do you do a global unhide in Excel?
 

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.

"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 09:04:00 -0800, spartan76_98
wrote:

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

"RagDyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Leslie" wrote in message
...
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