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

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

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

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

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