Forum Discussion
Help Naming Cells in Excel
I am trying to name many cells in a spreadsheet so I can use those names in calculations on other worksheets within the same workbook. I've started naming the cell manually, but there must be an eas...
Hi Genieve,
Perhaps you may organise your data without naming. But if with names better to use intersection - for example for such data
name entire row 2 (or part of row 2 which covers your range) as Sandy, next row as Patty, etc. Name column B as Rate.
When you may use in formulas intersection of that named columns as on screenshot, not necessary to name each cell.
Also attached.