How do you do....it? Thread, Excel - locking split screen in Technical; I'm sure I used to know how to do this
On Excel 2003, how do you "lock" the split screen ...
2nd September 2010, 11:42 AM #1
Excel - locking split screen
I'm sure I used to know how to do this
On Excel 2003, how do you "lock" the split screen so that the first three (say) columns and rows stay in view all the time? in a way that nobody can change it?
I know how to split it by dragging up the little mark at the top (or right) of the scroll bar, but how do you make it permanent?
2nd September 2010, 12:26 PM #2
You could use freeze panes, click in the cell in the top left corner of the moveable section (ie: for first three rows/columns to stay same click in cell D4), then on the menu bar go to Window then click freeze panes. Users will not beable to modify the position of the frozen sections via the main screen, although they will be able to go to Window then click Unfreeze Panes to revert it back to normal.
Thanks to HilcrRWise from:
BatchFile (2nd September 2010)
2nd September 2010, 12:29 PM #3
Freeze panes - that's it - just what I wanted many thanks
By reecec in forum Office Software
Last Post: 28th April 2010, 08:16 PM
By DaveP in forum Downloads
Last Post: 22nd December 2009, 05:05 PM
By mac_shinobi in forum Coding
Last Post: 13th August 2009, 12:23 PM
By wmabern in forum EduGeek Shutdownertron
Last Post: 14th January 2009, 06:43 PM
By Lithium in forum Windows
Last Post: 3rd December 2007, 09:57 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)