Excel Auto Resize Thumb

Auto resize an Excel spreadsheet to fill the screen

Every office I have ever worked in has been an equipment battleground.  It didn’t matter what the equipment was; it just had to be better than everybody else.  A new keyboard, a bigger screen, even a mouse mat with a wrist rest was enough to make everyone else jealous.  I was once lucky enough to Read More

Bulk-email-templates-thumb

Automatic e-mail template for Excel

If you speak to anybody who works in the accountancy field, they will always be talking about the “month end”.  In all medium and large companies there will be a process at each month end which requires statements to be issued and reports to be distributed.  This monthly process fills most finance people with a Read More

Excel settings you're not using Thumb

17 Excel settings you’re not using…but should be

If there is one thing Excel has in abundance, it’s settings.  To new and even experienced users, it can be overwhelming.  It is difficult to know which settings to use and when to use them.  In this post, I’d like to share a few settings you’re probably not using, but you might find useful.  They Read More

Resetting the scroll bar in Excel Thumb

Resetting the Scroll Bar in Excel

The horizontal and vertical scroll bars in the Excel window are set by the size of the used range (the range of cells containing any value, formula, formatting etc).  Occasionally, this range can become excessively large (normally by accident).  As a result, the scroll bar becomes tiny.  A small mouse movement in the scroll bar Read More

Change image based on cell value Thumb

3 ways to change an image based on a cell value

From stock parts to holiday villas, from employees to logos, there are many reasons you may want to automatically change an image based on a cell value.  In this post, we’ll explore 3 different methods to achieve this task: Named range + INDEX/MATCH + linked picture Chart fill + #N/A VBA User-Defined Function Each solution Read More

Reverse engineering a standard Excel Ribbon Thumb

Reverse engineering a standard Excel Ribbon

In July 2017, I released the Calc Buddy Add-in.  It’s a tool which monitors Excel’s calculation mode and shows a warning whenever it is different to the user’s preferred setting.  As I was getting the Add-in ready for release, I decided I wanted the button to be within the Calculation section of the Formula Ribbon.  Read More

Build your own Excel Add-in thumb

Build your own Add-in: Calculation Timer

In this post, I will show you, step-by-step, how to create an Add-in with its own custom Ribbon.  Rather than just creating an example Add-in which says, “Hello World!”, we will build something useful – a calculation timer.  The process of creating any Add-in will be similar, so you can apply these principles to your Read More