Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|