Column/Row Header Included in Named Range about columntools HOT 5 CLOSED

Hey Victor, Thanks for getting back to me! I greatly appreciate it! I can’t imagine that it would be too beneficial to have it included as an option. Whenever I create any named range, I normally don’t want to include anything in it beyond the data itself. If I’m using something like INDEX(namedrange1, MATCH(A1,namedrange2,0)) then it would be fine to include the header, but if I did something like COUNTA(namedrange1), then it could include the header in the calculation instead of just the data and throw off another formula. Also, the “create named range from selection” excel analog doesn’t give you the option to include the header in a newly created named range, but it does give you the option to make named ranges from columns and rows at the same time when you have an array selected. It’s a great add on! I use it (and named ranges in general) all the time! It has really helped me in transitioning from excel to sheets for everything. Thanks again for following up!

Thank you so much! Excited to use it! I really appreciate you making the update! Ryan Bailey