Hi, Excellers. Welcome back to another blog post in my new year of 2021 #MacroMonday Excel series. Today let's take a look at how to enable and also disable Macros in Excel. Now, Excel Macros can be used for good or not so good. So, as a consequence, you have a choice to enable them or disable them in Excel. We can also store them in trusted locations. With the release of Excel 2010, the security model changed significantly to previous versions. It introduced the concept of 'Trusted … [Read more...]
How To Use The Excel GETPIVOTDATA Function.
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 some confusion) I thought it was time to walk through GETPIVOTADATA . I therefore will use a sample Excel Pivot Table. So, read on to solve the GETPIVOTDATA issue. What Is The GETPIVOTDATA Function?. Have you heard of the GETPIVOTDATA function in Excel?. If you look up the Function in the … [Read more...]
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 laborious. So, let's take a look at automating with Excel VBA. This is an Excel query that one of my colleagues had to carry out manually every week. They needed to insert a blank row after every row in their range of cells. The range of cells which need a blank row inserted can vary in … [Read more...]
How to Delete Obsolete Items In Your Excel Pivot Table
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 Excel life. If like me you reuse Pivot Tables over and over again. Sometimes, your data source changes or products no longer being sold or one of your salespeople no longer working for you. You may find this happen especially if you use your Excel Pivot Table as a template that when your data is … [Read more...]
Formula Friday – 3 Ways To Protect Your Excel Formulas
Hi Excellers, this is a different #formulafriday in my Excel 2020 series. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up it up. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide themLock CellsHide The Formula Bar With Some Simple … [Read more...]
- 1
- 2
- 3
- …
- 93
- Next Page »
Recommended Excel Resources
