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.
Start Grouping in Excel for better looking sheets
Grouping in Excel lets you collapse or expand sections of a sheet so you can see the ‘big picture’ but still drill-down to how totals were made. Another use for grouping is hiding rows or columns from view. You can organize and manage data more effectively by grouping together rows or columns. This feature is […]
Discover the Edit Points bug in Word
An interesting bug in Microsoft Word, thanks to an Office Watch reader. Changing the edit points around a rectangular image can hide some text that should be visible. It appears to be a bug in the code to wrap text around an object in some narrow circumstances. Here’s how to recreate the bug, start with […]
Spreadsheets are a warning about the future of AI
A respected author has a warning about the future of AI using the mixed history of spreadsheet mistakes as an example. Tim Harford is an excellent columnist and author known as “the Undercover Economist”. Check out his “More or Less” podcast for the BBC. In a recent article he argues that the spreadsheet is a […]
Five fast Clear options in Excel
Excel has some nice choices for clearing out cells quickly. You can remove the contents, the formatting only or both contents and formatting plus choices for deleting just notes, comments and cleaning up links. As you can see the drop-down menu Home | Editing | Clear offers options such as: Clear All, Clear Formats, Clear […]
PowerPoint – switch away from Aptos fonts
Here’s how to switch away from the new Aptos fonts in Microsoft PowerPoint and back to the old Calibri fonts or something else. Microsoft has forced a change to Aptos as the new default font in PowerPoint but that change doesn’t suit everyone. In particular, Aptos doesn’t make much (or any) visible difference for bold text. Both the paragraphs […]
Remove that big AutoSave from the Office toolbar
Get rid of the over large ‘AutoSave’ slider on the Word, Excel or PowerPoint status bar. The Autosave button (strictly a label plus slider) takes up a lot of room on the top row of modern Office apps. That space is quite crowded and you need it to fit as many ‘Quick Access Toolbar’ (QAT). […]
Print selection, sheets or tables in Excel
Excel has some useful options for printing less than an entire workbook. Printing a selection, active sheets or just a table. As Office-Watch.com has discovered before, there’s a lot more available in Office than a quick look suggests. See Print options are at File | Print then choose the menu that starts with Print Active […]
Eight WhatsApp formatting shortcuts including four new ones
There are shortcuts that automatically format bold and italic text in Word. The same shortcuts and more work in WhatsApp texting as well. There are now four more formatting options; bullet lists, numbered lists, quotes and inline code. AutoFormatting Bold and Italics as you type In Microsoft Word and Outlook it’s possible to make words […]
Use the world’s ugliest color in Word, Excel and PowerPoint
Make an unpleasant point with the world’s ugliest color. A ‘drab dark green’ can be used in any Word document, Excel sheet or PowerPoint slide. And we’ll explain the recommended complement color and font. It’s not our opinion, but the market researched result of an effort to find the most unappealing color. A three-month study […]
What Microsoft Word does with “Drunkonyms”
The British have 546 ‘drunkonyms’ or words for drunkenness according to a new academic study. We could not resist seeing how the Microsoft Word handles them (after we’ve had a quick drink to get us going 😀) We compiled a list of 55 drunkonyms and ran them past the Word 365 spell checker using UK, […]
How to check if your emails are sent with DKIM
Here’s a way to ensure your outgoing emails include DKIM and SPF details all setup correctly. DKIM email verification is becoming more important for deliverability of emails. This is mostly for anyone using Microsoft 365 email hosting, especially individual or small business users who have change their email verification setup. Once you’ve enabled DKIM for […]
What do fonts say to each other?
Ever wondered what fonts say to each other. How newcomer Aptos treats Calibri? How Dingbats dance and what Comic Sans wears? Elle Cordova answers these and other important typographical questions in two Instagram videos. Fonts Hanging Out part 1 https://www.instagram.com/p/C2cZBIAr24m/ Fonts Hanging Out part 2 https://www.instagram.com/reel/C2sxcszyLnN/ Enjoy … Excel – switch away from Aptos fontsMicrosoft […]
Critical new flaw in Microsoft Outlook allows (too) easy access
All Outlook for Windows have a critical bug which makes it too easy for any hacker to gain access to a computer. It just needs a simple link clicked from an email to bypass Office Protected View protections, even from the Preview pane. So all Outlook’s should be updated asap. Microsoft rates the security bug […]
Last minute Heart icons for Valentine’s Day
Need a heart symbol or image for your Valentine’s Day message, email, slide or card? Microsoft Office Icons have many choices available including Icons. Many of the stock or supplied resources in Office have passionate ‘heart’ symbols. As you’ll see, there are some anatomically correct icons among the romantic ones, just ignore them <g>. Icons […]
Using AI tools for a personal touch to Valentine’s Day
The latest AI tools can help add a personal touch to Valentine’s Day images, graphics and text like a love poem. Add some details about your loved one (name, hobbies etc.) and AI can do its magic. Free AI tools like Copilot, Microsoft Designer, Dall-E or ChatGPT can make something that’s individual and unique. In […]
Two ways to change Excel default fonts
There are two options for changing the default fonts in Excel, either for new blank workbooks or existing spreadsheets. Maybe you prefer another font. Perhaps the old default font until mid-2023, Calibri. Or a spreadsheet specialist font like Goldman Sans. Maybe your organization or client has a preferred font? Go ahead and change the font […]
