Copying a Hyperlink to Lots of Worksheets

Steven has a worksheet that has a hyperlink in cell B1. He wants to copy this hyperlink to cell D50 on each of the 75 worksheets in this particular workbook. He wonders if there is an easy way to do that.

Actually, there is a very easy way to do it, using editing techniques already familiar to most Excel users. All you need to do is follow these general steps:

1. Select cell B1. (You'll need to do this by clicking one of the cells next to B1 and then using the arrow keys to move into cell B1. If you simply click the cell, you run the risk of activating the hyperlink, which you don't want to do.)
2. Press Ctrl+C to copy the cell contents (the hyperlink) to the Clipboard.
3. Right-click one of the worksheet tabs at the bottom of the screen, then choose Select All Sheets.
4. Select cell D50.
5. Press Ctrl+V.

That's it. You end up with the hyperlink pasted into cell D50 on each and every worksheet. To go back to working on a single worksheet, click a single worksheet tab.