
Cell References
How-to Show All Named Ranges/Formulas in a List
this will show you how to use the F3 key to paste a list of all the named ranges and defined names including formulas in Excel Spreadsheet

this will show you how to use the F3 key to paste a list of all the named ranges and defined names including formulas in Excel Spreadsheet

Using Function Key f3 in Excel to add Defined Names to Charts and Graphs

How to copy an Excel Chart and Range and paste into a new worksheet, but change the chart series to reference a the new range.