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

excel training courses - freeze panes

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

excel training courses - Freeze Panes

ResolvedVersion 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:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

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.