Can I only lock most cells without having to make the spreadsheet password protected?
Answer Hi Tony, I think your best bet is to password protect the sheet, but if you have cells that you want to be edited, you can select those (highlight or choose individually) format cells/ protection and uncheck the “locked” selection prior to protecting the sheet. Then when you go to tools/protection, you can lock the sheet, but the cells you want to be editable will not be locked.