| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
freeze panes?
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
freeze panes?
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 "gregp22" wrote: 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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
freeze panes?
Freeze Panes will be unavailable(grayed out) if the Workbook is protected for
Windows and Structure. Gord Dibben MS Excel MVP On Fri, 31 Mar 2006 20:46:02 -0800, gregp22 wrote: 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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
freeze panes?
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. "Gord Dibben" <gorddibbATshawDOTca wrote ... 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 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I customize Freeze Panes in Excel? | Excel Discussion (Misc queries) | |||
| Excel should have a second 'Freeze Panes' option that works in re. | Excel Discussion (Misc queries) | |||
| Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
| How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
| Why does freeze panes work on one sheet but not on another in sam. | Excel Worksheet Functions | |||
Linear Mode
