excel update hyperlink reference after adding rows or columns

To update a hyperlink reference in Excel after adding rows or columns, follow these steps:

1. Select the cell containing the hyperlink that you want to update.
2. Right-click on the selected cell and choose "Edit Hyperlink" from the context menu.
3. In the Edit Hyperlink dialog box, you will see the current reference in the "Text to display" field and the current address in the "Address" field.
4. To update the reference, you can manually change the text in the "Text to display" field to the new reference.
5. To update the address, you can manually change the text in the "Address" field to the new address.
6. After making the necessary changes, click on the "OK" button to apply the updates to the hyperlink.

By following these steps, you can easily update the hyperlink reference in Excel after adding rows or columns.