Excel Data

[Garty1250]

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

[#2]

@Garty1250 

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.

[#3]

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.

[#4]

@Garty1250 

Please explain as clearly as you can what you want to do.