ExcelBanter - freeze row and column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - freeze row and column (https://www.excelbanter.com/excel-discussion-misc-queries/87322-freeze-row-column.html)

00KobeBrian

freeze row and column

How can I freeze a row and a column at the same time using Excel 97? Thanks.

Ken Johnson

freeze row and column

Hi,
If you select B2 then go windowfreeze panes, that should freeze column
A and row 1.
Ken Johnson

00KobeBrian

freeze row and column

wonderful thanks.

"Ken Johnson" wrote in message
oups.com...
Hi,
If you select B2 then go windowfreeze panes, that should freeze column
A and row 1.
Ken Johnson

Ken Johnson

freeze row and column

You're welcome.
Thanks for the feedback.

Ken Johnson

All times are GMT +1. The time now is 06:42 AM.