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

How to copy cell address

1. Select a single cell or a range of cells; use Ctrl to select several non-adjacent cells:
   
2. Click the Copy Address icon in the Utilities group on the Ablebits Tools tab:
   
   The range reference is copied and can be pasted into any cell of your choice:
   
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:
   
   • To refer to the cell content from another workbook, select As External Reference in the list and paste the result to the needed place:
     
   • 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:
     
   • Choose to copy the range address As External and Absolute Reference to refer to exact cells and include Excel file and sheet names: