Hyperlink Tip- Excel 2000

berg891832 · May 25th, 2002, 05:55 PM

When you have a large number of hyperlink cells going down the column in Excel 2000, it is difficult to remove the hyperlink from all the cells unless you do them one at a time. Instead, insert a column, (if needed) next to the hyperlink column. insert the formula =Cell, whereas cell is the cell address with the first hyperlink and copy it down. Example: The hyperlink is in cell A1, key =A1 into cell B1. The formulas return values and not links, then simply Cut and Paste Special as values over the real hyperlink range.

Bill

Tom Schreiner · May 25th, 2002, 06:01 PM

Good idea.
Thanks!
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 05:55 PM	#1
berg891832 Board Regular Join Date: May 2002 Posts: 508	When you have a large number of hyperlink cells going down the column in Excel 2000, it is difficult to remove the hyperlink from all the cells unless you do them one at a time. Instead, insert a column, (if needed) next to the hyperlink column. insert the formula =Cell, whereas cell is the cell address with the first hyperlink and copy it down. Example: The hyperlink is in cell A1, key =A1 into cell B1. The formulas return values and not links, then simply Cut and Paste Special as values over the real hyperlink range. Bill

May 25th, 2002, 06:01 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Good idea. Thanks! Tom