Forum Discussion
Garty1250
Jan 05, 2024Copper Contributor
Excel Data
I need assistance with Naming a sell in my spreadsheet. I can provide a copy of the spreadsheet.
HansVogelaar
Jan 05, 2024MVP
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.
- Garty1250Jan 05, 2024Copper ContributorI 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.
- HansVogelaarJan 05, 2024MVP
Please explain as clearly as you can what you want to do.