Understanding the difference between Excel’s stored value for a cell and its displayed value is important. It happens a lot and can make a big difference to the results. Back in the day we detailed a bug in Excel 2007 where the wrong number appears on the screen yet Excel ‘knows’ the right value for […]
If you often hit the CapsLock key by accident,sending part of your text into unwanted ALL-CAPS mode, you’re not alone. But rather than letting it stay a nuisance, you can repurpose it or disable it altogether. Stop accidentally turns CAPS ON when you don’t want it. On Windows or Mac you can remap CapsLock to […]
Excel is now 40 years old and it’s capable of some amazing things. Let’s not forget some of the mistakes made by users and serious bugs by Microsoft along the way. First a reminder of some Excel bugs and how Microsoft never seems to learn from their mistakes. Excel bug adding rows and columns Back […]
You can sort paragraphs, lists and tables in a Word document with all manner of tricks available under the simple ribbon button. Following our look at different alphabetical orders, here’s a look at the sorting options in Word. Select the list or paragraphs then choose Home | Paragraph | Sort. For tables there’s similar sort […]
Ever wondered what font is used in a famous logo? There’s a fascinating collection of familiar brands with their names replaced with the font name. Emanuele Abrate has made Logofonts, for example the Starbucks logo with the font name, FreightSans Black. Nike uses Futura. WhatsApp with HelveticaNeue. YouTube uses AlternativeGothic and Instagram has Billabong. Once […]
