freeze pane option not available

D

dave f

The freeze pane option is not highlighted on my toolbar. Consequently, I
cannot select it for use. As best as I can determine the worksheet is not
procted.
 
G

Gord Dibben

Worksheet protection will not disallow Freeze Panes.

Could be the workbook protection is enabled.

Tools>Protection>Unprotect workbook.

Or in 2007

Review Tab>Protect Workbook.


Gord Dibben MS Excel MVP

On Sun, 10 Jan 2010 13:31:01 -0800, dave f <dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User controlled Freeze Pane while protected 3
Freeze Panes 8
PowerPoint Freeze animation 1
Freeze Pane option in Vista 2
Freeze pane 3
freeze pane doesn't work in my excel 2007 2
Saving freeze pane worksheet 2
Split / Freeze Pane's 3

Top