Yes, you can make the text in the VBA window easier to read. It is also great for training. (This tip may not work on 4K monitors.) To open the VBA Window press Alt + F11. Click the Tools menu and then Options - see image below. Click the Editor Format tab and change the Size drop down to 14, or whatever you want – see image below. Click OK and the font size will now be increased in the…
To insert a new folder in Windows File Explorer use Ctrl + Shift + N.
If you need to find the highest or lowest three entries in a filtered list you can use the AGGREGATE function to find them. (more…)
It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Click the materials Button below to download the pdf manual and example file. Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names. Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel. This is the first…
Who doesn’t get satisfaction from drawing a line through a completed task? That sense of achievement. Well you can do the same in Excel. (more…)
When you create an Excel file that handles inputs it is best practice to colour code the input cells. The colour you choose isn’t important but making sure you use it consistently is. You may need to unlock the input cells if you plan to add sheet protection to the file. Here’s a couple of ways to do that. (more…)