Tuesday, November 12, 2013

How to Copy Paste Hyperlinks to Another Worksheet in Excel


1. Launch Microsoft Excel.
2. Select the worksheet tab at the bottom of the screen which contains the hyperlink you wish to copy.
3. Right-click on the cell containing your desired hyperlink and choose 'Edit Hyperlink.'
4. Select all of the data in the text field next to 'Address,' then press 'Ctrl C' to copy it.
5. Click the worksheet tab at the bottom of the screen which contains the cell to which you want to add your copied hyperlink.
6. Right-click on the cell and choose 'Hyperlink.'
7. Click inside the field next to 'Address' and press 'Ctrl V' to paste the hyperlink. Click 'OK' to close the hyperlink window.

Blogger news