Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill was added in Excel 2013 for Windows. It’s both useful and looks good in the demonstrations. In Excel there’s often need to join, separate or reformat strings of text. Flash
How to add footnotes just below a photo in Microsoft Word The trick is similar to adding Footnotes to a Word table. Use Endnotes, instead of Footnotes (assuming you don’t use Endnotes elsewhere in the document). Add a Continuous Section Break and change the Endnotes settings to put them at
Moving the selected lines/s to a different numbering level in Microsoft Word is officially done from the Numbering Gallery | Change list level but there’s are quicker keyboard shortcuts. The faster way to do this is shortcuts: Alt + Shift + RIGHT arrow Down / right one level Alt +
Microsoft Excel Series allows users to automatically insert a list or series of values. You probably know the easy ‘drag and drop’ method but there’s a lot more possible with linear, growth, dates and autofill. All possible with the fill handle or with more control via the Series dialog. Whatever
Inserting an .ics iCalendar item into Outlook is typical Microsoft Office. Seemingly easy if you believe the simplistic ‘help’ from Redmond but a little more involved in practice. iCalendar .ics files are small text files which contain an appointment or event. It’s a common standard so they can be used
Type the Pound Sterling £ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. £ symbol is easy on a UK keyboard but for other keyboards there’s no specific key for Pound. Pound is used for British Pounds Sterling and also
Immersive Reader, as seen in Word and older versions of OneNote, is returning to the latest releases of OneNote It’s a worthwhile tool to use, designed for those with dysgraphia or dyslexia, but perfect as well for those wanting to improve their reading experience. Here we’ll be using OneNote for
Samsung phones have a hidden service which is slowing down Microsoft Office apps including the mobile apps for Word, Excel, PowerPoint, Outlook and the Office ‘all in one’ app. Inside some of the new S22 Galaxy smartphones is a Games Optimization Service, or GOS. Cynical techies know to be wary
Now you can see on the status bar if there’s accessibility problems as you work with your Word, Excel or Powerpoint documents. Tucked away on the Accessibility Pane is a option to run the accessibility checker as you work, instead of only on request. Keep accessibility checker running while I
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,
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
