Replacing Names with References

maabbot

Board Regular
Joined
May 27, 2002
Messages
56
In excel you can easily replace cell references with names using the Insert, Name, Apply.

Does anyone know how you can do the reverse, that is change names back to their original refences?

Cheers
Mark
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,451
Messages
5,572,201
Members
412,447
Latest member
immy
Top