Automatically Highlight The Column That Is Today – Formula Friday
Hello Excellers and welcome back to some more #formulafun. Todays' blog post was inspired by an article I read online where a user wanted to insert the word TODAY to be inserted into a cell that...
Create A VBA Macro To Re-Size All Charts In Your Excel Worksheet – Macro Monday
Hello Excellers, it is time for another #macromonday blog post. Today let's look at one handy little macro that will re size all charts on your Excel worksheet with the click of a mouse, or the...
Macro Mondays – A Macro To Delete All Blank Rows In Excel Worksheet
Hello Excellers, today let's look at a handy way to get rid of any blank rows on your Excel worksheet. We can do this with the click of a Macro. You may if you have used Excel for any amount of...
Sum Cumulatively Across Rows or Down Columns Of Data – Formula Friday
Hello Excellers and welcome back to another #formulafriday blog. Today's tip was a question from a colleague. Thye wanted to know how to calculate a cumulative or running total in your Excel...
Set Up A Dynamic Print Area In Your Excel Worksheet – Using A Small VBA Macro
Hello Excellers, welcome to another #macromondays blog post. I have a really nice little bit of VBA code for you today which allow you to set your Print area in your Excel worksheet to become...
Calculate How Long A Task Will Take Using CONVERT Function – Formula Friday
Hello Excellers, time for some more Excel formula fun on a Friday. What could be better?. In today's blog post let's look at a really handy Excel formula to help us to easily calculate how long...