Define a named range in Excel with the Refers to field showing a workbook and sheet reference.
Dialog box for naming a defined name in Excel, showing fields for Name, Scope, Comment, and Refers to, with the formula = [SourceWorkbook.xlsx]Sheet1!$A$1 highlighted.
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #586242