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.
America has two feet … does Excel?
Did you know that the U.S has two feet? Meaning two different measurements for the term ‘foot’? That got us wondering how Excel’s Convert() handled the standard ‘foot’ and the US Survey ‘foot’. Excel Convert() supports the International Standard Foot and, indirectly, the US Survey Foot. America Has Two Feet. It’s About to Lose One […]
Booklet printing with or without Microsoft Word
Microsoft Word has a booklet printing option but there’s a simple alternative if it’s not working or you’d like options not available in Word. Here’s how to booklet print in Word and also a simpler alternative. Word’s Booklet Printing is done in the document (Layout | Paragraph | Page Setup | Multiple Pages | Book […]
Add a fast keyboard shortcut for any Word style
Add a keyboard shortcut for any Microsoft Word style including Headings and Normal style. A shortcut is faster than clicking on the ribbon anytime you want to apply a style. For commonly used styles it’s easier and faster to use a keyboard shortcut. Microsoft even supplies a few with Word, but not enough. The in-built […]
Easily apply the same picture format to many images in Word or PowerPoint
Here’s how to apply the same formatting, borders and picture styles to more than one picture or graphic in Word, PowerPoint or Excel. There’s an unexpected and easy way to do it. Picture Format tools don’t have custom styles (Microsoft please note) only the in-built pre-sets. If you want to apply the same formatting to […]
Reference Mark ※ in Word, Excel, PowerPoint and Outlook
Put the Reference Mark ※ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Reference Mark ※ or reference symbol is used in Asian writing (Chinese, Japanese, Korean) like the Asterix * in western languages. It marks some additional notes to text. It’s called komejirushi (Japan) , chamgopyo (Korea) or […]
Why you must use the Microsoft Office Document Inspector
Why you must use the Microsoft Office Document Inspector … and why you can’t completely trust it. The Office Document Inspector is an important tool for anyone who shares or sends out Office documents. It helps prevent legal troubles and personal embarrassment. Inspect Document is only in Office for Windows (not Mac). Microsoft Office 365, […]
How to use Text Wrapping Breaks in Microsoft Word
When including images or other objects in a Microsoft Word document, it can sometimes be a bit fiddly getting the text to flow around them in the way you want. The text wrapping break lets you specify the point where the text should drop down below the picture. When you have text wrapping around a […]
Two new PowerToys useful for Office users
Two new Windows PowerToys are especially useful for many Microsoft Office users. One is a better way to type accented characters, the other grabs text from images. Quick Accent, Text Extractor and, to a lesser extent, Screen Ruler are all additions to the PowerToys collection that can be useful for Office users. PowerToys are available […]
Faster updates for Microsoft Office with Update under Lock
Microsoft has improved the updating of Office 365 for Windows to make it more seamless and hidden from view. ‘Update under lock’ means Office will be kept up-to-date in ways not previously possible. Until now, Microsoft Office was updated to the latest version when all the Office apps were shut down, for example when the […]
Discover more in Microsoft Word’s Page Border feature
The in-built page border option in Microsoft Word has a lot more available than first appears. A little digging will discover a lot more possibilities for interesting edges to pages. We’ve already explained how to make a more flexible page border in Word that you can change to exactly fit your needs. In this article […]
Questioned Equal To ≟ in Word, Excel, PowerPoint and Outlook
What is the Questioned Equal To ≟ symbol and how to type in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. ≟ is a question mark above an equals sign. It isn’t properly used in equations but can be useful to show an equation to be solved or […]
Three Microsoft Office function key alternatives
Function keys can be a hassle, specially on smaller laptop keyboards without a dedicated F key row. Happily there are two alternatives for Microsoft Office user plus another for both Windows or Mac generally. Many laptop users avoid the Function keys because they aren’t directly available on the keyboard. Instead you need to press the Fn […]
Show a Word style marked ‘Hide until used’.
Many inbuilt Word styles are hidden until they are used but there’s a way to force hidden styles to appear right away. The most obvious example of ‘Hide until used’ styles are the Heading styles. Word initially shows only the first three headings ‘Heading 1’, ‘Heading 2’ and (drumroll) ‘Heading 3’. Hidden away are Heading […]
Hiding Cell Contents or Formulas in Excel
There are two ways to hide Excel cell contents that you don’t want visible, but still available able to use in calculations. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are separate options for hiding row, columns or entire worksheets (aka […]
Two ways to Find & Remove Hidden Text in Word
If you want to find then change or remove hidden text from your Word document, there are two ways to do it. Either reveal or find the hidden text OR use Word’s in-built Document Inspector. For a shorter document, you can use the Show/Hide button to see what’s hidden and delete it manually, but that […]
LET() assigns names to calculations in Excel
Let() is a new function in Windows and Mac versions of Excel 365 and Excel 2021 (plus Excel Online) which is popular with makers of long, complicated functions. The function lets you name a temporary variable to use within a formula. That might seem a strange thing to do but it’s a godsend for advanced […]
