By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-range-names-scope/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

In Excel you can create range names scoped either to a workbook or to a specific worksheet. This video shows you how to choose the scope of a name and explains why you might need worksheet-scoped names in the first place.

Chapters
00:00 Topic list
00:40 Creating and Using Named Ranges
02:25 Worksheet Scoped Names
05:17 Referring to Different Scopes
06:12 Changing the Scope
09:43 Using a Temp Worksheet
12:32 Duplicating Sheets and Names
16:28 Danger of Duplicating Names
19:37 Deleting Sheets and Names

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!