Copying a Hyperlink to Lots of Worksheets

Summary: Copying information from one place to another in a worksheet is easy. Copying hyperlinks may not seem that easy, but you can use the same editing techniques you use with regular information. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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:

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.)
Press Ctrl+C to copy the cell contents (the hyperlink) to the Clipboard.
Right-click one of the worksheet tabs at the bottom of the screen, then choose Select All Sheets.
Select cell D50.
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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3471) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Copying a Hyperlink to Lots of Worksheets