Q:
# How Do You Enter Multi-Word Names of Cells in Formulas Using Excel?

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 ReadingExcel 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-
Q:
## How Do You Remove Duplicates in Excel?

A: To remove duplicates in Excel, select the cells that include the duplicates, click on the Data tab, and select the Remove Duplicates option. Click OK on th... Full Answer >Filed Under: -
Q:
## What Is the Formula in Excel to Divide a Sum?

A: To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula... Full Answer >Filed Under: -
Q:
## How Do You Make a Simple to-Do List in Excel?

A: Creating a to-do list in Excel 2010 is as simple as clicking on the cells you want to enter data into and typing the data. Users can move to new cells by e... Full Answer >Filed Under: -
Q:
## How Do You Hide Cells in Excel?

A: To hide cells in Excel 2010, first identify the row or column you want to hide. With the row or column highlighted, select Format, Visibility and Hide Rows... Full Answer >Filed Under: