Following on from the previous entries ( * see page list ) , in this post, we'll be looking at a few more methods to colour ranges / cells to achieve easy visual categorisation. Here's a few quick scripts / examples that you can use in your own projects. These... Read more
Have you ever wanted to spell out a number as words , perhaps for reporting / automated form filling ? This script / UDF takes some cues from the various scripts out there, however they didn't cover numbers beyond a billion, decimal places beyond two, and often appended currency names... Read more
Have you ever been frustrated scrolling through a huge spreadsheet, or filling out blocks of data a cell at a time? Read on, as below are a number of shortcuts that'll save you time and energy in your daily chores! CTRL + Spacebar / SHIFT + Spacebar Tired of clicking... Read more