Password protect cells

Hi guys,

How do I password protect my cells A-H (PW to be test123) so that only certain users can edit it, but all users can edit cells IN I-K?

I am doing tests but not foundthe solution to achieve what i need



Thank you.

Sheet attached

Hi,

By default all cells are Locked when you switch on Sheet protection. So first use Format to unlock the cells to which you want to allow access. Think of it like an electric fence around a field. Animals are only retained when the current flows.

Leave the A-H cells Locked and unlock the I-K cells
Then Protect the sheet using a password.

See this link: https://support.microsoft.com/en-us/...3-042a5f2cd93a

You need to go down to: Unlock ranges on a protected worksheet for users to edit

thanks Richard with a bit of guesswork I got there.. think it works! thank you

Thanks for the rep.