![]() If you'd rather have a relative named range, remove the $ sign from the reference (before you do this, make sure you fully understand how relative names behave in worksheets).Ĭompared to the previous method, using Define Name in Excel takes a few extra clicks, but it also provides a couple more options such as setting the name's scope and adding a comment that explains something about the name. By default, Excel creates a name with absolute references. Click OK to save the changes and close the dialog box.In the Refers to box, check the reference and correct it if needed.In the Scope dropdown, set the name scope ( Workbook by default). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |