Posted to microsoft.public.excel.misc

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

Removing hyperlinks for all text in a colum shortkey

Copy an empty cell.

Select the column of hyperlink cells and Paste SpecialAddOKEsc

David McRitchie has code and more suggestion for dealing with hyperlinks.

http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

Gord Dibben MS Excel MVP

On Mon, 25 Jun 2007 13:27:00 -0700, coastal
wrote:

Is there a shortcut to removing the hyperlinks in a column so that there is
only text?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing Hyperlinks	Sloth	Excel Discussion (Misc queries)	2	October 5th 05 08:54 PM
removing hyperlinks	Laura	Excel Discussion (Misc queries)	1	June 9th 05 08:16 PM
removing hyperlinks	Gary's Student	Excel Discussion (Misc queries)	0	June 9th 05 07:29 PM
Hyperlinks - Turning off (Removing)	RWN	Setting up and Configuration of Excel	7	February 22nd 05 06:08 AM
Removing Multiple Hyperlinks	Olly	New Users to Excel	0	November 29th 04 11:17 AM

All times are GMT +1. The time now is 04:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us