Make Excel mobile for iPhone or iPad read aloud a workbook. Great for double-checking figures from a printed source. The options aren’t very good but we’ll explain what might be possible. Excel 365 does not have a Read Aloud or Speak feature similar to Word for iPhone/iPad let alone Word
Grab high-res still pictures from movies and videos to insert into Office documents or emails. We’ll show you how to capture or grab a proper, full size, high-resolution still image from a high quality video file then paste that picture into an Office document or Outlook email. Why do this?
It’s now possible to insert a PowerBI report directly into a PowerPoint slide, finally resolving a long-standing customer demand and glaring omission. The PowerBI report has filters and pivots to adjust the display directly. The data is live in both Edit and Slide Show modes. Microsoft calls this Interactive Data
Outlook for Mac is now available to all, no payment or subscription required. It combines email, calendar and contacts in the one app. Anyone with a recent Mac computer can install Outlook for Mac for email, calendar and contacts from the App Store. All the common and most less-common email
Here’s how to replace private or confidential text with ‘filler’ nonsense or anonymous text in a Word document. Handy for getting help with Word formatting or numbering problems where you can’t share the real document to an outsider. This is often a problem for legal workers or others with privacy
Losing recent work on a document is really frustrating so here are a few tips to make Office document saving more reliable, with less risk of loss if the computer or Office programs crash. A few changes to Microsoft’s defaults can mean lower blood pressure for you. Save AutoRecover every
The ultimate in PowerPoint Handouts aren’t made in PowerPoint at all. Link a presentation to handouts in Microsoft Word, where you have all the powerful Word formatting features available to you. You’re forgiven for not knowing this option existed, because it’s not immediately obvious and you need to go several
Insert lower case letter with circles ⓐ to ⓩ in Microsoft Office, Word, Excel, Outlook etc. Officially they are called Circled Latin Small Letters. Circled small letters in different fonts Only two common Office fonts have double circled digits Segoe UI Symbol and Calibri. Here’s how the symbols look in both
The rainbow shape with multi-color effect is possible in text, shapes and images for any Microsoft Office documents including Word and PowerPoint. With a few changes you can make a rainbow for documents or slides. Rainbow Text Effect Insert | WordArt choosing whichever preset is closest to what you want.
Here’s how to mask a photo with any Microsoft Office shape or icon and do it with full control over what appears from the original image. We’ve already explained two simple ways to crop a photo to a shape or fill a shape with some options to move and resize
The picture option ‘Set Transparency Color’ doesn’t always work properly in Microsoft Office. We’ll explain the problem and suggest some fixes. When we were making our article “Make a transparent shape to mask a photo in Word, PowerPoint and more” we discovered that the ‘Set Transparent Color’ option didn’t work
Recent investigations have revealed some worrying truths about the risks in opening OneNote notebooks, a surprising fact about .one files, some bad news and good news. Criminals are increasingly sending out nasty OneNote .one files in emails, taking advantage of another Microsoft security ‘blind spot’. OneNote Embedded File Abuse from
XLL addins for Excel coming from the Internet will be blocked by default as a security measure. Here’s how it works and how to enable XLL files and bypass the new block. You can implement a similar block now in other Excel versions without waiting for Microsoft’s late change. Excel
The ‘speech to text’ Dictation feature is now in OneNote for Mac. Look on the far-right of the Home tab for the Dictate button. Click on it to make the little Dictation toolbar appear. Our book Dictation and Read Aloud in Office explains Dictation and other Office speech features from
There are new look menus and toolbars coming to the iPhone Microsoft Office apps, Word, Excel, PowerPoint and the all-in-one Microsoft 365 app. We’re not sure when you’ll see these changes because they are three months late! Microsoft started talking about this ‘fast and fluent’ change in November 2022. Three
There are two ways to switch between Letter (Imperial) and A4 (Metric) paper sizes for Microsoft Word documents on Windows or Mac. One is easy and temporary, the other changes the document itself. Also how to switch Word’s default paper size and how to save PDF’s to another page size.
What does Ctrl + Enter do in Outlook for Windows and why doesn’t it always work? What’s the equivalent in Outlook for Mac? Ctrl + Enter can be a shortcut in Outlook to send a message after you’ve finished typing. However Ctrl + Enter isn’t always available — in Outlook
Word’s Citation and Bibliography support is enough for some people, but not for everyone so here are tools available to go beyond what Microsoft provides. See Add a Bibliography to Word documents Custom Bibliography formats or styles in Word Citations for everyone in Word Source Manager for citations in Word JabRef
There’s a simple way to tell if your mailbox has the useful plus + address feature. Plus email addressing (aka disposable or sub-address) is sometimes available automatically (Gmail or Outlook.com) or has to be switched on (Microsoft 365 hosting). Some other mail hosts might have an option to allow plus
A peculiarity of indexes when you use big table cells to format your Microsoft Word document — and a suggested solution. Karen from New Mexico wrote to us describing a strange behavior in her Word document indexes. The documents are class handouts with each topic as a new row in a
Have all your favorite Office features and buttons in one place. Commonly used buttons or options that aren’t on the regular ribbon. The Office ribbon lets you make a personal tab filled with your choices. We will show you how easy it is to make in Word below, but this
A Word Drop-down list lets you quickly choose one of several options. It’s a fast way to make new documents with a standardized pattern. Don’t be scared, it’s easy to create even though the word ‘Developer’ is involved. We’ll show you how to make drop-down lists, change the bland ‘Choose
How to make a bullet list that has different bullet symbol or emoji for each Word or PowerPoint line. With the wide range of symbols and emoji in Word and PowerPoint there’s scope for creative lists that use symbols that relate to each line. It’s not possible to do that
Insert digits with double circles from ⓵ to ⓽ in Microsoft Office, Word, Excel, Outlook etc. Use them as an alternative way to number a list like this … Double Circled digits in different fonts Only two common Office fonts have double circled digits Segoe UI Symbol and Calibri. Here’s how
