Excel Data

Copper Contributor

I need assistance with Naming a sell in my spreadsheet. I can provide a copy of the spreadsheet.

3 Replies


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.