See the attached List
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neelakanta AB Sent: Monday, August 01, 2011 3:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Remove HyperLink without Macro Hi Not able to work on the same format suggested. Share little more details for this it will be very helpful. Thanks! On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar <chandrashekarb....@gmail.com> wrote: Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance <samde...@gmail.com> wrote: Nice one XLS S On Jul 31, 10:41 am, XLS S <xlst...@gmail.com> wrote: > Dear All, > > Try this > > 1. In a blank cell, enter the number 1. > 2. Select the cell and press *Ctrl+C*. > 3. Hold down the *Ctrl* key as you click each hyperlink you want to > remove. > 4. Right Click and Choose Paste Special from > 5. Select the Multiply radio button (In Operations). > 6. Click OK. All the hyperlinks are removed, -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RemoveHyperlink.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
