Join my free tech newsletter: https://got-sheet.beehiiv.com/ Naming ranges in Google Sheets and Microsoft Excel can save a ton of time and energy. It keeps things organized very well and allows for functions to be more user-friendly and readable while being less prone to typos.

And wouldn’t you know it, I’ve been doing it wrong all these years! There’s a much faster way than going into the Data menu. Simply type in the name of the range in the top left of the screen where it identifies the range of active cells!

Link to the spreadsheet example: https://docs.google.com/spreadsheets/d/1WnsZQp9xZqOVkDtQbv2K68rDr_amkEcAcdpkPUOE1nI/edit?usp=sharing

Please subscribe to my channel for more coding and spreadsheet content: https://www.youtube.com/@eamonncottrell?sub_confirmation=1

You can find more of my work including articles and podcasts on my website at https://www.eamonncottrell.com/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.