How do i lock sellected cells in a spreadsheet?

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

Guest

I need to lock some cells so other users cannot modify them. However, they
still need to modify other areas of the spreadsheet? Can i do this? If,
Yes... HOW?

Thanks...
 
Click the select all button above row one and to the left of the column
header A to select sheet
Menu Format>Cell>Protection, uncheck the Locked option, OK
Select the range of cells to be locked
Menu Format>Cell>Protection, check the Locked option, OK
Menu Tools>Protection>Protect sheet.
 
You must log in or register to reply here.

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

copy cells but lock editing 5
Last Modified By in a cell by user 3
locked cells helps/question 1
Locking Down Workbooks Properly & Disabling Functionality 2
Locking a format 1
Prevent Cell modification when Excel is executed 2
Protecting a Sheet 7
How do I set up worksheet to keep tabs from being deleted? 1

Back
Top