Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freeze Panes

Freeze Panes

ResolvedVersion 2008 (Mac)

Tue 29 Nov 2011, 11:35 Delegate Laura said...

Laura has attended:
Excel Introduction course

Freeze Panes

Hello

I am trying to freeze some panes vertically on the left hand side of my spreadsheet. I highlight all the columns I wish to freeze, however, it doesn't freeze them all, it stops and puts a grey line (like a page break) in the middle, and the rows below are not frozen. How can I make it so the columns freeze all the way down?

Many thanks,
Laura

Wed 30 Nov 2011, 16:09 Trainer Doug said...

RE: Freeze Panes

Hi Laura

To freeze panes vertically click in the top row one cell to the right of the columns to freeze.

Then choose View, Freeze Planes, Freeze Panes.

You may need to unfreeze panes first. Hope that does it!

Regards

Doug Dunn
Best STL

Tue 6 Dec 2011: Automatically marked as resolved.

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips

Freeze Panes

Freeze Panes

RE: Freeze Panes

Excel articles

Excel tip:

Change the default location for opening and saving spreadsheets