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.
Make a great Word document banner – free
Add something special to the start of your Word document with a banner image with text. We’ll explain how to do that with free tools like Copilot or Designer. We were inspired by a Microsoft promotion which wrongly said that a Microsoft 365 subscription with Copilot Pro is required, when really neither of those things […]
All about the basics of Styles in Word
Here’s the basics of Styles in Word for paragraph, character or both (Linked) plus Tables and Lists. I know talking about styles in Word makes eyes glaze over but they are a really useful part of Word (plus Excel, PowerPoint and Outlook). Today I watched an ‘experienced’ Word user reformatting a document. He laboriously worked […]
Excel – why do the columns have numbers not letters?
What to do if Excel’s columns have numbers across the top instead of letters. There’s a simple setting to switch between two different ways of labelling cells. You open an Excel workbook and the column headings look all wrong – instead of letters (A, B C …) there are numbers. There are numbers for both […]
Building In-Cell Bar Charts in Excel
In-cell charts in Excel provide a powerful method to visualize data trends and patterns. They allow you to quickly derive insights within a worksheet, making information interpretation more straightforward without fussing about with full charts. We’ll explain how to make in-cell charts and then go further and show how to make them look better by […]
Lock up and stop editing of Excel worksheet or cells!
How to lock your Excel worksheet from editing – the whole thing or some cells. Allow some people to edit a few cells, leaving the rest of the cells and formulas untouchable by others using the worksheet. Here’s a very simple example: Anyone opening the worksheet can enter a US dollar amount to see the […]
How to adjust Bullet or Numbered list spacing in Microsoft Word for Perfect Formatting
Discover how to adjust bullet point spacing in Microsoft Word with the two key settings to achieve precise bullet point alignment and formatting. Learning the techniques to perfect your bullet points can make a significant difference in readability and presentation. There are TWO places to change the position of the bullet in relation to the […]
Busting the myth of Word’s Language Defaults
An often-repeated myth says that Word’s spelling or proofing language default is locked into the Windows language setting. Officially that’s not true and never has been since the first Word for Windows in 1989. In practice there’s a bug in Word which is why this persistent myth keeps being repeated. Changing the Word language default […]
Easy fix for unwanted message grouping in Outlook
How to stop Outlook grouping Inbox messages, most commonly by date. “Today”, “Yesterday” etc. which might suit some people but is a right nuisance to others. This is an option in Outlook (classic) for Windows which can appear, seemingly for no good reason. It’s not in Outlook (new). Some people might like it, but most […]
Effortlessly Migrate Your Notes from Evernote to OneNote
Many people are moving away from Evernote due to the high prices. Here’s the simple way to migrate all Evernote notebooks to Microsoft OneNote. Why move from Evernote? Evernote’s pricing has risen to unrealistic levels. The cheapest paid plan “Personal” is now US$129.99 which is more expensive than Microsoft 365 Family plan for six people. […]
The ultimate way to change Microsoft Word defaults.
Having trouble changing Microsoft Word defaults? The ultimate way to change defaults is sure to work. It’s has been around since the very early days of Word and works for Outlook too! We often hear from people having trouble changing Word’s opening (default) settings for a new document. Various places in Word have ‘Set as […]
Three ways to switch language in Word and one way to turn it off
Word can spell and grammar check in many languages, here are three ways to switch the language settings plus how to turn off the pesky automatic language switching. Microsoft Word has language settings that can apply to a whole document or just selected text. This is vital for multi-language documents but also has an important […]
Grouping values from an Excel list
There’s a simple but not so obvious way for Excel to take a list of values and show them grouped into segments or groups. As an example, here’s the results of a class exam with their scores grouped into blocks of 20. It’s done with a tricky use of PivotTables and one of the somewhat […]
Koalas galore in Microsoft Office
We went hunting for koalas in Microsoft Office. Found more than 18 of the cuddly marsupials for Word, PowerPoint or Outlook. There are emoji, Office icons, SVG, online images and more making a colony or cling of koala (either can be the collective noun for koala). None of the endangered species where harmed in the […]
Beware variable fonts with Office and PDFs
A PDF file made from Microsoft Office or Windows may not look right because of an ongoing PDF bug with variable fonts. It’s been around for years with no sign of a fix. The problem arises when variable fonts are in documents exported to PDFs (either Save As … or Print to PDF). The font […]
Outlook security hole needs quick patching
The latest Outlook security hole is quite easy to exploit so it’s a good idea to quickly update Microsoft 365/Office for Windows. The security bug is easy to exploit. Infection occurs simply by downloading a small file from any web site or source and running it. Hackers know plenty of ways of tricking people into […]
Change Word Zoom to custom fixed settings
This is how to change Word’s Zoom to your preferred Zoom settings instead of the defaults. Ray R writes … “I have been having some vision problems lately and have found that using Word’s zoom dialog to increase the displayed font size without changing it in the document or email (I use Word as my […]