LOCK columns

R

Rebecca

Hi. Can the contents of columns in Excel be locked (as in ACCESS) to prevent
accidental changes to the data? Thanks.
 
G

Gord Dibben

Rebecca

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
How to clear areas of a locked Doc after each use-- 0
Format column widths from one table to a separate table on same page 1
2 Level Record Protection 0
Place picture in Excel cell 0
Accidentally clicked 'Don't Save' on a new Powerpoint presentation! Please help! 0
Cannot do anything after zooming - Publisher Lite on Mac 0
Column misalignment 0

Top