We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.
Charles Kingsley
Monthly Archives: October 2022
Pasting Trick in Excel
When you copy from another system and paste into Excel the result may not be what you expect. One way around that is to paste in to Excel and match the format of the destination cell. Here’s how you do that.
Amazon again
My book was published in 2014 and I bought the Kindle version from Amazon.
That doesn’t stop them trying to sell me the paperback version of my own book.
Algorithms never give up hope.
Circular Reference in Excel but the Circular Reference Button is Greyed Out
Sometimes Excel is not very helpful when it tells you that there is a circular reference in your file. If that is the case here is a technique to help you find where the circular reference is.
Excel VBA to Sort Sheets by Name
In an earlier post I shared some VBA code to sort sheets by their colour. In this post I have tweaked the code to sort the sheets by their name.
Not So Random Entries in Excel
Sometimes when you are testing or training in Excel you need to create random entries. That is easy to do with the RANDBETWEEN or RANDARRAY functions. What if you wanted to emphasise some entries more than others in the random list created? There is a way.