ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I unfreeze columns (https://www.excelbanter.com/excel-discussion-misc-queries/143139-how-do-i-unfreeze-columns.html)

Steve

How do I unfreeze columns
 
Office 2000 - Excel: My worksheet is frozen at Column U. I cannot view
anything to the left of column U. The 'Freeze Pane' command is grayed out,
so it cannot be used.

Simon

How do I unfreeze columns
 
Have you tried ticking the top left hand corner box and unfreezing frames

"Steve" wrote:

Office 2000 - Excel: My worksheet is frozen at Column U. I cannot view
anything to the left of column U. The 'Freeze Pane' command is grayed out,
so it cannot be used.


Gord Dibben

How do I unfreeze columns
 
Steve

Sounds like A:T are hidden or set to 0 width and the workbook protection enabled
for structure and windows.

See if the protection can be removed if enabled.

If so, in namebox type A1:T1 and ENTER then FormatColumnUnhide


Gord Dibben MS Excel MVP

On Thu, 17 May 2007 10:33:03 -0700, Steve
wrote:

Office 2000 - Excel: My worksheet is frozen at Column U. I cannot view
anything to the left of column U. The 'Freeze Pane' command is grayed out,
so it cannot be used.




All times are GMT +1. The time now is 09:23 AM.

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