Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I set up repeated view of top line in excel spreadsheet
I want to be able to view the first line of excel when I scroll down the
page. So I would like it to follow me down the page. Any ideas on how I can set this up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I set up repeated view of top line in excel spreadsheet
Highlight Row 2, then select "Freeze Panes" from the Window Menu
That should do it. HTH, Elkar "Micahel" wrote: I want to be able to view the first line of excel when I scroll down the page. So I would like it to follow me down the page. Any ideas on how I can set this up? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I set up repeated view of top line in excel spreadsheet
Select cell A2. Click on Window - Freeze Panes. HTH Otto
"Micahel" wrote in message ... I want to be able to view the first line of excel when I scroll down the page. So I would like it to follow me down the page. Any ideas on how I can set this up? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I set up repeated view of top line in excel spreadsheet
If you want to see row 1 all the time, select row 2, then Window|freeze panes.
You can even make it so you can see the top rows when you scroll up/down and see the left columns when you scroll right left. Select any old cell (say D5). then window|freeze panes Everything above D5 (rows 1:4) will be frozen. Everything to the left of D5 (columns A:C) will be frozen. Micahel wrote: I want to be able to view the first line of excel when I scroll down the page. So I would like it to follow me down the page. Any ideas on how I can set this up? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Converter from MS Works 4.5 spreadsheet to MS Excel 2003 | Excel Discussion (Misc queries) | |||
how to open email from opt on line to excel | New Users to Excel | |||
How to restore the line of: File, Edit, View, in excel | Excel Discussion (Misc queries) | |||
How do I view an Excel spreadsheet component I added in FrontPage? | Excel Discussion (Misc queries) |