non-obvious excel tip of the day

I’m working on my fantasy football draft in Excel. Part of the job is sourcing material by copying and pasting from web sites. But since the sites have links to the players detailed info, it makes working with them in Excel difficult. I needed to remove a bunch of hyperlinks at once and the stuff I tried didn’t work. Not one to ask for directions I reluctantly asked Excel’s help to point me right in the right direction. Here is what they suggest:

Deactivate several hyperlinks at once

  1. Type the number 1 in a blank cell, and right-click the cell.
  2. Click Copy on the shortcut menu.
  3. While pressing CTRL, select each hyperlink you want to deactivate.
  4. Click Paste Special on the Edit menu.
  5. Under Operation, click Multiply and then click OK.

Huh.

Published

4 comments

Leave a comment

Your email address will not be published. Required fields are marked *