#1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Freeze Panes?

Excel2003 ... I am working in a "Shared" WorkBook & I can not seem to Freeze
Panes correctly??? ... I know how to Freeze Panes, but each time I Freeze
Panes the "Freeze" occurs somewhere else???

I select entire WorkSheet ... I select "UnFreeze Panes" ... I select Row 1
.... I Freeze Panes ... Instead of Freezing just Row 1 ... A random Row might
Freeze (Like 65) ... & perhaps a random Col (Col H).

I do not understand this behavior ... although I do not generally work in a
"Shared" WorkBook either.

Help from the Masters of this board would be welcome ... Thanks ... Kha
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Freeze Panes?


You can't select Row 1 and apply "Freeze Panes"

Select Row 2 and apply to freeze all above. Or just select A2 and
freeze panes.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115474

  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Freeze Panes?

What I did "Freeze" was my Brain ... A2 it is ... Thanks ... Kha

"Ken" wrote:

Excel2003 ... I am working in a "Shared" WorkBook & I can not seem to Freeze
Panes correctly??? ... I know how to Freeze Panes, but each time I Freeze
Panes the "Freeze" occurs somewhere else???

I select entire WorkSheet ... I select "UnFreeze Panes" ... I select Row 1
... I Freeze Panes ... Instead of Freezing just Row 1 ... A random Row might
Freeze (Like 65) ... & perhaps a random Col (Col H).

I do not understand this behavior ... although I do not generally work in a
"Shared" WorkBook either.

Help from the Masters of this board would be welcome ... Thanks ... Kha

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
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 02:07 AM
Freeze panes swati Excel Worksheet Functions 4 December 7th 09 10:06 PM
Freeze Panes Dave Excel Discussion (Misc queries) 5 May 27th 09 09:41 AM
freeze panes? gregp22 Excel Discussion (Misc queries) 1 April 2nd 06 05:15 AM
freeze panes? gregp22 New Users to Excel 3 April 2nd 06 02:37 AM


All times are GMT +1. The time now is 02:55 PM.

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"