Changing the font, size or style for all Word documents is remarkably easy and there’s two ways to do it. Alter the font that’s automatically used when you make a ‘blank document’. In Word 2007 and later the default font face is Calibri, font size 11 and style Normal. This might not be the ideal […]
Finding out the current UTC / GMT time in Excel is possible with a little VBA magic. We’ve included a full working example. Excel has two functions to give you the current date TODAY() or current date and time NOW() but it’s the local time as set on your computer. Often the worksheet needs either […]
Finding out the computers local time zone offset in Excel is possible with a little VBA magic. We’ve included a full working example of how to get the ‘nn hours from GMT’ setting from Windows into Excel. The need for the current UTC/GMT time and offset is becoming more important as Excel improves its external […]
Insert a Compass 🧠symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Compass 🧠uses Segoe UI Emoji In Windows, the Compass 🧠symbol is in the font: Segoe UI Emoji. Depending on the app and use, it’ll appear in color or black. The symbol can […]
There’s a way to quickly change the language setting for a multi-lingual Microsoft Word document, by adding a language selector to the Quick Access Toolbar (QAT) like this. Use this as a pull-down list to change the language setting in parts of a document. The problem is the fixed width of the toolbar item, which […]
