In Lotus 123 I used to be able to apply a range of names to an adjacent column of cells by selecting a range of names next to it. Is it possible to do the same in Excel 2010 please ?
For example by selecting the list of names below I want to apply these names to the cells B1 to B6 next to it... so that B1 has a range name of Oranges, B5 Limes and so on.
I've got several hundred range names I want to create so doing each one separately would be painful to say the least..
A1 Oranges
A2 Apples
A3 Pears
A4 Lemons
A5 Limes
A6 Bananas
Bookmarks