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.
Apple command ⌘ symbol in Word, Excel, PowerPoint and Outlook
The Apple command ⌘ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Apple command ⌘ symbol appears on Mac and iPad keyboards but only as a command option, not as a symbol to type. The ⌘ symbol predates Apple computers. It’s a ‘PLACE […]
Excel Formula Bot upgrades and goes pro
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite still in beta testing. Please […]
Great Periodic Table documents for Microsoft Office
There are some great and editable Periodic Table of Elements options available in Microsoft Office – Word documents, Excel spreadsheets and PowerPoint slides There are many Periodic Table ‘documents’ on the net but most are PDF’s or images that can’t be changed. We’re looking for editable Word documents and Excel worksheets that you can adapt, […]
North West/Top Left Arrow ↖ in Word, Excel, PowerPoint and Outlook
Insert the North West or Top Left Arrow ↖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. North West Arrow ↖ or “Top Left Arrow” can be used for directions on a map (naturally) or pointing to ‘top left’ in a Word / PowerPoint table or Excel […]
Excel merge arrays into a single array with VBA
Until late 2022 an annoying omission from Excel and VBA was a simple way to combine or merge arrays into a single array. Here’s how to do it with VBA for older Excel releases. Excel 365 for Windows and Mac now have HStack() and VStack() which will combine dynamic arrays or ranges. The VBA method […]
Six workarounds when your keyboard breaks
Your deadline is in four hours, you’ve got pages to write and BAM! a letter key breaks on your keyboard …. What do you do? There are at least six different workarounds available in Word, Windows and Mac. A broken key happened to Colin Chambers, a University of Buffalo student when a drink spilled on […]
Sentence spacing in Word – one, two or don’t bother?
Is there one space or two between sentences? Word lets you check the sentence spacing or ignore it completely. It’s a useful option for those of us who learnt on manual typewriters where double sentence spacing was standard. Switching to single spacing is hard for your fingers to remember. One Space or Two People can […]
‘Punctuation required with quotes’ in Microsoft Word
‘Punctuation required with quotes’ is the most commonly changed Microsoft Word grammar and style setting. It checks is for the location of commas etc. when used with a quotation. Here’s two similar sentences to demonstrate: In US usage, the sentence punctuation mark go inside the quotation marks. In standard British /Commonwealth usage, the comma is outside […]
Why Word’s Alphabetical order is different from a dictionary
Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what I was taught at school and apparently I was taught wrong. There are at least three ways, two used by dictionaries, another by Microsoft and that’s for English alone! Reading Sue Butler’s delightful book ‘The Aitch […]
Sharing Outlook appointments – the right way
There’s a right way and wrong way to send invitations from Outlook. ” I tried your tip about sending calendar appointments to other people but it doesn’t work. I write an email invitation then add a calendar item. The receiver doesn’t see the Accept, Decline etc buttons above the message, instead they have to save […]
Opening Office documents from removable storage
Can or should you open Office documents directly from removable storage like portable hard drives, USB ‘memory sticks’ or even floppy disks? Since we wrote about removable drives and drive letters we’ve had long time Office users asking about opening documents directly – should it be done at all. Many years ago, it wasn’t a […]
Watch your sort and other Excel traps for the unwary
Sorting numbers in Excel looks easy but there’s traps if you’re not careful. Let’s look at an example of sorting gone wrong, how it’s easy to do but also fix. Finally how modern Excel has several features to warn you not to fall into a common mistake. This table popped up on Twitter (original source […]
Ctrl+F6 mystery revealed in Excel
The Ctrl+F6 shortcut in Excel doesn’t behave the same way as Word or PowerPoint. It changed a few years ago to behave differently from what most Office users expect. Ctrl + F6 will switch (cycle through) the open windows in Word or PowerPoint. It’s a quick way to move between different documents/slides. Since Windows doesn’t […]
Make transparent images in Office for Windows
Microsoft 365 and Office 2021 for Windows can make images transparent in Word, Excel, PowerPoint and Outlook. Text or other graphics can show through the picture. Pictures can be made transparent to reveal what’s behind in lower layers of the document, slide or worksheet. For any image go to Picture | Format | Adjust | […]
Get the Game of Thrones look in Word and PowerPoint
Here’s how to get the Game of Thrones or House of the Dragon look in Word documents and PowerPoint slides. Plenty of people have borrowed the Game of Thrones or GoT look, including a certain US President. All these uses are contrary to various trademarks by HBO. Despite legal complaints there are many ‘tip of […]
Understanding the \s switch in Word’s {SEQ} code
The \s n switch inside the { SEQ } field code isn’t easy to understand so here’s an example of how it resets numbering after a Heading style. Use {SEQ \s n } to restart numbering from 1 after a chosen Heading style. E.g. { SEQ Identifier \s 1 } to reset after Heading 1 […]
