How to paste range names in Excel
By
SpreadCheaters
Page last updated:
16/11/2022 |
Next review date:
16/11/2024
You can watch a video tutorial here.
In Excel, names can be given to a cell or a range of cells. This proves very useful when copying the data to another location, especially when the volume of data is very high.
Step 1 – Check the list of range names for the sheet
– Go to Formulas > Defined Names > Name Manager
– Check the list of names available for the sheet
Step 2 – Paste the range in another location
– Go to the destination cell and type an equal sign (=)
– Go to Formulas > Defined Names > Use in Formula
– Select the range name required
Step 3 – Check that the range name has been pasted
– The named range is copied to the new location
