An essential Excel testing and debugging tool is finally in Excel 365 for Mac. The Watch Window makes fixing workbooks a lot easier. Watch Window is a separate pane which shows the current status of selected cells from across many workbooks or sheets. When you can’t figure out why Excel
Word is getting a better font picker, and not a moment too soon. The improved font selector is due ‘any day now’ in Word on the web and hopefully in Word for Windows without too much delay. The standard Office font selector is way overdue for improvement. It’s been stuck
Here’s a good video that explains the changes coming to Microsoft Office.com portal Big Tick ✔️ for a Microsoft video that’s more substance than style. Also ✔️ the lovely peg-board for office supplies. Some ❌ marks for too often used Microsoft Hype™ words the form of ‘Excited’ and ‘Experience’. Two
There are some good and practical changes coming to the main web portal for Microsoft Office users, Office.com plus some features already available you might not realize. These changes are either happening now or in the coming months. As usual, there’s a gradual rollout to Microsoft server farms across the
ClipChamp is an online video editing service that’s been bought by Microsoft and is now available to their customers. Not just long videos but also very short ones for social media. It has a wide range of ClipChamp features for both personal and business use. Video Editor Templates Stock image
A reminder that older versions of Outlook for Windows, including some Outlook 365 are ‘ending’ in November 2021, meaning they won’t connect with Microsoft hosted mailboxes, including Outlook.com Microsoft announced this many months ago however their latest list of affected software includes some older versions of Outlook 365 for Windows.
Microsoft Office 365 has a very interesting addition to their stock graphics range called “Cartoon People” but is really a lot more than just people. Cartoon People has been added to stock Images, Icons, Cutout People, Stickers and Illustrations. Access it from Insert | Pictures | Stock Images or Insert
Here’s a better look at more Cartoon People graphics in Microsoft Office 365. Check out the main categories, how to search Cartoon People and some useful search terms. This article looks at the people graphics available under the ‘Cartoon People’ section with many examples to give you a better idea
It’s called Cartoon People in Office 365 but there are plenty of non-human graphics available to use either on their own or as part of a combined graphic. See also How to find more Cartoon People in Office 365 to see the human side of this feature for Word 365,
The latest macOS, v12 called ‘Monterey’ is out now. Which Microsoft Office for Mac will work with the new operating system for Mac computers? Should you update to Monterey now or wait a little while? In short, any Office for Mac which works with ‘Big Sur’ macOS v11 is OK
There’s a new generation growing up who see the Office ribbon differently from their parents. To some young people a floppy disk icon looks more like a vending machine! Check out this icon on the older Office ribbon …. To you, me and most people it means ‘Save’ because that’s
Microsoft has some Halloween related images, icons and more to add a little spooky to your documents and slides. See more Halloween suggestions – images, icons, fonts and more. We had a look through the Office Stock Content (Insert | Icons or Insert | Pictures | Stock Images) for Halloween
Excel is (finally!) fixing an annoying display problem with a change to smooth scrolling for large cells. Display of worksheets has always been on a ‘snap to cell’ basis meaning you scroll down or across to see a full cell or row at a time. That mostly makes sense for sheets
Microsoft PowerToys have fixed a glaring omission from Outlook, Windows and the Edge browser. PowerToys now lets Outlook preview PDF, Markdown and SVG attachments in the Reading Pane. For too long, the main way to get an Outlook preview of a PDF email attachment was to install the whole Adobe
Word has many options to make simple checklists that you can print out and tick with a pen (ink or digital). Plenty of formatting choices for the shape of the tick ‘box’, it’s color and size. There’s a simple shortcut to re-order the list. Previously we’ve discussed how to make
Redo is the often-forgotten partner to Undo. It’s mostly used to ‘undo an undo’ or reverse the last ‘Undo’ action but ‘Redo’ has other uses in Word, Excel, PowerPoint and Outlook. In most cases, you use the redo button to revert to a previous state. For example, if you used
Android users with the Office mobile app also has a voice recording and transcription option. It’s a step up from a simple voice memo, offering live speech to text transcriptions, as well as synced text highlighting during audio file playbacks. Recordings can be exported to other Office 365 apps.
Excel and Wolfram have teamed up to produce a handy interactive Periodic Table Template, useful for those searching for an introduction to chemistry, or a handy guide for study. The table lets you easily access information on elemental properties, chemical compounds, diagrams and more. You can download or open the
Here’s the short list of new and changed features in Access 2021. It has only three new and changed features in the high-end Office 2021 and Office LTSC 2021 bundles. Remove, relink, or refresh linked tables The Access database includes a Linked Table Manager that provides a central location for
Visio 2021 has only two new and changed features in the high-end Office 2021 and Office LTSC 2021 bundles. Visio’s new shapes and stencils Microsoft has added many more stencils for users to use when creating Azure diagrams. For example, stencils can be used to create diagrams on network topologies,
Back in 2010 an Office Watch reader drew our attention to this Microsoft Knowledge Base article 2008277 (update: after we published this article the KB article was totally removed by Microsoft). “Error message “The command cannot be performed because a dialog box is open” when opening a Word file from outside
An essential part of Word’s citations and bibliography feature is the Source Manager dialog – here’s how to, er, manage the Source Manager. Open the Source Manager from References | Citations and Bibliography | Manage Sources. There is a Current List (at right) which is saved in the current document.
The workload of students and academics has been made a lot easier with the arrival of Citation features in Word. They are useful for everyone, not just in academia. Citations are individual references to source material you’ve quoted in your document. A Bibliography is a list of citations and sources
Microsoft Word’s ‘Similarity Checker’ compares Word document text with online sources. That can warn the writer / student or reader / teacher about plagiarism or accidental copying. Word Similarity Checker uses Bing search to compare the text with online sources. It shows a percentage of text similar to text found
