Updates since publishing this video (there will also be popups in the video): - Google allowed to have spaces in Tables' names. In the automatically created range names spaces will be replaced by underscores. - IMPORTRANGE now supports Table references.
This feature has made organising data collected from an online Google Form so much easier. I had used Query, but that was quite confusing for other users.
![The Power of Named Ranges in Google Sheets [2024]](/img/n.gif)
Updates since publishing this video (there will also be popups in the video):
- Google allowed to have spaces in Tables' names. In the automatically created range names spaces will be replaced by underscores.
- IMPORTRANGE now supports Table references.
great video! thanks. Please keep posting more about this.
Thanks, will do!
❤ can't wait for the next tips!
many useful info you have in your video thank you..
Happy to hear that, thank you for watching!
This feature has made organising data collected from an online Google Form so much easier. I had used Query, but that was quite confusing for other users.
Indeed, structured tables turned out surprisingly useful in many cases. After you get used to how the look )