Trying to freeze panes. line down and through middle of worksheet.

S

Sandy63

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.
 
B

bj

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
 
S

Sandy63

Thanks for that. Yes you were right.

bj said:
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
Click to expand...
 
P

Paul Sheppard

Sandy63 said:
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 a
trying to
do it and every time i click on freeze pane i get a line down th
middle and
a line accross the middle and that is were it freezes. How do i sto
this
please.
Click to expand...

Hi Sandy

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

Eg to keep column A and Row 1 visible when scrolling click in B2 an
freeze pane
 
Top