how do I protect a column on a worksheet
on my worksheet, which anyone can use, how do I deny everyone from entering
data on 3 entire columns? these columns contain formulas that deal with the data entered in the other columns. |
how do I protect a column on a worksheet
1. unprotect both the workbook and worksheet
2. unlock all cells 3. select the 3 columns 4. lock the cells 5. protect the worksheet -- Gary''s Student - gsnu200795 "Sanjo" wrote: on my worksheet, which anyone can use, how do I deny everyone from entering data on 3 entire columns? these columns contain formulas that deal with the data entered in the other columns. |
All times are GMT +1. The time now is 07:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com