How to copy cell address in Excel

With this utility, you can copy cell or range address to clipboard and paste it as a regular, external and/or absolute reference.

How to copy cell address

  1. Select a single cell or a range of cells; use Ctrl to select several non-adjacent cells:
    Select the needed cell range.
  2. Click the Copy Address icon in the Utilities group on the Ablebits Tools tab:
    Copy address as a reference.
    The range reference is copied and can be pasted into any cell of your choice:
    Paste the copied cell or range reference in Excel.
  3. If you want to copy the address with its external and/or absolute reference, click on the little down arrow next to the add-in icon and select the option you need in the drop-down list:
    How to copy cell address as external or absolute reference.

    • To refer to the cell content from another workbook, select As External Reference in the list and paste the result to the needed place:
      Paste a range address as external reference.
    • If you want a reference to stay fixed on a specific cell or range, copy the absolute reference address to clipboard by picking the As Absolute Reference option:
      Paste a range address as absolute reference.
    • Choose to copy the range address As External and Absolute Reference to refer to exact cells and include Excel file and sheet names:
      Paste a cell or range address as absolute external reference.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.