How to transfer/copy range names with a worksheet to a new Excel f

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

Hello:
I have a large worksheet with about 200 named ranges. I would like to copy
this worksheet and all the range names to other Excel files (workbooks). How
do I do this?

(When I copy the entire worksheet to another file, the range names do not
transfer.)

Thanks, in advance, for your help.
 
I copy the worksheet in Excel 2007 with:

1) Right click on worksheet's tab, move or copy, new book, check make a
copy. I get all of the names in the new workbook.

2) I select all of the cells in the worksheet by clicking on the area to the
left of the column A header and above the row 1 header. (You can also select
all cells by pressing Ctrl+A once, perhaps twice) I open a new workbook. I
paste. All of the named ranges are there.

I don't know what you're doing

Tyro
 
How are you doing the copy?

Right-click on the sheet tab and select Move or Copy then checkmark in "Create a
copy" and select the workbook to copy to and OK

Range names go with the copy.


Gord Dibben MS Excel MVP
 
Thanks to All:

I have been copying by selecting all the cells in the worksheet by clicking
on the top left corner. Not using the Tab. Using the Tab, as suggested,
works.

Thanks, again.
 
So does the top left corner. You select all cells by doing that. Then you
copy. Then you paste in the new workbook

Tyro
 
Back
Top