For example, in a spreadsheet, if I have a cell that has a number, is there a way to name it for other cells to use this name as part of the formula?

Example: With the number 3% is in a cell, to name it as InterestRate or IR, and be able to use that in another cell: = SQRT(InterestRate) or = SQRT(IR)


From the Google Docs support page:

To Name a range

  1. Open a spreadsheet in Google Sheets.
  2. Select the cells you want to name.
  3. Click Data > Named ranges. A menu will open on the right.
  4. Type the range name you want.
  5. To change the range, click Spreadsheet Grid.
  6. Select a range in the spreadsheet or type the new range into the text box, then click Ok.
  7. Click Done.

For the full documentation on named ranges check Google Support.

| improve this answer | |
  • ok, so naming a value (or cell) is by naming a range – nonopolarity Jan 10 '17 at 16:37
  • That is correct – STowslee Jan 10 '17 at 16:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.