close

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?

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

quot;gregp22quot; wrote:

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

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 gt;
wrote:

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

quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote ...
gt; Freeze Panes will be unavailable(grayed out) if the Workbook is protected for
gt; Windows and Structure.

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()