Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
I don't know if this is the correct group, but I have searched other threads
and tried to fix my problem which is similar and nothing works. I have Excel 2003, XP Pro. I can see rows 1-16. In order to see the next rows I can use the down arrow button to see 17, etc. However, then the page goes back to hiding rows below row 16. I do not remember ever hiding any rows. I would not have known what to do. The work sheet has columns A to M. There is a cross in the middle of the sheet. The vertical line is between column F and G. The horizontal line is between 16 and 23. The rows between 16 and 23 are hidden unless I use the down arrow at row 16. I do not want these rows to be hidden. It messes up my entire sheet since I cannot find easily what is where. Thanks -- stevemalee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
Window/ Remove split.
-- David Biddulph "stevemalee" wrote in message ... I don't know if this is the correct group, but I have searched other threads and tried to fix my problem which is similar and nothing works. I have Excel 2003, XP Pro. I can see rows 1-16. In order to see the next rows I can use the down arrow button to see 17, etc. However, then the page goes back to hiding rows below row 16. I do not remember ever hiding any rows. I would not have known what to do. The work sheet has columns A to M. There is a cross in the middle of the sheet. The vertical line is between column F and G. The horizontal line is between 16 and 23. The rows between 16 and 23 are hidden unless I use the down arrow at row 16. I do not want these rows to be hidden. It messes up my entire sheet since I cannot find easily what is where. Thanks -- stevemalee |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
Or WindowUnFreeze Panes
Gord Dibben MS Excel MVP On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote: Window/ Remove split. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
Thanks so much. The unfreexe panes worked. I didn't try that prior because
I thought it would remove the function of saving the titles of the columns, but I froze again and the titles stayed. -- stevemalee "Gord Dibben" wrote: Or WindowUnFreeze Panes Gord Dibben MS Excel MVP On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote: Window/ Remove split. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
I replied that all was OK too soon.
The next time I opened the sheet the rows were hidden again. And, after I "unfroze" I lost the top titles when I scrolled down. So, is there another answer to this problem ? -- stevemalee "Gord Dibben" wrote: Or WindowUnFreeze Panes Gord Dibben MS Excel MVP On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote: Window/ Remove split. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
With the WindowFreeze Panes disabled can you see all the rows?
If so, maybe you are "freezing" at the wrong location. The freezing rule is..............all rows above and left of the selected cell will be frozen when you go to WindowsFreeze Panes. i.e to freeze row 1 and column A, select B2 the freeze. Gord Dibben MS Excel MVP On Sat, 12 Apr 2008 06:21:01 -0700, stevemalee wrote: I replied that all was OK too soon. The next time I opened the sheet the rows were hidden again. And, after I "unfroze" I lost the top titles when I scrolled down. So, is there another answer to this problem ? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
Yes I was using the wrong place to freeze. I thought it was the small corner without any number or alphabet at the very top of the sheet directly above the numbers of the rows and farthest to the left of the column letters. What you recommended seems to work. Thanks -- stevemalee "Gord Dibben" wrote: With the WindowFreeze Panes disabled can you see all the rows? If so, maybe you are "freezing" at the wrong location. The freezing rule is..............all rows above and left of the selected cell will be frozen when you go to WindowsFreeze Panes. i.e to freeze row 1 and column A, select B2 the freeze. Gord Dibben MS Excel MVP On Sat, 12 Apr 2008 06:21:01 -0700, stevemalee wrote: I replied that all was OK too soon. The next time I opened the sheet the rows were hidden again. And, after I "unfroze" I lost the top titles when I scrolled down. So, is there another answer to this problem ? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cannot unhide rows
The small corner button you refer to is the "select all cells" button.
Gord On Sun, 13 Apr 2008 09:24:00 -0700, stevemalee wrote: Yes I was using the wrong place to freeze. I thought it was the small corner without any number or alphabet at the very top of the sheet directly above the numbers of the rows and farthest to the left of the column letters. What you recommended seems to work. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unhide Rows | Excel Discussion (Misc queries) | |||
unhide rows | Excel Discussion (Misc queries) | |||
How do I unhide several rows at the same time? | Excel Discussion (Misc queries) | |||
Can't unhide rows | Excel Discussion (Misc queries) | |||
Unhide rows | Excel Discussion (Misc queries) |