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.
US State Department switches fonts, Times New Roman vs Calibri
In a move reversing a 2023 policy, the U.S. State Department has officially returned to using Times New Roman font for its communications, ending the brief tenure of Calibri. Why choose one font over another? Times New Roman vs Calibri – the pros and cons of each font. The US State Department is switching fonts […]
Left arrow ← in Word, Excel, PowerPoint and Outlook
Type the Left arrow ← into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The official Unicode name is ‘Leftward Arrow” ← but it can be called ‘Left pointing’ ‘Left facing’ or just ‘Left Arrow’ See also Right arrow → symbol in Word, Excel, PowerPoint and OutlookLeft Right arrow […]
Find & Copy Thanksgiving Emojis
Looking for the perfect holiday emoji for your document, slide or email? This quick-and-easy list from Office Watch offers a searchable collection of Thanksgiving-themed symbols that work across Windows, macOS, iPhone and Android. These emoji are supported (with different looks) on Windows, iPhone, iPad and Android devices. Unicode value (hex) The Unicode value column lets […]
Create Dynamic array Excel Drop-Downs in Minutes
If you’re working in Microsoft Excel and want a drop-down list from a dynamic array you have to use a workaround because the direct method for fixed arrays doesn’t work for dynamic arrays. Here’s the simple workaround to use a dynamic array function to generate a list of unique values from a data table, and […]
How to add a Picture with Text Wrapping in Microsoft Word – Simple Steps for Text Flow
Want to make your document look polished by having an image neatly enveloped by text? In this quick tutorial, you’ll learn how to insert a picture into Microsoft Word and apply proper text-wrapping so it can sit on the left, right, center or anywhere – and stay there. Let your text flow around a graphic […]
Master Hyphens, En-dashes & Em-dashes in Microsoft Word — Your Ultimate Guide
If you’ve ever paused over that little horizontal line in a document and wondered whether you should use a hyphen, en-dash or em-dash, you’re not alone. In Microsoft Word there are nine distinct dash or hyphen-like characters, each with its own typographic role and keyboard shortcut. From the standard hyphen for compound words to the […]
How to Quickly Generate Fake Data Lists for Excel – Two Proven Methods
If you’re working in Microsoft Excel and need to test formulas, dashboards or data‐driven workflows, real data can often get in the way. Fortunately, you don’t have to wait for live data sets or scrub proprietary information—this article shows you two powerful techniques to create fake data lists quickly and reliably. Whether you’re a data […]
Excel Text Comparison Warning: Why Your Formula Results Might Surprise You
Excel users, beware, comparing text in formulas doesn’t always behave as you’d expect. While most programming languages treat text strings with upper/lower case as different, Excel doesn’t. By default, it compares text without case sensitivity, leading to potential errors in formulas and automation. Learn how to correctly use functions like EXACT() and TRIM() to avoid […]
How to Use School-Bus Yellow in Word, PowerPoint & Microsoft Office”
If you’ve ever wondered how to replicate the distinctive “school bus yellow” shade in your documents or slides, you’ll find the answer here. It’s the standard hue for North American school buses, chosen for visibility and impact. You can apply this same shade in Microsoft Word, Microsoft PowerPoint or any other Microsoft Office document simply […]
How to Remove Emoji from Word docs or Outlook emails
Word documents and Outlook emails can be cluttered with unnecessary emoji. Copilot AI loves adding emoji, like it or not. If you’re tired of seeing smiley faces in your reports or emails, here’s practical ways to clean them out. Learn step-by-step methods to find and remove emoji using font searches or wildcard sweeps so your […]
What the “Possible Word Choice” Error in Microsoft Word Really Means
If you’ve ever seen Microsoft Word underline a word with a cryptic “Possible Word Choice” warning, you’re not alone. This subtle feature of Microsoft Editor can confuse even seasoned users. It flags real words that might not fit the sentence’s context, often catching homophones or subtle mix-ups that spell-check misses. Here’s how this grammar alert […]
Simplify Excel Formulas with the CHOOSE Function
Tired of endless nested IF statements in Excel? The CHOOSE function offers a cleaner, smarter way to pick from multiple options using a single, simple formula. Learn how to replace complex conditional logic with CHOOSE(), streamline your spreadsheets, and make your formulas easier to read, maintain, and debug. Choose() an alternative to IF or NestedIF […]
KWN – three letters that all Word users should know
Ever had a heading in Microsoft Word that seemed to wander off from its paragraph like a rebellious teenager? Or a bullet point that ghosted its follow-up text? Enter “Keep with Next” or KWN to its friends, Word’s low-key matchmaker that makes sure certain paragraphs stay together—forever (or at least until you change your formatting). […]
Excel’s “Hebrew Shekel” Label Sparks Unfounded Online Rage
A viral post recently accused Microsoft Excel of bias for labeling the shekel as “Hebrew” instead of “Israel.” However, there’s no conspiracy—Excel lists currencies by language, not country, using the same format for all entries. Thanks to Office Watcher, Gary B. from Portland for alerting us to this bit of ragebait on social media. It […]
Unlock Hidden Details: Add more to Word Headers and Footers
Most Word users stop at page numbers and dates in their headers and footers, but Microsoft Word can do much more. From inserting document titles, authors, and file paths to using advanced field codes like StyleRef or NumPages, you can make your headers dynamic, informative, and even interactive. Discover the powerful, lesser-known elements you can […]
Mastering Headers and Footers in Microsoft Word: Simple Steps for a Professional Look
Creating polished, consistent headers and footers in Microsoft Word is easier than you think. This guide walks you through every step—from adding page numbers and section-specific layouts to using “Different First Page” for cleaner title pages. Whether you’re preparing reports, articles, or academic papers, these techniques will help your documents look professional, organized, and reader-friendly […]
