J
johnfli
Ok, I know how to Freeze x number of rows.
But I also want to Freeze a COLUMN also.
Is that possible?
if so, how?
But I also want to Freeze a COLUMN also.
Is that possible?
if so, how?
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.
D
David McRitchie
Hi John,
Select the column past the column you want to freeze to
--or--
select the row past the row you want to freeze to
--or--
select the cell past the column and row that you want to freeze to
More on the subject:
http://www.mvps.org/dmcritchie/excel/freeze.htm
Select the column past the column you want to freeze to
--or--
select the row past the row you want to freeze to
--or--
select the cell past the column and row that you want to freeze to
More on the subject:
http://www.mvps.org/dmcritchie/excel/freeze.htm
J
johnfli
Like I said, I know how to do one.
I need to do one AND the other. Not either or.
I need to do one AND the other. Not either or.
David McRitchie said:Hi John,
Select the column past the column you want to freeze to
--or--
select the row past the row you want to freeze to
--or--
select the cell past the column and row that you want to freeze to
More on the subject:
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Ok, I know how to Freeze x number of rows.
But I also want to Freeze a COLUMN also.
Is that possible?
if so, how?
J
johnfli
Guess I should have read all of what you suggested first. Sorry
It works fine.
Thank you
It works fine.
Thank you
David McRitchie said:Hi John,
Select the column past the column you want to freeze to
--or--
select the row past the row you want to freeze to
--or--
select the cell past the column and row that you want to freeze to
More on the subject:
http://www.mvps.org/dmcritchie/excel/freeze.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Ok, I know how to Freeze x number of rows.
But I also want to Freeze a COLUMN also.
Is that possible?
if so, how?