Excel Data
I need assistance with Naming a sell in my spreadsheet. I can provide a copy of the spreadsheet.
Forum Discussion
Select the cell.
Method 1:
- Click in the name box on the left hand side of the formula bar.
- Type the name you want to assign to the cell.
- Press Enter.
Method 2:
- Activate the Formulas tab of the ribbon.
- Click Define Name.
- Enter the name you want to assign in the Name box.
- The cell address should already be in the Refers to box.
- Click OK.
- I already have formulas in the fields. For whatever reason, it is not reading it properly. I have used this dataset since 2017. I cannot remember how I revised cells.
Please explain as clearly as you can what you want to do.
