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

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

[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 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

[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

"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]

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.