Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Remove Hyperlink From Multiple Cells In MS Excel 2007

It can be very tedious and time consuming if you are working on hundreds of cells and wish to remove hyperlink from each of them. It would take hours to complete the job manually, removing hyperlink from every cell and then moving onto the next, so here's what you need to do, if you wish to remove hyperlinks from multiple cells in one go, in MS Excel 2007. Let's take the example of this sheet as shown below, where we need to remove the hyperlink of three cells, together. Highlight the cells you wish to remove the hyperlink from. Right click and select "Copy" Next move to the area where you can paste those cells, Right click again and select the option "Paste Special" In the "Paste Special" dialog box that opens, under the "Paste" section, select the radio-button "Values" and click on "OK" The cells get pasted as values without a hyperlink Now copy and paste the cells back to where you got them from and there, your data is back without the hyperlink to them!
7 comments:

Thanks for this great tip! This can be an anoying problem but you explained the solution in a very clear way. Keep up the great posts!

We'd love to hear more from you at http://www.facebook.com/office

Cheers,
Andy
MSFT Office Outreach


Entirely our pleasure, Andy :-)


Thank you for this helpful.

Thought of course, for a piece of software that costs you a fair sum of money a "remove hyperlink" should not be too much to ask....


10x sir 4 da HOT TIP!!!!!!!!!!!!


Very helpful. Thanks.


Superb tip...Thanks a lot..


Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits