Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I changed my spreadsheet fix upper rows in sight how back? | Excel Worksheet Functions | |||
Can I fetch multiple rows back using VLOOKUP? | Excel Worksheet Functions | |||
all my top rows are now numbers, how to set it back to letters | Excel Discussion (Misc queries) | |||
Columns are numbers, rows letters. How do I change back? | Setting up and Configuration of Excel | |||
Rows are hidden and wont come back | Excel Discussion (Misc queries) |