In this blog post, I will show you how to easily remove multiple hyperlinks from an Excel workbook. I recently had this question submitted via email from a subscriber. They had a LOT of hyperlinks...
Tag: Blog
Formula Friday – Two Ways To Highlight Today’s Date In Your Excel Dataset
Hello, Excellers. Welcome to another instalment of #formulafriday. Today let's look at here a handy Excel Tip if you want to highlight today's date in your Excel data set. I have...
Macro Mondays – How To Add A Break Point To Your Excel VBA Code
Hello, Excellers. Welcome to another #MacroMonday blog post in my Excel series. Today let's look at breaking up our VBA code by adding a breakpoint to your Excel VBA code. If you're an Excel...
Formula Friday – Find And Hide All Formulas On An Excel Worksheet
Happy Formula Friday, Excellers. Formulas are a huge part of Excel, and they can be very helpful in organizing and analyzing data. However, sometimes you may need to hide them from view so that your...
Macro Mondays – Automatically Protect A Worksheet When You Close Your Excel Workbook
Hello Excellers, it is time for some more cool code in the #macromondays series. It can be a pain to remember to protect your worksheets every time you close your Excel workbook. But with a few...
Macro Mondays – Delete All Rows That Contain A Specific Text String
Hello Excellers, time for some Excel Macro fun again. Today's Excel Macro tip is one I have been looking forward to sharing with you for a while. Are you looking for a quick way to delete all...