They are commonly used in formulas like =SUM(First Quarter Sales), where the name "First Quarter Sales" refers to cells C5: F5, for example. Now, the name "First Quarter Sales" refers to cells C6: F6.
By using the range name "First Quarter Sales," we can ignore the actual address of the cells to which the name refers, which can change as you insert/delete rows/columns or otherwise change the structure of your workbook.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
To review your linked resources, use the same procedure that enables you to update your links. In the Related Documents section at the bottom, click on "Edit Links to Files." 2.
Click on one of the links in the Links dialog box to display the file's source location and data type.
If you link Excel files to Power Point presentations often, you will soon find it doesn’t always behave how you might expect.
AKA: Everything You Were Afraid To Ask Brian Reilly About Excel Charts, But That's OK, 'Cause He's Gonna Tell You Anyway.