Adding comments to Microsoft Word documents isn’t just for groups, use them yourself for your own reminders and side-comments while you’re working on a doc. Word has a feature to let you add ‘side’ comments to documents – comments that don’t show up in the final document, don’t effect the
Baskerville has been decreed the most persuasive font after an experiment by Errol Morris and the New York Times. Happily, a very similar font is available to all Microsoft Office for Windows users. In an interview in Fast Company, Errol Morris talks about the experiment where people were asked to
Get started and understand Microsoft’s Power BI using the free desktop app. Here’s how to setup Power BI and some of its nifty tricks to delve into and make sense of data. All without the hassle of a ‘free’ trial. With plenty of buzzwords such as data-driven culture, business intelligence,
What causes blank spaces in the Word navigation pane and how to fix them. The Navigation Pane in Word shows the Headings in a document but sometimes has the unexpected. Blank lines or text not in a heading. But sometimes blank spaces appear, like between London and Paris above. Why
Excel Mobile’s Data from Picture has one big problem, it can’t figure out what’s intended to be in one cell and puts text in many cells. Cell discernment is Data from Picture’s biggest weakness and the Review process makes it hard to fix those problems. For example, text using Excel’s
Here’s the full and searchable list of Word 365 Dictation special phrases, in English. Saying any of these phrases converts the words spoken into the symbol or does a Word command. For example, say “Full Stop” and . appears in the document. Say “Dollar sign” and get $ . Say
Microsoft will be removing Excel’s Money template from Microsoft 365 Personal and Family subscriptions on June 30, 2023. Here’s details on what’s happening to your data and an alternative with a free trial. Ending the Money template is just one of three features being dropped from Microsoft 365 in mid-2023.
Insert the Checkered Flag 🏁 into Microsoft Word, Excel, PowerPoint or Outlook. Plus other alternatives available in modern Microsoft Office like icons or stock images. As its name suggests, the Checkered Flag emoji 🏁 shows a flag with a black-and-white checkerboard pattern. It’s often used to represent vehicle racing, challenges,
How to run administration commands via PowerShell for Microsoft 365 hosting and especially Microsoft 365 Exchange Server or mailbox hosting. Microsoft 365 customers will often see instructions like this to configure their Exchange Server mailboxes using PowerShell. Set-OrganizationConfig -AllowPlusAddressInRecipients $true Looks simple, but that command alone won’t work in PowerShell
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
As part of Word’s Autocorrect settings, some simple fractions will show as a symbol when you. For example, if you type in 1/4 and then space straight afterwards it’ll show as ¼. It’s done automatically from File | Options | Proofing | AutoCorrect Options | AutoFormat as you type |
Fractions like 1/2 1/4 3/4 can look better in Word and Outlook as ½ ¼ ¾ that can be done for other common fractions too ⅘ ⅚ ⅐ ⅛ among many. Either type directly with a shortcut or using AutoCorrect. We have a full table of the fractions available as
There’s an easy way to make a good looking symbol for any fraction, no matter how unusual it might be. There are symbols and shortcuts for common fractions but beyond that you need a little Word trickery. But not very tricky because all you need is on the Home tab.
Thumbs Down or Dislike 👎 can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Thumbs Down symbol 👎 or emoji is used to suggest disapproval or dislike. Partnered against Thumbs Up / Like 👍 symbol. How Thumbs Down Sign 👎
Research Assistant / Technical Writer Office Watch is seeking a reliable and organised individual with excellent research and writing skills to join our team as soon as possible. About The Role All work is remote based. We offer flexible working hours based on your existing schedule, and you will have
The serious Windows and Office security bug is now used to target organizations in Europe and USA. Despite plenty of warnings, Microsoft still doesn’t have a fix, just ‘mitigations’. Last week Office-Watch.com told you about “Follina, or CVE-2022–30190” a relatively simple hack that exploits a security bug in Microsoft’s own Microsoft
Word in a web browser has a Designer feature, like Designer in PowerPoint, to quickly make great looking documents. Designer uses Microsoft’s templates collection to suggest formatting and design change for the document. One problem with Designer, like similar Office features, is that they can be overused and too many
Suggested Images and Add Visual Emphasis options have appeared in our Microsoft Word … looks like a new but not yet announced feature. We’ve been editing Word documents with Word in a browser, when a small blue diamond icon appears in the left margin: ◇ Clicking on it added a
All you need is a birth date or starting date and Excel can figure out the age, next birthday, days to next birthday or when you reach a milestone like 10,000 or 15,000 days. That’s just some clever tricks with DateDif(). How old is someone or something? To calculate the
Peter McDonell 1938-2022 We sadly must report the death of Peter McDonell, a good friend of Peter Deegan and Office-Watch.com. Peter died peacefully on 4 June 2022 aged 84 Peter was one of those people you don’t forget even after a short meeting. Friendly, open and fun with a wonderful
Here’s a quick look at some of the modest Excel tricks we used to make the Schengen Visa Calculation worksheet. Table Making the itinerary list an Excel Table lets us make use of some features. Formatting It’s a lot easier to format as a table with banded rows. We’ve turned
Our annual Microsoft Word vs the Spelling Bee Champions contest is on again for 2022. Word has done better than in the past but was still beaten by another extraordinary 14 year-old. 2022’s Spelling Bee Champ is Harini Logan, 14, from San Antonio TX who narrowly beat Vikram Raju a
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes