If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I lock cells so when I scroll they stay?
I want to lock the top rows so when I scroll down the page they stay in view.
Can someone tell me how to do this? Thanks. |
#2
|
|||
|
|||
Brynden, select the cell under the row you want locked and go to window
freeze panes -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Brynden" wrote in message ... I want to lock the top rows so when I scroll down the page they stay in view. Can someone tell me how to do this? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Protect Sheet and Lock Cells | DB | General Discussion | 3 | August 26th, 2004 10:37 PM |
averaging linked cells | Peo Sjoblom | Worksheet Functions | 0 | June 1st, 2004 07:35 PM |
Ghosting or scroll lock | Doug | Worksheet Functions | 1 | March 23rd, 2004 11:52 PM |
Locking other cells based on values in a cell | Worksheet Functions | 3 | January 13th, 2004 12:53 AM |