Spreadsheet Design & Auditing Tips

Method Three: Use the name box on the Excel 5 formula bar. In the example here you might highlight A1:B2, then click in the part of the formula bar that now holds the cell reference A1 and type in a name for the range, like Constant_data. ... An absolute cell reference is indicated by putting a dollar sign before the row and column reference ... ................
................