0

Is there some way in Excel or Google Docs to copy the address of a cell?

I need to copy the address of a cell from another worksheet into a formula on the current worksheet. To do this, I have to manually enter in the address of that cell, copy the address, then paste it into the different parts of the formula. It would be easier if I could just select the cell and click to copy its address.

Is this possible in Excel? Or Google Docs?

0

You can do a paste special and paste the link and it will remember the cell reference.

So, select and copy the cell you want to, then right click the cell you want to reference from. Within paste special, you have the option to select link (on the bottom row of icons in Excel 2010)

Obviously, when you paste it, it will then reference the value of the cell so it may appear as if you've only copied and pasted the value, but if you navigate to the new cell, you will see an absolute cell reference.

If you experience an issue when pasting a range, that it tells you there are no links, then you have to paste it twice. The first paste will inform you there is no link to paste. On the second attempt of pasting, it works.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.