Locking cells

F

filion.ron

I would like to lock all cells except the ones where I have cells set
up for entries. I don't want the non entry cells to be edited, because
I have formulas in there that I don't want changed.

Thanks, Ron
 
C

CyberTaz

Hi Ron -

The process may seem somewhat convoluted, but *all* cells are Locked by
default - it just doesn't go into effect until you turn Protection on:)
So...

Select the cells that need to remain editable then go to Format> Cells -
Protection. Remove the check for Locked. When finished go to
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

Top