Is there a way that I can just insert "=" sign by a macro or so , so that A1 will then show =D1, A2 will then show =E2, AND A3 will then show =F3? In other words can we make actual references rather than just names by putting an "=" sign in the whole row or column?