How do you enter multi-word names of cells in formulas using Excel?


Quick Answer

Cell names in Excel may not include spaces, so any multi-word cell name must be written with underscores or another appropriate symbol in place of spaces. The cell name can be used in a formula in the same manner as the cell coordinates. For example, if cell A1 were designated as "2016_profits" then the formula to add cell A2 and A1 would be "=A2+2016_profits".

Continue Reading

Full Answer

Excel also includes a button to insert a named cell into a formula quickly. In Excel 2007, 2010, 2013 and 2016, this button is located under the Formulas tab in the Defined Names section and is labeled Use in Formula.

To define a name for a single cell or selection of cells, click on the Define Name button in the Formulas Tab. Enter the desired name and set whether the name will apply to the current sheet or to the entire workbook. The former may be used to have "profit" be a named cell in several different sheets, each representing a different time period.

To reference another worksheet, which may have spaces in their names, wrap the name in single quotation marks. For example, a formula referencing the cell A1 on the worksheet 2016 Invoices would include "='2016 Invoices'!A1".

Learn more about Software

Related Questions