Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

Excel Data

Copper Contributor

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

3 Replies

@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.
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.

@Garty1250 

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