Getting Rows back
 

I have aspreadsheet that I need to see the first say 20 rows which are uanble
to show, how do I get the rows back on my spredsheet so I can rview my
formula to ensure it is acruate

Getting Rows back
 

#1. Maybe you've filtered the range.
Try data|filter|Show all

#2. Maybe those rows are hidden
edit|goto
type: 1:20
and hit enter
then Format|Row|Unhide
(or Format|row|height and give it a nice number)

#3. Maybe you've hidden the rows by freezing the panes in the wrong spot.
Window|Unfreeze Panes
and scroll up.



tsmith wrote:

I have aspreadsheet that I need to see the first say 20 rows which are uanble
to show, how do I get the rows back on my spredsheet so I can rview my
formula to ensure it is acruate

--

Dave Peterson

Getting Rows back
 

CTRL + a(twice in 2003) to select all.

FormatRowUnhide

Or FormatRowHeight enter a number.


Gord Dibben MS Excel MVP

On Mon, 2 Jul 2007 13:38:05 -0700, tsmith
wrote:

I have aspreadsheet that I need to see the first say 20 rows which are uanble
to show, how do I get the rows back on my spredsheet so I can rview my
formula to ensure it is acruate