Making it clear what user may modify or spread formulas over

darenw

New Member
Joined
Jul 12, 2009
Messages
6
We have a complex spreadsheet where it's not always clear which cells should be modified and which should never be touched in normal use. It's especially error-prone to have an area filled with formulas, but due to a few exceptional cases some cells have just a number or something else.

Are there standard conventions that experienced spreadsheet designers follow to make it clear which cells the user is allowed to modify?

Then, when we modify the formula we need to drag the first cell out over the area. How do we avoid mowing over the cells with numbers for the exceptional cases? Or is there some entirely different strategy for dealing with these exceptions?
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

phxsportz

Well-known Member
Joined
Jun 11, 2006
Messages
1,985
Yes.. Lock and Protect the sheet. Only leave the cells unlocked if they are to be edited..
 

Watch MrExcel Video

Forum statistics

Threads
1,132,671
Messages
5,654,664
Members
418,147
Latest member
dorkas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top