Name A1 cell to MyCell
Click the Formulas tab.
When you want to insert a name,
click the Use in Formula button.
Click the name you want to use.
Or Click Paste Names,
select a name, and then click OK.