Formula Friday – Randomly generate words in Excel with INDEX and RANDBETWEEN.
Are you looking for an easy way to randomly generate words in Excel? If so, you’re in luck! Using a combination of the INDEX and RANDBETWEEN functions together with some creative data entry...
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...
Hello Excellers and welcome back to another blog post in my series of #FormulaFiday #ExcelTips. Today, let's answer an Excel question from one of my subscribers. They want to be able to delete...
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...
Formula Friday – Why is my formula showing in a cell and not the result??
Hello Excellers. Welcome to another blog post article in my #Excel series. When you create a formula in Excel, you may expect to see the result of that formula immediately show up in the cell where...
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...