Windows 10X is coming and you’ll hear a lot about it in the coming months. Let’s see what Windows 10X is, how it will run Office (Word, Excel, PowerPoint, OneNote and Outlook) and why most people won’t need to worry about Windows 10X. What is Windows 10X? Windows 10X is
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser patches from last week. At first look, it seems there’s only five Office related patches including two each for Word and Excel. It’s important to keep both Office and the
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical laws that seems to defy common sense but works for most naturally occurring number sets. It says that in most groups of naturally occurring numbers, the leading digit 1 will
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better. As usual, we decided
There’s plenty of scope for variations on the basic Not Allowed symbol (red circle with diagonal) using the tools in Microsoft Office. See Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint for how to insert the basic ‘Not Allowed’ shape and change to suit your needs.
Pantone has announced not one but TWO ‘colors of the year’ for 2021 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. The colors of 2021 are … Illuminating and Ultimate Grey As usual what’s more amazing than the color is the description
Microsoft 365 for Mac is getting a revamped look for the Home or Start menu in early 2021. Here’s all the new and old features in the Home pane or as Microsoft calls it “Office Start experience” (no kidding) The Home panel changes to be more consistent with what’s visible
Microsoft Forms is now available for everyone, not just businesses. It’s available to collect information or opinions for any reason. One example is party planning, virtual party at the moment. Ask people for their preferred date, number of people, diet requests etc. All the info is collected and comes to
Google’s Gmail can now directly edit Microsoft Office documents arriving in email attachments. It’s available to all Gmail users, free and paid accounts. It removes a lot of the hassles of exchanging Office documents with Gmail and Google Docs/Sheets/Slides users. No more document conversion hassles … at long last! Email
The usual security fixes for Microsoft Office this month include some unexpected patches for Office 2010 which is a pleasant surprise. Office 2010 is now officially out of support (since 13 October 2020) but still works fine. That’s supposed to mean there’s no more patches. Microsoft hasn’t explained their reason
If you’re thinking about getting Microsoft 365 email hosting with full Teams and SharePoint, Microsoft has a limited time offer this week only. However, before you jump into their deal, there’s another very similar option that’s even cheaper. Until 30 November 2020, Microsoft is offering 25% discount on their Business
Microsoft can’t help themselves when it comes to naming their ‘Insiders’, ‘Preview’ or beta test versions. The names change for no good reason and timing is different for each platform rather than all Office apps changing at the same time. The latest changes are for MacOS, iOS (iPhone/iPad) and Android
Some people have way too much time on their hands …. and this was pre-lockdown! Hunter Hobbs decided to find out how long it takes to scroll down to the very bottom row of Excel. That’s row 1,048,576. It only takes a moment and two keystrokes to get there, but
0Patch is stepping in where Microsoft has left by offering continued security updates for Office 2010 after official support was dropped a few months ago. Newly discovered high risk security bugs in Office 2010 will get micropatches from 0Patch. These unofficial updates change the existing program files to prevent the
The Quick Access Toolbar (QAT) is located on the left side of the Word, Excel, PowerPoint or Outlook title bar. You can add commands, options and even symbols for easy and quick obvious access By default, the QAT only has Save, Undo, Redo and Touch/Mouse commands but you can cut down
One of the eternal questions to Office Watch is about adding characters to an Office document. Symbols and characters not on the keyboard. The most common requests are for adding currency symbols like Pound £ Euro € or Yen/Renminbi ¥ but can also include the @ symbol which can, even
Excel’s Conditional Formatting is getting two small but much needed changes that will make it a lot easier to use. According to Microsoft, the latest Insiders releases of Excel 365 for Windows has two changes to the Conditional Formatting Manager dialog. Resizable The dialog is now resizable from the handle
Illustrations are a new graphics option coming to Microsoft 365 that supplements the existing Icons with a wider range of visual aids for documents, emails, worksheets and slides. They’ve appeared, without any mention, in preview versions of Microsoft 365 for Windows (version 13415.20002) and Microsoft 365 for Mac (v16.43 20102102)
Put the Sound Recording Copyright ℗ or Circled P character into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Sound Recording Copyright ℗ symbol (aka Circled P ) is used to mark musical copyright. The ‘P’ stands for ‘Phonogram’ or the modern ‘Phonorecord’
Adding a continent map is easy in Word, Excel or Powerpoint, in fact there’s a few ways to get them for the Americas, Europe, Africa, Asia, Australia and Antarctica. It depends on the quality you need and version of Office. Continental Icons Among the many icons are silhouettes of all
Microsoft is expanding their support for SVG graphics by allowing these ‘Icons’ to be copied from Office documents into other third-party apps. Users can take an Office Icon or SVG and easily copy it to another app to use or change beyond Office’s in-built features. There’s no special menu item
Writing into cells is now possible in Excel for Windows using the Action Pen in a new way. Sadly, as we’ll see, the implementation is a bit clumsy and lacks documentation. Action Pen was introduced earlier this year as a way to edit documents with digital ink gestures. Action Pen
Microsoft is trying a new way to push Office or Microsoft 365 to new customers by dropping links into the Windows Start Menu. We’ve seen this on the Start Menu of Windows 10 preview releases. It’s a group of icons for Word, Excel, PowerPoint, Outlook, OneNote and Skype. Most of
There are 87 different security breaches fixed in this months rollout of Microsoft bug fixes, including an important one for Windows. Also a Critical fix for Outlook and patches for Word, Excel. We’ll start with a very critical Windows bug that’s important to patch right away. Vital Windows 10 bug
