Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 04, 10:47 PM
Rasoul Khoshravan Azar
 
Posts: n/a
Default Remove link fr a column of entries

I know how to remove a link from a single cell. Right click, hyperlink,
remove hyperlink.
I have a column of cells and it is very cumbersome to remove cell by cell.
Is there any way to remove all cells in one action.?
TIA, Rasoul Khoshravan

  #2   Report Post  
Old December 18th 04, 11:51 PM
tjtjjtjt
 
Posts: n/a
Default

You can do this with a macro:

Sub RemoveHLinks()
Selection.Hyperlinks.Delete
End Sub

Just select the column first. If you aren't familiar with macros, look here
for some intro material:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

tj


"Rasoul Khoshravan Azar" wrote:

I know how to remove a link from a single cell. Right click, hyperlink,
remove hyperlink.
I have a column of cells and it is very cumbersome to remove cell by cell.
Is there any way to remove all cells in one action.?
TIA, Rasoul Khoshravan



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 17th 04 09:07 PM
Remove link fr a column of entries Rasoul Khoshravan Azar Excel Discussion (Misc queries) 1 December 17th 04 07:44 PM
Putting text in a column based on variable text from another colum Jacky D. Excel Discussion (Misc queries) 1 December 16th 04 07:09 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 04:19 PM


All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017