Microsoft’s alternatives for the new Aptos fonts range are very poor. In some cases, the substitutions make no sense at all. We’ve looked at what happens if a document with Aptos fonts is opened Office 2016 and earlier versions of Word, Excel, PowerPoint and Outlook. Aptos fonts are the new
The trial release of Python in Excel is very interesting but it’s not the usual “Insiders” feature release with two important differences that will cost you later. “Insiders” is Microsoft’s name for their beta testing option to try upcoming features to the public Office apps. Excel gets Python – who,
There are some keyboard shortcuts to open or switch to Office apps in Windows 11 and Windows 10, if you have enough fingers! They are all based around the Ctrl + Alt + Shift + Win combo plus a letter. That might seem like a keyboard shortcut for an octopus
The Python Editor for Excel is a welcome innovation of the Microsoft Garage project making editing and debugging Python code in Excel a lot easier. Python Editor add-on for Excel mirrors the functionalities of renowned integrated development environments (IDEs) using the code management system behind Visual Studio Code. Sample code
Microsoft has fixed the big hassle that comes with the otherwise excellent Lambda() feature in Excel 365 with the new Advanced Formula Environment. Office Watch has sung praises over the power that Lambda brought to Excel. It’s the ability to write custom functions within Excel but without VBA macros. Proper
Unfortunately, copying an image made in Designer isn’t as simple as it should be. Here’s how to grab images made with Designer to use in your own Office documents. Don’t wait, start using Microsoft Designer now It’s easy to paste an image into Designer. Just copy the image from your
Python in Excel adds lots of new possibilities to Excel including a new way to the latest UTC time. Here’s the full code, how it works and a fix for an annoying problem. Knowing the UTC / GMT time is important for comparison with the ‘Last Trade Time’ data from
There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are important with the Stock and Currency data type in Excel 365 but also other situations. Normally Excel will update itself when you change a cell value. These days there are situations where cells
Insert the Water Pistol or Gun emoji 🔫 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. AND how to make the ‘gun’ point to the right. Water Pistol 🔫 symbol is the only ‘gun’ style symbol in the emoji collection. It’s officially
There are at least ten ways to ‘reverse’ ‘mirror’ or ‘flip’ text or images in a Word document. Horizontal, vertical, reversed, combined or any angle you like. When people say those terms they can mean different things so we’ll look at many options and how to do them. Also along
An undocumented surprise for Office 2021 and Office 2019 customers. The new Aptos fonts are automatically installed in Office 2021/Office 2019 even though Microsoft insists they are for Microsoft 365 only. However, there’s a crucial difference and strange anomaly between how Aptos fonts work in Office 2021/2019 vs Microsoft 365.
Type the fun Eyes 👀 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eyes 👀 symbol / emoji is a bit of fun for documents and PowerPoint slides. How Eyes 👀 looks in different fonts. Eyes is available in symbols fonts like
Microsoft 365 / Office 2021 Cloud Fonts are only available in Office programs … that’s the official line unless you know the trick to make the fonts available in other Windows or Mac apps Cloud Fonts can be selected and installed for Word 365/2021, Excel 365/2021, PowerPoint 365/2021, Outlook 365/2021
What are the legal limits on fonts supplied by Microsoft in Windows or Microsoft Office? Is there anything special for the Microsoft 365 only Aptos fonts? A few readers have asked us about the font license rules that apply to fonts provided by Microsoft. Can the fonts be embedded in
There are a lot more Office Icon or SVG graphics available than the ones in Microsoft 365, Office 2021 or 2019. Jazz up your documents, emails or presentations with a wider range of graphics than the (overused) ones that come with modern Word, Outlook or PowerPoint. Microsoft 365, Office 2021
Type or enter the ° Degree symbol into Microsoft Word, Excel, PowerPoint or Windows / Mac programs generally. Degree ° is a common symbol and should be available in most fonts. If not, try another font or one of the fonts with a very wide range of characters like Arial
Insert a World Map 🗺 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Of course, there are many Earth map images or drawings available on the Internet. There’s also some Microsoft Office Icons that we’ll explain below. We’re mostly talking about
Excel 365 has a detailed history of workbook changes down to the cell level so users can see what’s changed, when and who did it in Show Changes. Office-Watch.com explains how to use the new feature, some handy tricks plus the inevitable traps and limitations. This is great for collaborative
The new Aptos fonts in Microsoft 365 are installed and licensed in a different way from most fonts. How does that affect making a PDF either saving or printing. Can it be done at all? There are two broad ways to make a PDF file from an Office document. Save
Images can now be included in Excel PivotTables which not only makes for better looking PivotTables but more interesting Slicers too. A great contribution from Office Watch reader “AllanC” in New Zealand. With pictures in a PivotTable you can easily make cute slicers like this to show one record (person)
The new Aptos range of fonts is only available on Microsoft 365 apps. We investigate what happens when a document, sheet, slide or email with an Aptos font is opened on a computer without Microsoft 365 and the Aptos font range. In short: if Aptos fonts are not available, it’s
Microsoft is changing more than just the font in Microsoft 365, there are also default color scheme and even line changes coming too. Here’s all the proposed changes and how to reverse them. New Default Fonts We’ve already talked about the new default fonts, Aptos and Aptos Display. New default
Microsoft Excel has caught up with the needs of investors by adding automatic refresh of Stock prices and Currency data. Office Watch will explain what’s now possible and its limitations. Don’t get too excited, we’ve waited so long and when Microsoft does respond, the auto-refresh options don’t go far enough,
How to insert the Mount Fuji 🗻 or snow-capped mountain into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Mount Fuji (富士山 or Fujisan) is a Japanese Holy Site and World Heritage Listed. The symbol or emoji 🗻can be used for the famous mountain
