Range name

Kseniya Bondarenko

Hi everyone,

I have a question about the range name and description.

When I use formula with another sheet it calls automatically like {range Count}.

Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range name.

Could you please share with me whether it is possible to find the description of the range in { } somewhere?

For example: {range Count} = sheet "Name", range "Count:Count"?

Thank you!

Andrée Starå

Hi Kseniya,

The only places where you can see the reference is in the formula, or when you click on a cell, that's part of the formula. If you click on the links "Edit Reference" you'll open the "Reference Another Sheet" window where you can see and update the range.

It's also a best practice to rename the references to something better, so it's easier to work with.

1. You can optionally type a name for your reference. (If you don’t enter a name, the reference will be assigned a default name based on the sheet name and the number of times that sheet has been referenced.) 

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Kseniya Bondarenko

Thank you, it has really helped!

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Paul Newcome

I rename all of my references to "Sheet Name - Column Name" unless the range is not an entire column. In those cases I will use something specific to that range such as Row Number or even "Sheet Name - [Column Name]#:[Other Column Name]##".

 

If I am getting errors in my formulas I will use what Andree suggested and click on the "Edit Reference" link. When the sheet comes up, it will have a bold box around the range so you can make sure you actually selected the correct cells.