In Google Sheets, when I start to enter a formula and want to insert the reference to a cell, I just click on that cell and get the reference by row and column. However, if the cell is the part of Named Range it would be nice to get that Range Name on click. Is it possible?

In addition, I tried to click on the right panel with list of all Named Ranges, and once again I get ref by row and column (not by Name of the range).

How to get Name of the range with mouse clicking for referencing?

  • Since a cell could be part of multiple named ranges, there isn't a logical way to give a name of a range upon a cell click.
    – user79865
    Commented Nov 14, 2015 at 22:49
  • @NormalHuman Ok, but what with the list of defined ranges and I click at the name of the range?
    – vatavale
    Commented Nov 15, 2015 at 4:26

1 Answer 1


At this time it's not possible. You should consider to send comments to Google asking to include the features you are asking for.

Google Sheets users could send comments to Google from a Google spreadsheet by

  1. Open a spreadsheet
  2. Click on Help > Report a problem.
  3. Fill and submit up the Google Feedback form.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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