All about Microsoft Office Word, Excel, PowerPoint and Outlook, Microsoft 365, Office 2021 and earlier versions.
Inside the new translation functions in Excel
Excel 365 has two new translation functions to identify language from text or translate text from one language to another. Let’s see how the work, some problems and unknowns. New in Excel 365 are: DetectLanguge() to identify the language of the text supplied, hopefully correctly (see below) Translate() converts text from one language to another. […]
Microsoft 365 Insiders blog to end .. sort of
The Microsoft 365 Insiders blog is ending, sorta. kinda. Really, it’s just moving to another part of the Microsoft.com web site. For the last five years, the Microsoft 365 Insiders blog has been the place where the company boasts about new and changed features in the Insiders or beta versions of Word, Excel, PowerPoint and […]
Effortlessly Migrate Your Notes from Evernote to OneNote
Many people are moving away from Evernote due to the high prices. Here’s the simple way to migrate all Evernote notebooks to Microsoft OneNote. Why move from Evernote? Evernote’s pricing has risen to unrealistic levels. The cheapest paid plan “Personal” is now US$129.99 which is more expensive than Microsoft 365 Family plan for six people. […]
The ultimate way to change Microsoft Word defaults.
Having trouble changing Microsoft Word defaults? The ultimate way to change defaults is sure to work. It’s has been around since the very early days of Word and works for Outlook too! We often hear from people having trouble changing Word’s opening (default) settings for a new document. Various places in Word have ‘Set as […]
Three ways to switch language in Word and one way to turn it off
Word can spell and grammar check in many languages, here are three ways to switch the language settings plus how to turn off the pesky automatic language switching. Microsoft Word has language settings that can apply to a whole document or just selected text. This is vital for multi-language documents but also has an important […]
Grouping values from an Excel list
There’s a simple but not so obvious way for Excel to take a list of values and show them grouped into segments or groups. As an example, here’s the results of a class exam with their scores grouped into blocks of 20. It’s done with a tricky use of PivotTables and one of the somewhat […]
Koalas galore in Microsoft Office
We went hunting for koalas in Microsoft Office. Found more than 18 of the cuddly marsupials for Word, PowerPoint or Outlook. There are emoji, Office icons, SVG, online images and more making a colony or cling of koala (either can be the collective noun for koala). None of the endangered species where harmed in the […]
Backstage at a popular show using Microsoft Office
“Temping” is a staple and sell-out each year at the Edinburgh Fringe Festival. It makes clever use of Microsoft Office, and we were lucky enough to get a ‘behind the scenes’ look. The show is a unique blend of interactive technology and narrative storytelling, where the solo audience member takes on the role of an […]
Copilot gets Make Changes inside Word 365
Paid Copilot plans have some innovations in the Word 365 interface with a better way to Make Changes to text plus more paste options too. These changes are in Word 365 public releases linked to a paid Copilot plan. We found them in v2407 build 17830.20138 with Copilot Pro. Auto Rewrite Paid Copilot in Word […]
Beware variable fonts with Office and PDFs
A PDF file made from Microsoft Office or Windows may not look right because of an ongoing PDF bug with variable fonts. It’s been around for years with no sign of a fix. The problem arises when variable fonts are in documents exported to PDFs (either Save As … or Print to PDF). The font […]
Office crashes while typing – the problem and workaround
Microsoft 365 for Windows might crash while someone is just typing (you read that right). All the Office apps, Word, Excel, PowerPoint, Outlook or OneNote can be affected according to Microsoft, which knows about the problem and offers some workarounds. The problem is caused by an out-of-date language pack which has all the spelling and […]
Clipchamp gets background removal with some gotchas
Clipchamp, Microsoft’s video editor is now boasting background removal which is great for tricks like adding a watermark or ‘bug to a video. But there’s some limitations or ‘gotchas’ to watch out for. Add an image to a Clipchamp timeline, right-click then choose ‘Remove Background’. Wait a few moments and the background will be made […]
Quicker ways to Zoom in Microsoft Office
There are quicker ways to use the View Zoom slider in Microsoft Word and one little-known trick that works in other Microsoft Office apps, Excel and PowerPoint. Plus a related Windows volume tip. Scroll to View Zoom Hover the mouse pointer over the Zoom slider (bottom right in Word, Excel and PowerPoint) then use the […]
Change Word Zoom to custom fixed settings
This is how to change Word’s Zoom to your preferred Zoom settings instead of the defaults. Ray R writes … “I have been having some vision problems lately and have found that using Word’s zoom dialog to increase the displayed font size without changing it in the document or email (I use Word as my […]
British Isles, United Kingdom etc. explained in a simple diagram
Understanding the difference between the United Kingdom, Britain, and England can be quite confusing. Here are some “simplified” “diagrams that might clarify things. Use this or make a SmartArt version for your PowerPoint or Word document. The late Michael Flanders had warning about usage of the terms. If it’s something good then it’s “Another triumph for Great […]
Don’t trust Excel’s Linked Data Types, always verify
Excel 365’s Linked Data Types are technically impressive. However, the reliability of the data is a problem Microsoft doesn’t talk about. We discovered mistakes with the data without actively looking for them. In general, the data sources are ‘scraped’ from sites like Wikipedia which explains some, but not all, of the omissions and oddities. Stock […]
