ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect column (https://www.excelbanter.com/excel-discussion-misc-queries/100034-protect-column.html)

Syahira

Protect column
 
Can anybody tell me how to protect a column in the shared workbook?

Thank You.(^_^)

Nika Lampe

Protect column
 
Hi,

select whole worksheet (or all of them), format - cells - protection -
disable "locked", then select column you want to protect and enable "locked"
(format - cells...) and then protect sheet/workbook.
Excel actually protects only the cells (in your case whole column) that have
selected Locked.

Regards,
Nika Lampe


"Syahira" wrote:

Can anybody tell me how to protect a column in the shared workbook?

Thank You.(^_^)



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com