excel training courses - freeze panes

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Freeze Panes

excel training courses - Freeze Panes

resolvedResolved · Low Priority · Version Standard

Cindy has attended:
Excel Introduction course

Freeze Panes

How do I Freeze panes?

RE: Freeze Panes

Hi Cindy,

To freeze panes you are freezing everything to the left of your cursor and everything above you cursor. So if you want to keep rows 1 and 2, click on the row heading 3 and go into Window and down to Freeze Panes. If you wanted to keep column A click in the column heading B and go to Windows, Freeze Panes. If however, you wanted to do both rows 1 and 2 and column B, all you would need to do is put your cursor in cell B3.

Good luck and I hope that helps

Tracy


 

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips


Server loaded in 0.07 secs.