Here’s a simple way to redact cells in an Excel worksheet. There’s no direct redaction tool for Excel to match the Microsoft derived Word Redaction Tool. What are the alternatives? Editing the worksheet Copy the worksheet then carefully edit it to remove the private content. Make sure you remove data,
Find and add the Ukraine flag or national colors into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. Ukraine Flag Image There are many, many copies of the Ukraine flag available. We’ve opted for the Wikipedia site because it has an SVG scalable version (preferred)
Excel is getting even more help to write formulas, look out for Argument Assistance coming to Excel on the web and hopefully beyond that. Argument Assistance won’t solve loud disputes with your partner, boss or that annoying guy on the bus. It’s a larger panel to guide people through completing
Excel has an Accessibility Ribbon to help you make changes to ensure that worksheets are easier for people with disabilities to read and edit. For some time, there’s been a Check Accessibility feature on the Excel Review tab. That opens a side-pane with suggestions for improving the worksheet. Go to
“You say Kiev, I say Kyiv” for the capital of the Ukraine. How does Microsoft Word handle the different spellings and how to pronounce the name with Read Aloud. See also Ukraine flag & colors in Word, Excel or PowerPoint Is it Kiev or Kyiv? Kyiv is the Ukrainian spelling
It’s vexing that the numbering features in Word aren’t all in the one place. Instead they’re spread across different dialog boxes including “Adjust List Indents … ” and “Set Numbering Value…”. Those two bland names hide some useful Word tricks. Numbering can also be set as a style. The main
Word has at least seven in-built numbering for common uses in documents, some that you know and appear automatically with others hidden away and little understood. We’ve told you about Word Numbered List tricks and Hidden Numbering options in Word plus Faster Numbered and Multi-Level Level changes Headings have numbering options at
The Microsoft Family Safety app is a parental control app, allowing you to keep an eye on your family’s app usage and screen time, amongst other features like location tracking and filtering the content they see. Family Safety has some premium extras for Microsoft 365 Family accounts. It’s available for
There’s more to making subtitles for a PowerPoint (or any) video. Converters from .srt subtitles, using Microsoft Transcribe or using online tools to make your own subtitles from scratch. Webvtt vs Srt files Webvtt files (used by PowerPoint) are similar to the standard .srt subtitle files (used by Windows Movies
Insert the Black Chess King ♚ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♚symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or perhaps as general symbol of
You can combine Excel cell formatting into a style, but not like in Word. Excel has Styles … truly it does. Word has a way to combine formatting attributes of a letter, word or paragraph into a single block with a name like ‘Heading 1’. Excel has a feature also
Slipped into the bottom of a long Microsoft announcement was news about which versions of Microsoft Office would not be supported on Windows 11. According to Microsoft, Office 2013 is not supported on Windows 11. With that little snippet of news, here’s the list of Office releases that ARE supported
Get the best quality images in a PDF file made from Microsoft Word for Windows by changing some simple settings. There are also options in Word for Mac, Excel and PowerPoint. Better quality images in the PDF file are possible, starting with Word’s settings for saving images within the document.
Accessibility Checker serves as a free tool that helps ensure that Office files are easy to understand by everyone. Use it to quickly fix common Office doc problems that can make your documents, sheets and slides harder to comprehend. It’s available for Microsoft 365, Office 2021/LTSC and Office 2019. Word,
There’s a curious trick which might let you print a PDF that’s causing printer errors. An Office Watcher started getting PDF’s which looked OK on the screen but produced errors when he tried to print out. Otherwise the printer worked fine so the problem seemed to be in the PDF
Amazon UK is offering Microsoft 365 Family at about £31 less than the usual price for both new and renewing customers. Thanks to an Office Watch reader, we can tell you about an even better deal from Argos. An even better ARGOS Offer Thanks to Julian H. for telling us
A clever techie, Rudy Ooms, has found a worrying bug in Windows 10 and Windows 11. The Wipe and Fresh Start options are supposed to remove all user data from a computer but leave really obvious files behind and unencrypted. The problem is the Windows feature which is advertised as
A delightful piece in The New Yorker turns a resume cover letter into an ode about the applicants love of Microsoft Word. Eli Burnstein’s humorous article opens with: “Bold and italics are the oils that grace my palette. Cut and paste the strings upon my lyre. Fonts, bullets, columns, indentations—these
Amazon UK is offering Microsoft 365 Personal at about £30 less than the usual price for both new and renewing customers. There are a few peculiarities about the offer, we’ll explain those below but the basics are: Microsoft 365 Personal (one user) New or renew/extend existing plan Regular price £59.99
Microsoft has released a preview anti-virus and security apps for Apple iPhone / iPad, Android plus Windows and Xbox called, confusingly, Defender. Trial apps are available for personal use now but in future you’ll need a Microsoft 365 Personal or Family plan. Defender was the name of Windows protection parts
The Outlook mobile app from Microsoft is ending its support for older versions of the Android operating system. Office Watch explains who is affected, how and when. All these changes apply to devices with Android 7.1 and previous. That’s a quite elderly version of Android (by tech standards). The current
Jon has found a clever way to show words (singular, plural or zero) with many numbers in Excel using conditional formatting. We already shown you several ways to put singular or plural words against numbers in Excel – like 1 cookie or 3 cookies. At the end we noted how
Microsoft has recently added the ability to resize Embed content within OneNote Web. It was already available for the Desktop versions, but now it has been introduced to the OneNote browser based version too. Simply by inserting, pasting, or linking content right in your notes, you can embed a variety
There’s been an uptick in interest for coloring in pages, having the power to relieve anxiety and a form of mindfulness or just pass the time. No wonder Microsoft jumped on the bandwagon and provided a number of coloring-in templates for Word and PowerPoint. As you browse their template selection,
