freeze panes?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gregp22 - 01 Apr 2006 05:46 GMT

i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a
spreadsheet. for some reason, when i go to window, the freeze pane option is
faded. how do i get it to work?

Reply to this Message

Neil - 01 Apr 2006 07:29 GMT

Not sure exactly how this works on an the MAC version, but in the windows
version, highlight the rows or columns you want to freeze, then the freeze
panes option should be available to you.

HTH

Neil
www.nwarwick.co.uk

> i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a
> spreadsheet. for some reason, when i go to window, the freeze pane option is
> faded. how do i get it to work?

Reply to this Message

Gord Dibben - 01 Apr 2006 21:46 GMT

Freeze Panes will be unavailable(grayed out) if the Workbook is protected for
Windows and Structure.

Gord Dibben MS Excel MVP

>i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a
>spreadsheet. for some reason, when i go to window, the freeze pane option is
>faded. how do i get it to work?

Reply to this Message

David McRitchie - 02 Apr 2006 02:37 GMT

You can, however, turn off protection, freeze panes, and turn protection back on.
The Freeze Panes will remain in effect you just can't turn it on or off when protected.

> Freeze Panes will be unavailable(grayed out) if the Workbook is protected for
> Windows and Structure.

> On Fri, 31 Mar 2006 20:46:02 -0800, gregp22 <gregp22@discussions.microsoft.com>
> >i have an apple laptop, and i'm trying to use the 'freeze panes' feature on a
> >spreadsheet. for some reason, when i go to window, the freeze pane option is
> >faded. how do i get it to work?

Reply to this Message