Copy cell address in Excel

And paste as external or absolute reference

Whenever you need to get cell addresses as references, use one of the three options provided by this tool. To refer to an individual cell or a range of cells from another workbook, choose External Reference. Want to have the reference fixed, select Absolute or External Absolute. Whichever option you choose, the address gets copied to the clipboard automatically. Need to use it in your formula? Click Paste! It's that easy.

Free download Ultimate Suite for:
2019 365 2016 2013 2010
Download this and 60+ other tools for Excel included in Ablebits Ultimate Suite

14-day fully functional version
Copy Address for Excel 2019, 2016 - 2010

With the Copy Address utility you will

  • Get address of a cell or range Select one or more cells, contiguous or non-contiguous, and get all their addresses copied to the clipboard in a single click.
  • Copy address as absolute cell reference In case you need a cell reference that won't change no matter where the formula is copied, paste it as an absolute reference.
  • Get address as external reference If you are going to refer to a cell or range from another Excel file, copy its address as an external reference.
  • Copy address as external absolute reference To fix the reference to a specific cell or a range of cells in a different workbook, use an external absolute reference.

Make an external reference in a click

Copy cell address as external reference
Copy cell address as external reference
Copy range address as external reference
Copy range address as external reference
Get addresses of all selected cells as absolute references
Get addresses of all selected cells as absolute references
Get addresses of the selected ranges as external absolute references
Get addresses of the selected ranges as external absolute references

License benefits

Our customers get

Unconditional 60-days money-back guarantee
Life-time license, no additional
fees ever
Free life-time support
Secure payment guarantee
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Copy Address and what do I need it for?

Copy Address is part of Ablebits Ultimate Suite for Excel. The utility helps to quickly copy and paste the address of a selected cell or a range of cells as an external or absolute reference. Besides, it can copy address as both external and absolute reference. If you want to link your datasets located in different worksheets and workbooks using formulas, the Copy Address plug-in will significantly save your time.

Can't I get cell address without any utilities?

Of course, you can. This can be done by using the Excel ADDRESS function. However, this function is not very comfortable to use when it comes to external references because you will have to type the workbook name manually, which is a slow and error-prone way. Our Copy address utility accelerates the process. Just one click – and the cell reference is copied the way you need it.

What if I need to refer to a cell from another worksheet?

Choose to copy your cell address as External Reference. This will copy the address of a selected cell(s) to the clipboard as an external relative reference. Then, right-click the target cell and click Paste or press Ctrl+V.

Can I get a fixed reference to the cell?

Of course. For this choose the Absolute Reference option.

What if I need to get an unchangeable reference to a cell in a different workbook?

In this case, copy the cell address as External and Absolute Reference.

Supported versions

Microsoft Excel

  • Excel included in ​Microsoft 365 (formerly Office 365)
  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • 32-bit and 64-bit
  • Note! Office Insider is not supported

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
  • Note! Windows insider is not supported
  • Note! Surface Pro X and Windows X are not supported

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.

Your message was successfully sent.

Thank you for contacting us!
We will get back to you shortly.

You will receive a delivery confirmation for your message within a few minutes. If you don't get it, please re-send your message and make sure you entered a valid e-mail address.

Close