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

[Guest]

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.

 

[Guest]

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

 

[Guest]

Thanks for that. Yes you were right.

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

 

[Paul Sheppard]

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.

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