Скачать или смотреть Excel - Delete Hyperlinks: Episode 1371

Microsoft Excel Tutorial: Clear Hyperlinks in Excel | Easy Tips & Tricks | MrExcel Podcast.

Welcome back to the MrExcel podcast, where we bring you the latest tips and tricks for mastering Excel. In this episode, number 1371, we'll be discussing how to clear hyperlinks in your spreadsheet. This is a common issue that many Excel users face, and we have some great solutions for you, especially if you're using Excel 2010.

Have you ever been typing away in your spreadsheet and suddenly realize that there are hyperlinks scattered throughout? It can be frustrating to have to manually remove each one, but fear not, because Excel 2010 has some new features that make this process much easier. Now, when you have a selection of cells with hyperlinks, you can simply right-click and choose "Remove Hyperlinks" from the bottom of the menu. Alternatively, you can use the eraser icon in the Editing group on the Home tab to clear hyperlinks and formats at the same time.

But what if you're using an older version of Excel? Don't worry, we've got you covered. You can use a simple macro to delete all hyperlinks in your selection. Just press Alt+F11 to open the Visual Basic Editor, then press Ctrl+G to open the immediate window. Type in the code "for each hl in activesheet.hyperlinks : hl.delete : next" and press Enter. Voila, all your hyperlinks are gone! However, we highly recommend upgrading to Excel 2010 to take advantage of the new and improved features.

Now, you may be wondering how to prevent Excel from automatically creating hyperlinks in the first place. Well, we have a solution for that too. After a hyperlink is created, you can simply hover over the bottom left corner and click on the pop-up to turn off the feature. You can also go to the AutoCorrect options and disable it there. Just remember to use Alt+T+A to get back to this menu in case you accidentally turn it off during a podcast.

We hope these tips have been helpful in clearing hyperlinks in your Excel spreadsheet. Don't forget to subscribe to our channel for more Excel tips and tricks, and we'll see you next time for another netcast from MrExcel. Thanks for watching!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...


Table of Contents:
(00:00) Clear Hyperlinks
(00:20) Old method of removing hyperlinks
(00:30) New options for removing hyperlinks in Excel 2010
(01:17) Macro method for removing hyperlinks in older versions of Excel
(02:03) Importance of selecting entire cell to remove hyperlink
(02:44) How to prevent hyperlinks from being created in the first place
(03:20) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
AutoCorrect options for managing hyperlinks in Excel
Clear Hyperlinks in Excel 2010
Clearing hyperlinks and formats in Excel 2010
Clearing hyperlinks using VBA in Excel
Disabling hyperlink creation in Excel
How to delete hyperlinks in Excel 2010
How to remove all hyperlinks in Excel
Issues with removing hyperlinks in merged cells
Macro for removing hyperlinks in older versions of Excel
MrExcel podcast episode on clearing hyperlinks
Preventing automatic creation of hyperlinks in Excel
Remove Hyperlinks in Excel 2010


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...


Hyperlink haters Episode #1371 is for you! I cover the following topics: Deleting one hyperlink; Deleting a range of hyperlinks with Excel 2010 new features; Deleting all hyperlinks with a 1-line macro; How to stop Excel from creating the hyperlinks.