Hello Excellers, and welcome back to another #FormulaFriday #Excel tip in my Excel series. Todays article walks you through highlighting cells on an Excel worksheet that are locked. As an Excel...

If you have many pivot table with filters, applying changes to them all can be time-consuming. Fortunately, there is an easier way! Using a macro in Microsoft Excel, you can quickly change all the...

Macro Monday time and that means some more Excel macros and VBA. Today let's look at a tiny Macro that pulls a punch. Are you a Microsoft Excel user who stares in frustration at your workbook,...

Do you find yourself trying to figure out the date of the a specific business day of a future month? If so, you’re not alone. It’s a question that can stump even the most experienced Excel users...

Are you regularly transferring files from one folder to another? Things can quickly become tedious and time-consuming - but not anymore! Excel VBA Macros enable an easy yet efficient way of copying...