Protecting specific columns within a worksheet
As default, excel will protect all cells on the worksheet, as you need to
protect just columns a, b and c, you should:
- seletct columns D until IV - right click -- Format Celss -- Protections
tab -- uncheck Locked box.
- now the range d1:iv65536 will not protected when you proteced the sheet.
Tools - Protection.
have notice passwords are easy broken..
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Deb" escreveu:
Hi,
I am using EXCEL 2003 and have been trying to protect the first 3 columns in
a worksheet so that no one can inadvertently change or delete the data.
However, when I do what "HELP" recommends all formatting is turned off for
the rest of the worksheet, i.e. bold, font color, etc.
Is there a way to protect specific columns from any input while at the same
time allowing the remaining columns to be formated in a single worksheet?
--
Deb
|