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.

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.

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.

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