Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft+excel+training - split screenfreeze panes

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Split screen/freeze panes

microsoft+excel+training - Split screen/freeze panes

ResolvedVersion Standard

Kate has attended:
Excel Intermediate course
Excel Intermediate course

Split screen/freeze panes

What is the difference between a split screen and freeze frame?

RE: Split screen/freeze panes

Freeze pane will lock all rows to the left and columns above the cell you select before freezing. This effectively cretes borders or title areas that do not move when you scroll.

Split actually creates 4 windows that you can independantly scroll to various parts of the worksheet

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.