Welcome Excellers to another #Excel #MacroMonday blog post in my 2020 series. Let's look at creating another Excel VBA Macro to delete obsolete items from your Excel Pivot Table. Let's speed up our...
Tag: Excel Tips
Formula Friday – Easily Identify Cells That Begins With A Specified Letter in Excel
Hello, Excellers. It is Formula Friday time again!. Do you need to identify with conditional formatting cells that begin with certain letters?. Today I will show you how Excel can easily identify...
Formula Friday – Prevent The Divide By Zero Error In Excel #DIV/0!
Hello, Excellers. So, welcome back to another Excel blog post in my #Excel Formula Friday 2020 series. Today, we deal with a formula error. Let me show you how to deal with the #DIV/0!, divide by...
Hello Excellers and welcome back to another #Excel #FormulaFriday blog post in my Excel 2020 series. Today I want to show you how to not only hide your Excel formula from users but lock those cells. ...
Macro Mondays – How To Remove All Hyperlinks From An Excel Workbook
Hello, Excellers. Welcome back t another #MacroMonday Excel blog post in my 2020 macro Series. I recently had this question submitted via email from a subscriber. How to remove all hyperlinks. ...
Evil Halloween Excel Trick-A Spreadsheet That Scrolls Backwards
Hello, Excellers. Want a Halloween trick Let's have a bit of fun and be a bit evil?. It is Halloween after all. How about a worksheet prank?. A spreadsheet that scrolls backwards with...