Locking Worksheets

B

Bobbi Jo

Hi! I need to know how to lock cells in a worksheet. I
only want to lock specific cells!

Thanks!
 
R

Ron de Bruin

Hi Bobbi

Ctrl-a to select all the cells
Ctrl-1 and choose the protection Tab and unselect locked
Ok
Select the cells you want to protect
Ctrl-1 and choose the protection Tab and and select locked
Ok
Now protect your sheet (Tools-protection-protect sheet)
 

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
Proposal template with removable sections 0
2 Level Record Protection 0
Place picture in Excel cell 0
Cannot do anything after zooming - Publisher Lite on Mac 0
need help ASAP word 2016 recipient cant edit 0
Protected Sheet - Using Groups without a Macro 1

Top