Locking cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to protect a cell on a shared spreadhseet that can be locked
so no one else can change it? I am using excel 2007.
Thanks
 
Yes. You can right-click on the cell you want to protect, and choose Format
Cell. Click on the last tab, Protection, and make sure there is a check mark
next to Locked. Then you will have to protect the Sheet by going up to the
Review tab and clicking on Protect Sheet. You can customize your options and
even choose if you want to use a password.
 

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

function to download stock prices into Excel with 2007 1
locking formulas in Excel 2007 so users can't change but can vieworiginal formula? 1
I can still select & manipulate locked & protected cells in '07 1
Protected Sheets 2
Locking Cells 4
Cell protection short cut button 1
Array formula lock-up 1
Multi worksheet protection & editing ability 6

Back
Top