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.
Dave R shared a great hyperlink tip with Bill. Today, in Episode #1370, Build a Hyperlink with an email address; Use the =HYPERLINK Function, Concatenate your information and then click the link! It's simple and Bill shows us how to do it.
Today's Dueling Excel Podcast, Episode #1369, Looks at creating Data Bars. in Excel 2010 and earlier versions of Excel. Check out today's Dueling Excel Podcast to learn about the =REPT Function to create a Data Bar set in an early version of Excel.
The Scenaro? Brendan created a cool Formula about six (6) months ago. He edited that Formula today and it won't work anymore. In Episode #1368, Bill shows you why and how to correct the issue.
Wyatt asks if there is a way to have SmartArt float above a worksheet and always stay in view. Today, in Episode #1366, Bill shows us how to create a short macro to solve the problem, although not perfectly. ...Learn Excel 97-2007 from MrExcel.
Today we look at a question posed in Episode #1358 "How did Mike and Bill predict the Super Bowl winner?" Bill gives us the answer in Episode #1365 - and announces the winner of the contest.
Today's Dueling Excel, with Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen [Episode #1364]looks at selecting specific entries in a row and then concatenating those entries in one cell.
When should you use the Insert Hyperlink compared to the =HYPERLINK() function? In Episode #1363, Bill compares the two methods. Also learn how to build 100's of hyperlinks by concatenating together some text in quotes with values in a column.
Today, in Episode #1362, Bill shows us how to paste links with the 'Friendly Name', and then extract the actual 'URL' from the link. Also learn how to easily remove unwanted buttons, and graphics that are inadvertently copied into your workbook.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.