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?
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?
