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

How do I freeze the swimlane headers? 0
User controlled Freeze Pane while protected 3
Macro to Select text from a point given to a specific word 2
Text in note pane of "normal" display suddenly much larger 1
Freeze Panes loss 3
Freeze Panes 8
Hyperlink fails to open on the first click 0
Freeze Pane option in Vista 2

Top