ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze Panes (https://www.excelbanter.com/excel-discussion-misc-queries/185929-re-freeze-panes.html)

Woody

Freeze Panes
 
Hi trying to freeze top row so that it will stay when I scroll seen all good
advise etc but the button for freeze frame on the task bar is in grey and
will not let me do anything any help on how to 'unlock' this button to
activat the freeze pane
--
thanx


"rexmann" wrote:

Hi all

When I freeze panes it freezes the first six or seven columns. How do I
freeze just the first column or row?

any help appreciated

Rexmann


Gord Dibben

Freeze Panes
 
Could be the workbook is protected under ToolsProtectionProtect Workbook.


Gord Dibben MS Excel MVP

On Fri, 2 May 2008 05:05:01 -0700, woody
wrote:

Hi trying to freeze top row so that it will stay when I scroll seen all good
advise etc but the button for freeze frame on the task bar is in grey and
will not let me do anything any help on how to 'unlock' this button to
activat the freeze pane




All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com