Your first look at Office 2021 for Mac with Word, Excel, PowerPoint and Outlook, which is now out in public preview, showing off some of the new features. There’s only a Mac Office 2021 preview, no Office 2021 for Windows preview. Perhaps because there’s a few more innovations in a
A public preview of the next perpetual licence Microsoft Office is now available. Called Office LTSC (Long Term Servicing Channel) it’s for volume customers only. Here are the options and how to get the preview. Office LTSC is the clumsily named non-subscription version of Office for organizations with volume licence
Here’s a first peek at Office LTSC for Word, Excel, PowerPoint, Outlook, Access, Publisher and OneNote which is now out in public preview showing off some of the new features. Office LTSC in it’s current preview is underwhelming, to put it mildly. But that’s what Microsoft is aiming for. Office LTSC
Filter is another Excel 365 dynamic array formula that’s really useful and far better than similar options in earlier versions of Excel. Just like SORT() and SORTBY(), FILTER() refreshes automatically whenever the source values change. The older pull-down filter and sort choices don’t update properly. Dynamic Arrays also give you
Details and warnings about the April 2021 security and non-security updates for Office 365, Office 2019 and Office 2016 for Windows. There are some side-effects to watch out for. All these update will, or have been, pushed to your computer already. We’ve included a tip on how to force an
Here’s all the security and general bug fixes for April, aimed at Office 2016, Office 2013 and Office 2010 for Windows. Most customers will have their Office updated automatically unless you’re one of the cautious who wait a little while to see if there’s any bugs in the bug fixes.
Microsoft has been changing the way comments work in Office 365 and now it’s the turn of Excel 365 to get the new-style conversational comments. If you’ve opened up Excel 365 recently you might have seen a notice like this: “ Comments can now be used for discussions. When you
In late 2018, Excel 365 got an important new feature, Dynamic Arrays . Here’s a simple way to use the feature to make your workbooks sort better and automatically. It also fixes a long-standing problem in Excel. We’re going to focus on a very simple and useful part of dynamic
How to insert the Double Vertical Bar ‖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Vertical Bar ‖ symbol is used to represent norms in mathematics, (for example ). It can also be used to signify parallel lines. It can
Type the Cross of Lorraine ☨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cross of Lorraine ☨ symbol was originally a heraldic cross. In more recent times it was used in the global distribution systems, Sabre, Apollo, and Wordspan, as a delimiter
The BBC has a ‘long read’ about hidden information inside almost all photos. Office Watch has talked about this problem many times before including how the extra image data hides in Microsoft Office documents, despite the ‘Document Inspector’. It’s too easy just to think of an image as just what
You’ve received a document, but when you try to open it, the file stubbornly won’t appear! We explain how to fix it. Our editor-in-chief saw that problem in an Internet cafe‚ in Ketchikan, Alaska and was surprised when neither the manager of the store nor the cruise computer ‘expert’ knew the
How to insert the Black Right Pointing index ☛ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Right Pointing index ☛ symbol can be used for pointing a direction on a sign or as a different bullet symbol. There’s also a
The Word, Excel and PowerPoint apps for iPad are getting right-click menus when there’s a external mouse or trackpad connected. It’s a good move with more iPads being used with separate keyboard & mouse as a mini-PC. Sadly the new menus aren’t all they could be. Right-click (Microsoft calls a
Type the Broken Vertical Bar ¦ in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Broken Vertical Bar ¦ symbol was sometimes used in computing. These days there’s no specific use for the broken vertical bar but it’s good to keep in mind
The March 2021 Windows patches have caused at least two major bugs (sorry ‘issues’) that can affect Office users or anyone trying to print. Here’s the fixes and workarounds. Printing bug This is a nasty bug caused by the Windows patch KB5000802 not being properly tested before release. An update
Excel in a web browser has some new improvements, many of them are familiar Excel desktop features moved online but one is unique to the browser-based version. Version history for collaboration, more zoom options for keyboard and screen, multiple range selections and changing regional settings are all now available online.
Microsoft has added more protections against nasty Excel 4.0 macros aka XLM macros. XLM or Excel 4.0 macros are an older pre-VBA system that’s still available in modern Excel 365 for Windows and Mac. XML macros have been around since 1992 but gradually replaced by VBA which debuted only a
There are types of Office documents that you should NOT open, even if they come from someone you trust. Here’s the full list of file extensions for the older Office document formats which are much more likely to be ‘malicious’ docs from hackers and criminals. We’ve talked about the risks
Type the Not Equal ≠ sign into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Not Equal ≠ symbol is used in equations, obviously but it’s also handy shorthand in a heading or slide. The official Unicode name is ‘Not Equal To’. How Not Equal ≠ looks in different fonts. Here’s some
Microsoft has announced two ‘perpetual licence’ or non-subscription versions of Office that will be released later in 2021. Both continue Microsoft’s unstated but bleedingly obvious attempts to push customers to annual ‘subscription’ payments. Here’s what Microsoft has disclosed so far with an explanation of the continued reduction of value for
The Office ‘all in one’ app, already available for iPhone and Android, is starting its arrival on Apple iPad. The app combines Word, Excel, PowerPoint and other goodies into a single app. The ‘all in one’ app, officially called just ‘Microsoft Office’ has started a limited preview. We’ll explain how
How to insert the Currency ¤ or scarab symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Currency ¤ symbol is used to denote an unspecified currency. It’s the generic sign you could use if the correct symbol isn’t available. It doesn’t
An Excel Table Form is a simple no-code way to view a single table row in an editable box. If a row of data is too wide, instead of scrolling left/right to find what you need, use a data form to add, edit, find, and delete rows. Table Form is
