Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Opening sheet shows rows i to 36. When I page down the sheet shows row 1 at
the top and then rows 37 to 71. The next page down and all subsequent key strokes will still show row one at the top of the sheet and then the next sequence of rows. What is wrong? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
What is wrong? Nothing, it's a setting called 'Freeze panes'. You didn't say which version of Excel so for 2003 Window|Unfreeze panes for e2007 View tab|Window group - Unfreeze panes -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Alpan" wrote: Opening sheet shows rows i to 36. When I page down the sheet shows row 1 at the top and then rows 37 to 71. The next page down and all subsequent key strokes will still show row one at the top of the sheet and then the next sequence of rows. What is wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel |