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.
Percentages that look right in a Word Mail Merge
How can you put percentages into a Word mail merge? There are several methods including the one we like because it’s reliable and simple. Following our article on importing Excel data into a Word mail merge, here are the options for using percentages. Excel might show a percentage but the number stored is a fraction. […]
SUMIFS Excel SUM with filters galore
Consider switching to SumIFS, it’s much the same as the older Excel function, SumIf() but easier to expand as your needs change. It can add up values according to more than criteria like a name and date range. We’ve talked about SUMIF and how its parameter order is a little strange. SumIF has filter/criteria first […]
Hide any footnotes and endnotes in a Word doc
Hiding Footnotes or Endnotes in a Microsoft Word document is possible but needs a little trickery. Maybe you want a ‘clean’ version of the document without the clutter of notes. Or maybe the footnotes/endnotes are your own references for sources of information not intended for others to see. Ideally there should be options to print […]
Biohazard symbol for Word, PowerPoint and more
There are official and unofficial biohazard symbols available for Word docs, PowerPoint slides or any other place you need them. We have download links to better graphics you can use with variations to make them stand out The official biohazard symbol was developed in 1966 and there are many variations available. The widely used symbol […]
Type Infinity ∞ symbols in Word, Excel, PowerPoint and Outlook
Type Infinity ∞ and similar symbols into Microsoft Word, Excel, PowerPoint or Outlook. In Office for Windows and Office for Mac you can enter Infinity, Incomplete Infinity, Tie over Infinity and Infinity negated. Infinity ∞ symbol is used for anything that has no end or boundless. Of course, it’s in mathematics where Infinity was first […]
Side to Side – a touchy way to view Word documents
Side to Side is a different way to view a Word document. Flip through the pages with touches on the screen, like a book. If you’re sick of endless scrolling, Side to Side Page Movement is available for Word 365, Word 2021/2019 and Word 2016. Using Side to Side View The side to side command […]
Dagger † symbol in Word, Excel, PowerPoint and Outlook
Insert a Dagger † into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Dagger † symbol is used to indicate a footnote if an asterisk has been already used. Footnotes and Endnotes in Word Formatting Footnotes and Endnotes Dagger is a different look (depending on the font) but […]
Even more Airplane and related symbols in Microsoft Office
There are a lot more airplane symbols available in Microsoft Office including ones for landing, takeoff and even pilots. Also how to get plane graphics for specific models like a 747 Jumbo. If you know where to look, Office has plenty of ‘airplane’ related graphics beyond the simple Airplane ✈ symbol in Unicode. Office Icons […]
Removing email attachments from mailboxes like Outlook.com
How to remove or move email attachments using Outlook for Windows or Mac and the workarounds for Outlook.com in a browser. Doing this reduces the size of your online mailbox and, from 1 Feb 2023, your OneDrive storage. Removing email attachments is the fastest way to shrink a mailbox that’s getting near it’s maximum size […]
Gradient Effects and Text in Word – in depth
Adding color gradient effects to your text, shapes and borders is a good way to give it a bit more zing to Microsoft Word, PowerPoint or other Office docs. The gradient feature is quite sophisticated, with a wide range of options and adjustments available but not obvious. To add a gradient effect to text, select […]
How to put a calendar on a Windows or Mac desktop
How to add a calendar as quick reference to your desktop on Windows or Mac. It can be a yearly, monthly or weekly calendar, just like the old paper calendar / blotting paper on an office desktop in olden times (i.e. 20 years ago)! A handy place to put a calendar is on your Windows […]
Outlook Categories: why and how
Outlook has had a Categories feature for a long time … here’s how you can use it and why. Categories let you group Outlook items (emails, contacts, calendar and tasks) into broad topic areas or subjects … all without moving from their original folders. They can be subjects that a normal Outlook search could not […]
Yearly Planner / Calendar for Office Watch readers
Here’s a great Excel yearly planner that we’re delighted to share. It works for 2024 or any other year you like and highlights Public Holidays in a simple and elegant way. Office Watch friend David Peel from the UK made this workbook and let us share with our readers. He’s now added an extra so […]
What’s the deal with Excel’s Calendar Creator?
Excel has a Calendar Creator template which might work or might not. Why it doesn’t work is a little mystery but we have an alternative for our readers. The ‘Calendar Creator (any year’) template sounds great … a one-page year calendar. Find it from File | New then search for calendar creator. When the template […]
Lambda upper Λ or lower case λ in Word and Office
Type the Lambda upper case Λ, and Lambda lower case λ symbols (aka Lamda) in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Lambda/Lamda (uppercase Λ / lowercase λ) is the 11th letter of the Greek alphabet. The uppercase symbol has various uses, it is used for the likelihood ratio […]
Great Christmas images and clipart in Microsoft Office
Looking for some Christmas images, pictures or graphics? Microsoft Office has some in-built Xmas options for the festive tide of Yule. Add these images into Word documents, Outlook emails, PowerPoint slides or even Excel worksheets. Unsubtle Hint: Christmas Cheer with Office has a collection of festive cards, letters, gift tags, emails ready to open, edit […]
