Tip of the Day

Removing multiple hyperlinks from Excel file can be very frustrating - since Excel doesn’t have a feature that would allow to do it right away.

Here is a simple trick that will help you with that:

1. Type 1 in a blank cell

2. Right-click and select Copy on the context menu.

3. While pressing CTRL, select each hyperlink you wish to be removed (selecting the whole row or column will do)

4. On the Edit menu, select Paste Special.

5. Under Operation, click Multiply and then click OK.