How to protect excel cells and sheets to avoid formulas being overwritten.
In Excel it is possible to protect excel cells against being overwritten or changed. This is particularly important if your spreadsheet has inputs that can change, but formula that should not, and you want to stop people accessing them and making changes.
In this example we have two sections here, the light blue section indicates that these are input areas where it is possible for users to make changes, and here we have formulas which we’d like to control access to, so that users cannot change them.
It is very important to understand this, that in Excel when you protect a sheet Excel assumes that every single cell will be protected, unless you tell it otherwise.
So in order to differentiate between input cells that can be overwritten, and formula cells that need to be protected we need to do the following, but first let us unprotect the sheet
Now that you have told Excel which cells need to be unprotected you can now
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd