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
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
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
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
The BBC has released some high-quality images from their famous TV shows to be used as online meeting backgrounds or in PowerPoint slides. Pick from Doctor Who (old or new), Fawlty Towers, Yes Minster, Match of the Day, Eastenders and more. Consider using these BBC TV backgrounds in PowerPoint for
Some imported Outlook calendar items can’t be changed, here’s why and how to make the imported appointment editable. Understanding issues with an Outlook imported appointment can help you manage calendar inconsistencies. Usually an imported appointment (via a downloaded .ics file) can be edited just like most Outlook calendar items. Often
Can Microsoft Word handle a newly famous name “Walz” or does Word think it’s a spelling error? What about the other VP candidate, “Vance”? In the last few hours, we’ve seen social media posts like this: “ Okay, word people, now would be a great time to put a “Walz
Here’s how to save a Word document with the private and hidden details automatically removed. Normally, you’re expected to manually go to File | Info | Inspect document to check/remove things like comments, hidden text, header, footers or watermarks. What if you want it to happen automatically, whenever you save
Here’s some more ordinal rank (First, 2nd etc.) options for Excel including with joint or equal results plus special fun wording. In a previous article we looked at options for showing ordinal numbers in Excel, now we’ll go a step further to cope with joint or equal results plus special
Here’s the complete step-by-step manual method of replacing text with filler or anonymous words in Microsoft Word. This is quite easy, the main thing is to be careful with the Find and Replace expressions. It will work with any version of Word that has the ‘wildcards’ / Regex option which
A US government department has accidentally revealed a secret by overlooking the obvious in Office document security, the file name. Microsoft Office helps you scrub documents of private or secret information before sending. It’s easy to overlook the obvious data leaks that ‘Inspect Document’ doesn’t cover. ‘Inspect Document’ checks for
Add to your Outlook a special Paris 2024 Olympics calendar shows all the events plus opening/closing ceremonies with times in your location and search for favorite events. A special Olympics calendar shows all the events plus opening/closing ceremonies with times in your location. This calendar shows the Olympic calendar in
Here’s how to quickly add events from the Paris 2024 Olympics into your Outlook calendars, showing times in your location. The Paris Olympic organizers have provided an online calendar with .ics calendar files for individual events from their website. Those calendar files can be imported into Outlook for Windows or
Pronouncing the name “Kamala” is a source of confusion even to Microsoft Office’s Read Aloud feature which needs a little tweaking. How does Word’s grammar check handle the possessive, it is Harris’s or Harris’? Kamala Harris has a Sanskrit based name which is simple to pronounce once you know the
Securing your email account is vital. It’s the one thing that everyone must do unless they want hackers to invade your privacy and possible steal your money. A news story from Australia is yet another lesson in why everyone should properly secure their email account with two-factor authentication. A lady
Microsoft Office has a Remove Background tool for images but there are two better, faster and free ways to do the same job. Background removal lets you get an image with a transparent surround which can be merged/overlaid into any other slide or document more seamlessly (left) than a separate
There are two quicker ways to insert an image or graphic from the Internet or web page into a Word document, Excel sheet, PowerPoint slide or Outlook email. The method most people are taught is to save an image to their computer then Insert | Picture | from this device
The Background Removal Tool in Microsoft Office lets you neatly delete the background of images with just one click. It makes the photo subject stand alone with a transparent background. We’ll explain how remove background really works, it’s not quite as simple as Microsoft’s demonstrations make out. Windows 11 Paint
Add Spain’s national flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Get the Spain Flag Image There are many, many copies of the Spanish flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred)
Don’t miss this often overlooked Office trick, changing the color of an image or graphic in Word, Excel, PowerPoint, or Outlook. We did this in our article about inserting Prince’s ‘Love Symbol Number 2’ in Office documents. The image is available in various formats but always black, not purple. As
Add England’s national flag “St George’s Cross” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Not to be confused with the British “Union Jack” flag, the English flag is a simple red cross on a white field. Many online searches for
Some Microsoft 365 and Microsoft Office users have been getting “30088-27” errors when trying to update the app in the past month. Users of Click-To-Run (C2R) versions of Office 2016, 2019, and 2021 are affected as well as Microsoft 365 when updating to Office version 17726.20126. The update error says
Here are 12 suggestions and shortcuts to let you navigate a Word document faster. Word has many ways to navigate a document, most of which are hidden away and not obvious to the casual users. Once a document gets past a few pages, you need options for moving around that
The Navigation Pane is a great part of Word for Windows and Mac. Don’t miss on the hidden features because there’s more in that side-pane than the obvious. Navigation Pane is the best and fastest way to move around a document. It’s available in Word for Windows (Microsoft 365 and
