Select your block of data - head to the Formulas Ribbon and Create from Selection - this is the easiest way to get multiple names into a worksheet.
Then to Paste a Named Range into a Formula, F3 is the shortcut needed here!
Subscribe to our channel for quick tips and tricks and longer videos on Microsoft 365 - work smarter! Or get in touch for training at your workplace via our Live Webinar sessions - www.365traininghub.co.nz