Hello Excellers, welcome back to another #Excel #FormulaFriday blog post in my 2021 series of Excel formula tips. So, due to a colleague asking about the GETPIVOTDATA function (which seemed to cause...
Recent Posts
Macro Mondays – Insert A Blank Row After Every Row In The Selection.
Hello, Excellers welcome again to some more #MacroMonday Excel macro fun. I will who you how to insert a blank row easily into your Excel worksheet. Repeating this over and over again is very...
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...
Insert A Blank Row After Every Row In The Selection. Macro Solution.
Hello, Excellers welcome again to some more #MacroMonday Excel macro fun. I will who you how to insert a blank row easily into your Excel worksheet. Repeating this over and over again is very...
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...