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,
Excel 365 has a way to grab information about movies dropped directly into worksheets. Get info about films, cast, director, rating, budget, box office returns and a lot more with the Linked Data Types. Our ebook Real Time Excel goes into detail about Linked Data Types as well as more
There’s a quick way to clone or duplicate an existing file in Windows 11 so you can make a new, similar document. Quite often a new document is based on an existing one, for example a fresh invoice for the same things each month. Or a proposal to a new
Why are the numbers on the numeric keypad are different from the number keys on the top row of the keyboard? How to use either set of number buttons in Microsoft Word. “I don’t understand why pressing a number on the main keyboard is different from the number pad (assuming
“I’m confused. In Outlook there are two choices for a UK/London time zone. UTC or London. Both are zero meridian (+00:00). What’s the difference and why isn’t an entry for GMT?” Oscar R, Missouri. The quick answer is to always choose the time zone entry that matches the city or
Email Read Receipts sound great but don’t often work these days. Articles like “How to tell if someone opened and read your email” aren’t telling the whole story. Here’s the reality behind the Outlook ‘Read Receipt’ feature and how it works across the Internet. The idea is to send an email
The appearance of all your captions in Microsoft Word can be changed by modifying the style that is applied to them or selecting the text and formatting manually. See Adding Captions in Word Caption Style All captions use the ‘Caption’ style, so modifying that style will modify the format of all
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format
There are four different ways to change an Office icon or SVG graphic in Microsoft 365, Office 2019 or Office 2021. The two official SVG edit methods in Microsoft Office with their in-built limitations or some choices before inserting into Word, Excel, PowerPoint or Outlook. Within Office Limited SVG/Icon changes are
Some simple changes to SVG graphics can bypass some of the more annoying limits of SVG support in Word, Excel and PowerPoint for Office 2019/365. Here’s a simple SVG with three parts: the circle <circle> the rectangle <path id=”bar” …> letters are defined in other <path … > and <use
Draw with Touch is available for users with a touch-enabled device. Simply draw with your mouse, digital pen, or even your finger on your OneNote page. You might be familiar with Draw with Touch on OneNote for Windows desktop. Great news, this feature has recently been added to OneNote for
At long last, OneNote can sort the pages (tabs) either alphabetically or by date. Previously in OneNote, if you wanted to sort out your pages, had to do it manually by dragging and dropping the tabs. Microsoft has now added an automatic Sort Pages option. Right-click on a page tab
What’s the difference between aligning to a page and align margin in Word documents? Quite often, there’s no practical difference between ‘Align Page’ and ‘Align Margin’ in Word. These options appear when positioning an object on a page and other places. Centering an object has to be done compared to
Set Picture as Background in OneNote is a handy feature for those looking to fill in forms or wish to draw and highlight on top of images pasted into their OneNote page. Generally, the page can shift, and your notes can become a complete mess when inserting images, so it’s
Sometimes you might be making a video but need to add text to it, luckily video editors, like Clipchamp, make this super easy to do so yourself, in no time at all. For example, you might want to add just some text, titles, or subtitles, or even captions to your
Excel’s Find All lets you locate all cells matching a search criterion in a single step. It will generate a list of all cells that match the current search and report them all at the bottom, for both Windows and Mac releases of Excel. Find All has been in Windows
How to show original text and a translation side by side in Word. The recent versions of Word have had an in-built translation feature that, like so many things in Microsoft Office, doesn’t quite go far enough. The basics are simple enough. On the Review tab there’s a Translate button.
Like an image in an Microsoft Outlook email? Here’s how to save it to a separate picture file. Sometimes you get an email with a nice picture displayed in the message (as opposed to an attachment). You can ‘grab’ any image and save it to your computer. On most web
How can you change the default program for .RTF documents away from Word and make it stick? We’ve talked about the virus security risk of Rich Text Format .RTF files which even Microsoft has, at times, suggested blocking. Despite that, .RTF files are associated to Word during the Office installation.
There are two ways to make a text box transparent in Office; Word, Excel or PowerPoint. There’s a quick option and other that gives you some more control. The Word, Excel or PowerPoint ‘Text Box’ feature is presented as a way to have ‘pull quotes’ or sidebar text in your
With an Microsoft 365 plan, Family or Personal, how many tablet and smartphone devices can you install Office Mobile? The rules have changed over time, so confusion is understandable. Some emails to our Feedback page plus people we’ve met shows some confusion about how many tablets/smartphones you can load up
What is an RTF document, is it safe, how to use in Microsoft Word and why is it still being used? “I’m looking for a job and many employers are asking for my resume in RTF format. How do I do that and why can’t I just use a Word
