Selecting ALL names when using Insert/Names/Apply

M

Mike

Hello,

Is there any way to select all names in the name list with out having to
click on each name individually when using Insert/Names/Apply?? I wonder why
the CTRL and SHIFT options are not allowed?

Thanks in advance. Mike
 
G

Gord Dibben

Mike

Whay would you want to select all the names?

Perhaps there is something else can be done to achieve your goals.


Gord Dibben Excel MVP
 
M

Mike

I have 17 workbooks with up to 8 sheets each and over 500 names in each
workbook. But I need to replace(using APPLY) all the cell locations in all
the calculations. I just want to highlight each sheet and APPLY all.

Thanks. Mike
 
Top