Forum Discussion
Reference a single named cell
I want reference a single named cell in a formula e.g. In cell A1:- =D1+Lunch this gives me an err #NAME? In Cell b1 is 34.5 This cell is named as 'Lunch' This works:- =D1+$B$1 . . . =D23+$...
- I am using Excel online . I do not see the menu bar you show. Where do I find "Formulas?
In Excel for web there is no Name Manager. You may define the name using Name Box under the grid on the left
After that staying on the cell you shall see the name, not address in the Name Box.
final formula works
- I click on cell B1 goto the box and type Lunch then ENTER but when I click back on cell B! the box shows B1 not Lunch
