ExcelBanter - Locking Columns and rows

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

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

- - Locking Columns and rows (https://www.excelbanter.com/excel-discussion-misc-queries/225153-locking-columns-rows.html)

Lise

Locking Columns and rows

Hi

I can lock either the top row OR a specific column BUT I want to be able to
do both is this possible please
--
Thanks

Lise

Jacob Skaria

Locking Columns and rows

Dear Lise

You can lock any column or row..

But you can only freeze the top rows or left columns. For example if you
freeze panes from B2; then Row1 and Column A will get freeze.

If this post helps click Yes
--------------
Jacob Skaria

"Lise" wrote:

Hi

I can lock either the top row OR a specific column BUT I want to be able to
do both is this possible please
--
Thanks

Lise

All times are GMT +1. The time now is 10:41 PM.