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.
|
|
Unconditional 60-day money-back guarantee
|
Secure payment
guarantee |
Life-time license,
no additional fees ever |
Volume discounts: the more you buy, the less you pay
|
1 license for 2 or 5 PCs
or 1 server |
Free life-time support
|
Learn more
|
Buy now
|
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.
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.
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.
Of course. For this choose the Absolute Reference option.
In this case, copy the cell address as External and Absolute Reference.
Excel
|
Windows
|