W
Wendj421
I would like to freeze the first column and the header line. How do I do this. I can freeze either one but not at the same time. Does anyone have any ideas, or is this impossible.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
- move the cursor to cell B2
- goto 'Windows - Freeze Panes'
It will freeze all rows above the current cursor position and all
columns left to this position
- move the cursor to cell B2
- goto 'Windows - Freeze Panes'
It will freeze all rows above the current cursor position and all
columns left to this position
J
Job
Hi,
Assuming that the column you want to freeze is "A" and the row is "1
then go to cell "B2" and do Windows->Freeze Panes....or am I missin
what you're trying to do?
Cheers,
Jo
Assuming that the column you want to freeze is "A" and the row is "1
then go to cell "B2" and do Windows->Freeze Panes....or am I missin
what you're trying to do?
Cheers,
Jo
W
wendj421
Frank I have tried that, but can only freeze one item at a time.
If I want first column I can do that, but if I want header and first column, wont work.
It is because I am trying to freeze a header...........???
If I want first column I can do that, but if I want header and first column, wont work.
It is because I am trying to freeze a header...........???
F
Frank Kabel
Hi
move the cursore first to cell B2 and try again
move the cursore first to cell B2 and try again
F
Frank Kabel
Hi
where did you place the cursor?
Windows - Freeze will freeze all rows above this cursor and all columns
left to this cursor position. So if you place the cursor in B2 this
will freeze row 1 and column A. Just try it
where did you place the cursor?
Windows - Freeze will freeze all rows above this cursor and all columns
left to this cursor position. So if you place the cursor in B2 this
will freeze row 1 and column A. Just try it
W
wendj421
I have tried it
I do know that I need to be to the right of the column and under the header too. But cant seem to make both of them stay at the same time. Like I said I can do one but not both together
thanks
I do know that I need to be to the right of the column and under the header too. But cant seem to make both of them stay at the same time. Like I said I can do one but not both together
thanks
F
Frank Kabel
Hi
this is strange. what happens exavtly if you apply 'Freeze Panes' this
way. What do you mean with 'dont stay at the same time'.
You may send me your file and I'll have a look at it
this is strange. what happens exavtly if you apply 'Freeze Panes' this
way. What do you mean with 'dont stay at the same time'.
You may send me your file and I'll have a look at it
G
Guest
You can select both the column and the header at the same
time by holding the CTRL key and clicking.
Click on the first, hold CTRL, then click again.
at the same time. Does anyone have any ideas, or is this
impossible.
time by holding the CTRL key and clicking.
Click on the first, hold CTRL, then click again.
line. How do I do this. I can freeze either one but not-----Original Message-----
I would like to freeze the first column and the header
at the same time. Does anyone have any ideas, or is this
impossible.
R
rchu18
I have also tried the B2 and Freeze Pane and it works fine. The firs
Row or Header is Frozen and the First Column
Row or Header is Frozen and the First Column
R
rchu18
Actually the using the B2 pane freeze holds the header when scrolling u
and down but not when scrolling left and right. same with the column
but scolling the opposite way
and down but not when scrolling left and right. same with the column
but scolling the opposite way