+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    951
    Thank Post
    545
    Thanked 128 Times in 106 Posts
    Rep Power
    60

    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?

  2. #2

    Join Date
    Feb 2009
    Posts
    149
    Thank Post
    0
    Thanked 36 Times in 35 Posts
    Rep Power
    18
    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.

  3. Thanks to HilcrRWise from:

    BatchFile (2nd September 2010)

  4. #3
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    951
    Thank Post
    545
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Freeze panes - that's it - just what I wanted many thanks

SHARE:
+ Post New Thread

Similar Threads

  1. EXCEL - Recording survey details in excel - Easiest way
    By reecec in forum Office Software
    Replies: 2
    Last Post: 28th April 2010, 08:16 PM
  2. Replies: 1
    Last Post: 22nd December 2009, 05:05 PM
  3. Split into array ?
    By mac_shinobi in forum Coding
    Replies: 5
    Last Post: 13th August 2009, 12:23 PM
  4. [split] would love to try
    By wmabern in forum EduGeek Shutdownertron
    Replies: 2
    Last Post: 14th January 2009, 06:43 PM
  5. Split a screen
    By Lithium in forum Windows
    Replies: 6
    Last Post: 3rd December 2007, 09:57 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •