view exact range in cross sheet reference

Melinda Tempfli · 04/12/23

Hi All,

How can I see in a formula created by someone else what are the exact cells included in the range in cross sheet reference? I managed so far to identify the reference sheet, however in the edit reference range window it does not show what is the range used as of now.

Thanks!

Andrée Starå · 04/12/23

Hi @Melinda Tempfli

I hope you're well and safe!

Try accessing it again because sometimes it doesn't show the first time.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Melinda Tempfli · 04/18/23

Hello @Andrée Starå !

Thank for the reply. I have tried by now several times, and it doesn`t look to be working. Maybe I don`t know what to exactly look at, I am not sure... Could you share, by any chance, a print screen which works for you? Maybe this could help me...

Thanks!

Dale Murphy · 04/18/23

@Melinda Tempfli Do you have full access to the referenced sheet? Have you scrolled completely side to side to look for the column? That should reveal the selected range.

dm

Formulas and Functions

Formulas and Functions

view exact range in cross sheet reference

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Counting occurrences of a string in a row

Rounding to nearest Thursday in the past or current day if it's Thursday

JOIN function in a Sheet Summary