How do I lock certain cels i a worksheet

B

Buzz Local#30

I am wanting to lock up certain cells that are not being used in a wroksheet
so that those cells cannot be selected and have info entered in them?
 
G

Gord Dibben

By default all cells in a worksheet are locked when sheet protection is enabled.

It is up to you to decide which are to be locked or unlocked when the sheet is
protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

Then Tools>Protect>Protect Sheet.


Gord Dibben MS 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

ow do I lock up certain cells in a worksheet? 1
need help ASAP word 2016 recipient cant edit 0
Protecting worksheet. 1
Locking and Unlocking Cells via VBA 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Protection Tutorial 3
Allow VBA code to change a locked cell?? 3
protecting the entire worksheet 3

Top