Office 2021 is the personal and small business ‘perpetual licence’, non-subscription version of Microsoft Office. For Windows and Mac.
Office LTSC (Long Term Servicing Channel) is the volume licence ‘perpetual licence’, non-subscription version of Microsoft Office for organizations, companies and governments. Also for Windows and Mac.
The features in Office 2021 and Office LTSC are very similar, if not the same.
Debug to understand and fix Excel formulas
Excel Labs has just added a nice formula Debug option that helps you understand the steps inside a formula and fix errors. There are already three ways to look inside a formula; Evaluate Formula, F9 to calculate part of a formula and the recent Visual Preview. Now Microsoft’s Excel Labs Advanced Formula Environment has a […]
How to add notes inside Excel formulas
Here are three ways to add an explanation or note within an Excel formula itself, instead of separate notes. The ‘Achilles Heel’ of Excel or any spreadsheet program has always been explaining or commenting of cell formulas. Adding comments is an important part of any code including Excel’s VBA but it’s MIA from formulas themselves. […]
A better way to view formulas in Excel
Here’s a far better way to view and edit formulas in Excel than the small formula bar. It’s a free add-in from Microsoft’s Excel Labs called Advanced Formula Environment (AFE) Understanding Excel formulas can be difficult, even ones you’ve written yourself. Imagine trying to work with a monster formula like this: Happily, there’s an easier […]
Pantone’s 2024 color ‘Peach Fuzz’ in Word, Excel and PowerPoint
Pantone’s color of the year for 2024 is “Peach Fuzz”. You can use that exact color in Word, Excel, PowerPoint, Outlook and Designer using the Hex/RGB color code. And we’ll look at the flowery prose that’s become a hallmark of this annual promotion. The color of 2024 is … Peach Fuzz As usual what’s more […]
Ten ways to select text fast in Microsoft Word
In Microsoft Word, you can use keyboard or mouse shortcuts to select characters, words, lines, paragraphs, and blocks of text faster. Here are ten different selection tricks that Word experts know to speed up their work. Select a Sentence Highlight an entire sentence in Word by simply holding down the Ctrl key, or the Command […]
Get over 3,000 more great Office icons from Google
Google has more than 3,000 Icons available to add into Microsoft Office documents from either SVG files or a font. Material Symbols are a collection of small icons, much like the Icons available in modern Office. As SVG files they can be recolored and changed from their standard black line look. Use them in Word […]
Croissant 🥐 emoji in Word, Excel, PowerPoint and Outlook
Add the Croissant 🥐 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. I have to declare a personal interest in this article because the Croissant 🥐 is an essential part of my breakfast. No morning is complete without the “Three C’s” – Coffee, Computer and Croissant […]
Sketchy line option in Office for Windows and Mac
Office for Windows and Mac has three special outline styles for the borders of shapes and text boxes. Called ‘Sketched’ or ‘Sketchy‘ because they have a hand-drawn line look. It’s a nice little addition to Word, Excel, Powerpoint and Outlook. Let’s see how it works plus some details and limitations that Microsoft hasn’t mentioned. All […]
Sketchy or wriggly lines in Icons and SVG graphics
Microsoft Office Icons and other SVG graphics can be improved a lot simply with Sketchy or Sketched lines. They turn an icon or graphic from something formal into a hand-drawn and casual look. Sketchy lines is the ‘hand-drawn’ line option available in Microsoft 365 for Windows or Mac plus Office 2021. It lets you change […]
Better Icon, illustration or SVG editing trick in Office
Get more from Microsoft Office Icons, Illustrations, Cartoon People and other SVG graphics by turning them into Office Shapes which opens up many more options for editing and recoloring the graphic. That includes ‘splitting’ a single graphic into parts that can be changed separately. Microsoft 365, Office 2021, 2019 and 2016 for Windows/Mac have an […]
Quickly make your Word document look better
Word has some quick ways to turn a plain document into something fantastic. All it takes is a few clicks on the Design tab to change the overall look, fonts and colors. And we’ve added tips to fix formatting that doesn’t change. Let’s start with a very plain version of a famous and definitely not […]
How hackers trick you to open infected documents
Here’s how to avoid the tricks hackers use to infect your computer via Office documents. Microsoft has added features to Office that should make it harder to infect your computer via a Word, Excel or PowerPoint document. Hackers have found ways to trick people into bypassing those warnings and enable the viruses in the document. […]
How to recover lost roaming signatures in Outlook
If your Outlook roaming signatures have disappeared, there’s a few things to check first then recover them. Modern Outlook for Windows has roaming signatures but sometimes they don’t behave. See Roaming email signatures in Outlook 365, 2021, 2019 for how they are supposed to work and Outlook signatures and roaming troubles Failing that, all you […]
Outlook signatures and roaming troubles
Signatures in Outlook have changed for Outlook 365, Outlook 2021 and Outlook 2019 but they have troubles, at least for Microsoft managed mailboxes (Microsoft 365 and Outlook.com). In January 2020, Microsoft promised to make email Signatures ‘roam’ meaning they would synchronise and appear on each version of Outlook using the same mailbox. That was originally […]
Telephone location ✆ emoji in Word, Excel, PowerPoint and Outlook
Insert the Telephone location ✆ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Telephone location ✆ symbol is supposed to be used as a sign for a phone box or booth but can be used for any ‘phone’ purpose. See also: Telephone Receiver 📞 Emoji In Word, Excel, […]
Making a Word linked style for lead in paragraphs
Here’s how to make a linked style with an outline level in Microsoft Word. Use this for many reasons like Table of Contents styles in Word. The ‘outline level‘ is how Word knows what to put in the Table of Contents, Outline View and, mostly, Navigation Pane. Any Paragraph, Linked or Table style can have an […]
