Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 172
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to prevent Remove Split or Unfreeze Panes? dk_ Excel Discussion (Misc queries) 6 October 9th 06 08:35 PM
Disable Unfreeze Panes and Remove Split, how? dk_ Excel Discussion (Misc queries) 2 October 4th 06 10:57 PM
how to unfreeze the scroll bar? Moni Excel Discussion (Misc queries) 4 May 20th 06 08:30 PM
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell AP1927 Excel Discussion (Misc queries) 1 April 5th 06 05:17 PM
There is no freeze/unfreeze panes option in the windows menu amer Excel Worksheet Functions 1 March 24th 05 12:23 AM


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"