Here’s all about Office 2019 for Windows – the facts, prices and shortcomings. There’s a matching page about Office 2019 for Mac. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In
All about Office 2019 for Mac the facts, prices and warnings. There’s a matching page about Office 2019 for Windows. Before you get too excited Do NOT buy Office 2019 if you have Microsoft 365 plan like Microsoft 365 Family (formerly Home), Microsoft 365 Personal or an enterprise plan. In
Excel 365 for Windows is getting another option for importing data into PowerQuery, from a dynamic array. In many cases the original data source could be imported, sorted and filtered in many different ways. Importing a existing dynamic array is a useful extra trick for us Excel nerds. We can
Learn how to create live, dynamic sorted lists in Excel using the powerful combination of Sort()/SortBy() and Filter() functions. In Excel 365 and Office 2021+ dynamic array formulas like FILTER() let you extract a subset of data — and by wrapping that result inside SORT(), you can instantly sort the
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
Suggested Replies are coming to Outlook 365 for Windows. As usual, there are details that Microsoft has ‘forgotten’ to mention but we at Office Watch aren’t so forgetful! In the Outlook reading / preview pane, possible replies can be displayed. Or Microsoft’s cloud systems have scanned the message and offered
The new spelling, grammar and other suggestion Editor can now be used with selected text, not just the whole Word 365 document. It’s a little change but an important and useful one. Select a block of text, right-click and choose ‘Review selection in Editor’. Selecting text for the Editor is
Sometimes Microsoft announces new features for the Insiders early testers that aren’t even available yet. It seems Redmond’s promotional hype gets ahead of the software reality. The new Accessibility ribbon is just the latest example. According to a blog post from 29 March, there is a new Accessibility ribbon in
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
Confused about Unicode, code-points and other techie details about inserting symbols? Here’s how it works and can work for you in Word, Excel, PowerPoint and other apps. Like many things in modern computing, you mostly don’t have to know the details of how things work. But occasionally things don’t work
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
Here’s an interesting switch, a UK company is suing Microsoft over their licencing rules for Office. Usually it’s Microsoft suing others about licences, not the other way around. ValueLicensing is claiming UK₤270 million (US$370m ) in damages from Microsoft for trying to squeeze out the second-hand licence market. Organizations that
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
Microsoft has finally released a fix for what can only be described as an ‘unforced error’ or bug in Outlook that stopped some messages going out. They’ve left an unanswered mystery. The problem started after an early 2021 public update to Outlook 365 for Windows. Some messages refused to be
PowerPoint for Windows is getting a ‘Present in Teams’ button to drop your presentation into a Teams call or meeting. PowerPoint Live in Teams sounds great, but there are very specific requirements to make it work. Fire up the Teams desktop app and make sure it’s up to date. Open
Windows has some nice features for quickly showing your appointments, calendar and contacts/people lists so why don’t they show that information that’s in Outlook for Windows on the same computer? In Windows 10, clicking on the date/time in the bottom right-corner (the taskbar) you’ll see the monthly calendar and either
Microsoft 365 hosting plans are great and do most things a small business or organization needs except one thing … a public web site. Here’s how to setup a simple web site within Microsoft 365 hosted systems. For an organization or small business, Microsoft 365 hosting has most tech needs
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s alphabet. Here’s what Word does in English, French, German, Danish, Polish and many other languages. It’s useful filler text for testing formatting or other Word features just like “Lorem Ipsum
