Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sandy63
 
Posts: n/a
Default Trying to freeze panes. line down and through middle of worksheet.

I am learning how to use excel properly and am trying to freeze panes. When i
tried to do it the other day i did it with no problems, today i am trying to
do it and every time i click on freeze pane i get a line down the middle and
a line accross the middle and that is were it freezes. How do i stop this
please.
  #2   Report Post  
bj
 
Posts: n/a
Default

you probably have your cell selection on A1 when you freeze this makes it
feeze in the middle of the screen
you need to have a cell selected below or to the right of the area you want
to freeze

"Sandy63" wrote:

I am learning how to use excel properly and am trying to freeze panes. When i
tried to do it the other day i did it with no problems, today i am trying to
do it and every time i click on freeze pane i get a line down the middle and
a line accross the middle and that is were it freezes. How do i stop this
please.

  #3   Report Post  
Sandy63
 
Posts: n/a
Default

Thanks for that. Yes you were right.

"bj" wrote:

you probably have your cell selection on A1 when you freeze this makes it
feeze in the middle of the screen
you need to have a cell selected below or to the right of the area you want
to freeze

"Sandy63" wrote:

I am learning how to use excel properly and am trying to freeze panes. When i
tried to do it the other day i did it with no problems, today i am trying to
do it and every time i click on freeze pane i get a line down the middle and
a line accross the middle and that is were it freezes. How do i stop this
please.

  #4   Report Post  
Paul Sheppard
 
Posts: n/a
Default


Sandy63 Wrote:
I am learning how to use excel properly and am trying to freeze panes.
When i
tried to do it the other day i did it with no problems, today i am
trying to
do it and every time i click on freeze pane i get a line down the
middle and
a line accross the middle and that is were it freezes. How do i stop
this
please.


Hi Sandy

You need to click in the cell 1 to the right of the column you want to
freeze and 1 below the row you want to freeze

Eg to keep column A and Row 1 visible when scrolling click in B2 and
freeze panes


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=466754

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



All times are GMT +1. The time now is 04:00 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"