hidden/0 height rows
 

Try this:

<Data <Filter

And *UNCHECK*
"AutoFilter".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
<Scott Brooks wrote in message
...
Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.

This was created with MS Excel 2003 and I am using MS Excel 2007.

Thanks for any ideas and advice.

hidden/0 height rows
 

Is there some reason you can't select say row 1 - 7029 and Format - Row -
Height and set it to 14.25?

"Scott Brooks" wrote:

Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.

This was created with MS Excel 2003 and I am using MS Excel 2007.

Thanks for any ideas and advice.

hidden/0 height rows
 

Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.

This was created with MS Excel 2003 and I am using MS Excel 2007.

Thanks for any ideas and advice.

hidden/0 height rows
 

My worksheet was filtered, thanks again.


On Sun, 1 Apr 2007 11:29:05 -0700, "Ragdyer"
wrote:

Try this:

<Data <Filter

And *UNCHECK*
"AutoFilter".

hidden/0 height rows
 

Doesn't selecting the entire worksheet with the top left button doing
(basically) the same thing? Another user realized that the previous
user had filtered the worksheet. Thanks again for your idea though.

On Sun, 1 Apr 2007 11:34:00 -0700, Barb Reinhardt
wrote:

Is there some reason you can't select say row 1 - 7029 and Format - Row -
Height and set it to 14.25?

"Scott Brooks" wrote:

Hello all,
I have a 7000+ row worksheet; rows 2-1180 and 1185-7028 are
hidden/have a 0 height. I learned from a previous post that I can
manually "drag" each row and change its height back to 14.25. Since
this is not my worksheet (a colleague asked me to "fix" it) I am loath
to manually drag 7000+ rows to the correct height. I have highlighted
the workbook, right clicked; change height to 14.25 and this only
changes the height of "visible" rows. Row 1 is frozen (with titles).
The numbers for rows 1181 to 1184 are blue.

This was created with MS Excel 2003 and I am using MS Excel 2007.

Thanks for any ideas and advice.

hidden/0 height rows
 

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

<Scott Brooks wrote in message
...
My worksheet was filtered, thanks again.


On Sun, 1 Apr 2007 11:29:05 -0700, "Ragdyer"
wrote:

Try this:

<Data <Filter

And *UNCHECK*
"AutoFilter".