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.
Get more from your Keyboard: How to Turn the Caps Lock Key Into Something Useful (or Disable It)
If you often hit the CapsLock key by accident,sending part of your text into unwanted ALL-CAPS mode, you’re not alone. But rather than letting it stay a nuisance, you can repurpose it or disable it altogether. Stop accidentally turns CAPS ON when you don’t want it. On Windows or Mac you can remap CapsLock to […]
Excel blooper history – mistakes by users and Microsoft
Excel is now 40 years old and it’s capable of some amazing things. Let’s not forget some of the mistakes made by users and serious bugs by Microsoft along the way. First a reminder of some Excel bugs and how Microsoft never seems to learn from their mistakes. Excel bug adding rows and columns Back […]
Halloween icons and symbols for Word, Powerpoint and more
Quickly add a Halloween ghost, pumpkin, witches’ hat and more to your Outlook email, Word document or PowerPoint slides which have many in-built icons, graphics and pictures to enhance your “All Hallows’ evening” Icons, Stock Images, Stickers and Illustrations are all available in Microsoft 365 for Windows or Mac. Some Icons are also available in […]
RandArray – Excel’s best way to get random numbers
My ‘go to’ way to get random numbers in Excel is the new-ish RandArray because can do everything that Rand() or RandBetween() can and more. RandArray() fills cells with random numbers for as many rows and columns as you want. It’s in Excel 365, Excel 2024 and Excel 2021. The most basic version of the […]
Great PowerPoint heading with picture fill
Adding a picture to PowerPoint text background look great and is easier than you might think. Even better, are many hidden options to adjust the image and position it exactly as you want. Curious about how to create text effects like in the image below? Look no further—if you have PowerPoint, you can easily do […]
Excel in Fiction
Excel is everywhere including in crime fiction here’s some examples. Jo Livingstone has compiled some excerpts from novels that mention Excel. “George spent the next week glued to the chair in front of his computer, plugging new figures into his Excel spreadsheet, moving them about from column to column like some elaborate chess game.” “Safety […]
Straight lines and neater drawn shapes in Office
If you’ve used OneNote recently, you’re probably aware of the feature allowing you to draw shapes and make lines straight. Then Word for Windows got “Draw and Hold”. Now Excel and PowerPoint can draw straight lines and draw neat shapes (circle, square and more). We’ll explain how it works and how it’s different to the similar […]
Excel tricks to highlight selected row, column, heading and more
Make it easier to see your current cell in an Excel workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on this method; two colors, headings […]
Make simple bar charts with Conditional Formatting
Excel can make bar charts in-cell without bothering with the full Chart system. Despite what you might have seen, there’s plenty of options in Excel Data Bars. The usual example of Excel Data Bars has the colored bar in the same cell as the value. In this article we’ll show how it’s possible to have […]
Check your Microsoft account recovery options … now before it’s too late
It’s not enough to setup two-factor security for your Microsoft account. Make sure your recovery settings are checked and up to date. Do it now before it’s too late. Today we’re helping someone trying to login to their Microsoft account after losing their password. Many, many hours of frustration and worry that could have been […]
Investigating the Word language bug
Here’s how Office Watch reader, Erik and we drilled down into Windows and Word to narrow down the source of the Word language bug. Erik’s tests are with Office 365 on Windows 11 Pro 23H2 but the same behavior has been reported by others in many versions of Word and Windows. Office Watch had a […]
Inside the Language choice bug in Word
Sometimes Word will switch to another language despite all the settings saying otherwise. With the help of an Office Watch reader, we’ve dug into the details to find what might cause the bug in Word and suggest some possible solutions. Word and Office should obey the default language setup in Office but, as some people […]
Famous logos with the fonts they use
Ever wondered what font is used in a famous logo? There’s a fascinating collection of familiar brands with their names replaced with the font name. Emanuele Abrate has made Logofonts, for example the Starbucks logo with the font name, FreightSans Black. Nike uses Futura. WhatsApp with HelveticaNeue. YouTube uses AlternativeGothic and Instagram has Billabong. Once […]
How to correctly spell Brontë in Microsoft Word with the diaresis
An 85-year-old blunder has just been fixed at Westminster Abbey to change the spelling to Brontë with the important diaresis. Here’s how to type an ë in Word and other matters arising. Here’s how the memorial to the Brontë sisters looked in Poets Corner until a few days ago. For 85 years this memorial, seen […]
Audio tricks and traps in PowerPoint
There are plenty of audio and music options available in PowerPoint if you want to give your audience a break from your voice. We’ll go beyond the simple ‘adding music’ help to give some practical advice for audio in presentations: You will find the audio basics at Insert | Media | Audio Choose a music/audio file […]
Add genuine BBC Sound Effects to PowerPoint
The BBC has a great collection of over 16,000 sound effects that you can add to your PowerPoint presentations. Use them as a trigger sound for a click on a presentation, as a novel background noise or even an alert sound on your computer or smartphone. Sound Effects Galore Exploring the 16,000 sound effects available […]
