ExcelBanter - Locking rows and columns

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

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

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

AllieR

Locking rows and columns

Is there any way to lock specific rows and columns? I want the header rows to
not be able to be deleted or moved...how do I do that?

David Biddulph[_2_]

Locking rows and columns

Look up "protection" in Excel help.
--
David Biddulph

"AllieR" wrote in message
...
Is there any way to lock specific rows and columns? I want the header rows
to
not be able to be deleted or moved...how do I do that?

Suleman Peerzade[_2_]

Locking rows and columns

Hi,
You need to protect the sheet in order to do that. ToolsProtect worksheet
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

"AllieR" wrote:

Is there any way to lock specific rows and columns? I want the header rows to
not be able to be deleted or moved...how do I do that?

All times are GMT +1. The time now is 06:14 PM.