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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
freeze panes

ResolvedVersion Standard

Susan has attended:
Excel Introduction course

Freeze panes

How do you freeze panes vertically and horizontally?

RE: Freeze panes

Hi Susan, Thank you for your post, welcome to the forum, in answer to your question, to freeze panes in a worksheet consider the location of the active cell, when you freeze a pane; you lock the cells to the left of and above this cell. To freeze the area required, select the cell as per above, then go to the menu command Window> Freeze Panes, you can now scroll left and right and up and down in your worksheet with the selected area always in view. To remove the Freeze go to the command Window> Un Freeze panes.
Take a moment to try the other option which is Split this allows you to view different areas of the worksheet at the same time. I hope that helps, best regards Pete.

Excel tip:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

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.09 secs.