Constants should be in a separate sheet named 'config', 'constants', or the like. Alternatively, in Excel, one can define names with values that aren't stored in a cell (one can enter 42 or sin(d3) in the text box where one can edit name values in the 'Name Manager'h
Disadvantage is that such constants won't be visible when looking at formulas in other sheets. That's why Apple's Numbers spreadsheet allows for multiple tables in a sheet.
Comments
Constants should be in a separate sheet named 'config', 'constants', or the like. Alternatively, in Excel, one can define names with values that aren't stored in a cell (one can enter 42 or sin(d3) in the text box where one can edit name values in the 'Name Manager'h
Disadvantage is that such constants won't be visible when looking at formulas in other sheets. That's why Apple's Numbers spreadsheet allows for multiple tables in a sheet.
Excel's solution for that problem is he table (http://office.microsoft.com/en-001/excel-help/overview-of-ex...) if you are willing to transpose rows and columns, theta might come close to what you want.