MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Morning all
Can any of the Excel gurus on here tell me if it is possible to set up a spreadsheet so that the majority of the cells are password protected but some of them remain unprotected so that data can be entered into them without the need for a password.
Does that make sense?
(I'm using Excel in O365 btw)
Ta in advance.
Yep, Right click in cell(s), format cells, protection, untick 'Locked'. When you protect the sheet those cells will still be unlocked.
Unless someone pastes into them after copying from a locked cell on another sheet, in which case they inherit the 'Locked' property from that.
You can "open in Excel" rather than in Excel online to protect a single worksheet.
input on an unlocked sheet, all the sensitive stuff (calcs, data etc) on another (hidden) sheet in the workbook that references the unlocked data
Cheers all. That works a treat.
Worth looking at Forms in o365 too. It can stick the input into a spreadsheet for you.