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

Excel FILES Function Thumb

Excel function to list files in a folder without VBA

Listing the files in a folder is one of the activities which cannot be achieved using normal Excel formulas.  I could tell you to turn to VBA macros or PowerQuery, but then any non-VBA and non-PowerQuery users would close this post instantly.  But wait!  Back away from the close button, there is another option. For 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

Spreadsheet-Day-17-October-Thumb

Spreadsheet Day 2017

Happy Spreadsheet Day! What are your feelings about allocating days to celebration or awareness of certain things?  Like International Talk Like a Pirate Day (19th September), Oatmeal Nut Waffles Day (11th March) or Bathtub Day (7th October)?  Well, the 17 October is International Spreadsheet day.  Normally, I would think these days are pointless, but I 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