Here’s how to find out what type of Microsoft Office 365 licence you have with details hidden from the usual About dialog box. We recently showed it’s important for for perpetual non-subscription versions of Office like Office 2021 or Office 2019 to know if the purchase is Retail/Volume or OEM.
There are many different ways to insert a page break into a Microsoft Word document, some are visible and others invisible even with Show All turned on. Luckily, Word has a straightforward way of doing this with a manual or separate Page Break. It’s also possible to associate a page break with the paragraph, which is a lot easier manage page breaks but they are somewhat invisible and it’s not
Every Microsoft Word Style has an option to ‘Automatically Update‘ which sounds great, but can lead to more confusion. Here’s what ‘Automatically Update’ really means, why it’s wise to turn it off and the better alternative. There are many ‘Automatic’ options in Word that are spread all over the place.
A quick and reliable way to update a style within a Microsoft Word document. It works only when you ask it and you can apply a series of changes before updating the style. Update Style to Match Selection We’ve made a series of changes to a paragraph; font size, color
For all the changes Microsoft has made to Search (aka Tell Me), they continue to ignore one basic that would make Word, Excel, PowerPoint and Outlook a lot easier to work with. Here’s some examples of how Microsoft Office search badly needs fixing. Search (formerly called “Tell Me”) usually appears
The Sharing options in Office are changing, yet again with a new ‘sharing experience’ in all Microsoft Office 365 apps for desktop, web and mobile. We’ll explain the changes, including a few options that Microsoft hasn’t mentioned. All the usual Microsoft buzzwords have been recycled to describe these changes; “streamlined”,
Microsoft is making Clipchamp available to their Microsoft 365 commercial customers after limiting access to consumer users for too long. As usual, Microsoft’s announcement has many ‘fine print’ details to annoy paying customers. Clipchamp is Microsoft’s online video editing service. It’s been available to Microsoft 365 Personal and Family customers
Clipchamp, is Microsoft’s video editing software and service. It’s a simple way to create videos easily with text, graphics, effects and transitions. Microsoft 365 consumer customers get extra Clipchamp features. You can try it out here, or download it from the Microsoft Store for Windows. Mac users can get Clipchamp
Here’s how to make a list of all the available fonts on a computer by making a table in Word complete with sample text using each font. It makes a Word table of all the fonts, including sample text like this. VBA features on show The code is fairly straight-forward
Three ways to insert the Recycle symbol ♻ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. There are many different and specialist Recycle symbols. We’ll focus on the standard, generic symbol, officially called “Black Universal Recycling Symbol” in three forms: Emoji or Unicode
Insert the Teardrop-Spoked Asterisk ✻ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Heavy Teardrop-Spoked Asterisk ✻ symbol has a circle in the middle with six ‘teardrop’ spokes around it. It has no specific purpose but is a more decorative alternative to the standard
There’s a nice little Excel function that will calculate the rate of return on any asset like a stock or fund including income/dividends with purchases and sales over time. The secret sauce is XIRR() a function which calculates an internal rate of return with uneven interest or dividend payments. In
Office Lens is a good app for iPhone, iPad and Android devices. If you want to convert photos into a Word document (as text) or PDF, the Office Lens is the way to go. Lens has a wonderful straightening trick that turns an off-center photo into something ‘straight on’ which
An easy and fast way to add pictures into Word, Excel, PowerPoint or Outlook. We mentioned a faster way to get a scanned image into Word via the ‘scan to clipboard’ option available in some scanning software. There are similar options available for copying existing image files into Word, Excel
The latest enhancement in Word for the web brings a better graphic navigation experience. Now, with keyboard shortcuts alone, you can select and move between graphics like never before. In short, Ctrl + Alt + G or Cmd + Alt/Option + G will select the first graphic in the document
There’s a bug in the latest release of Outlook 365 for Windows (Microsoft 365) which makes saving attachments slow to a crawl. Microsoft has a workaround to consider, if you’re desperate. The problem occurs when saving attachments to a network folder directly. There’s a long wait looking at this dialog
Windows Mail and Calendar apps will be replaced with the ‘new’ Outlook. That means a second ‘Outlook for Windows’ and plenty of confusion for customers and support people. Microsoft made this mistake before and seem determined to do it again. This ‘new’ Outlook is a Progressive Web App (PWA) formerly
Microsoft has surprised by putting a high extra price on their upcoming AI features in Microsoft 365. To get these innovations, add another $30 a month to the cost, which in many cases doubles the price of Microsoft 365. Copilot is Microsoft’s name for their AI features that can write,
The change of fonts in Microsoft 365 also means the default styles are also changing in Excel 365. Here’s what the new styles look like and the exact settings Microsoft has chosen in Excel 365 for Windows and Mac. The new Excel defaults for a worksheet mostly use Aptos Narrow
The change of fonts in Microsoft 365 also means a change of default styles (normal and headings) are also changing. Here’s what the new styles look like and the exact settings Microsoft has chosen for Word, PowerPoint and Outlook. At the moment, these fonts and styles are in Microsoft 365
Microsoft Excel has a handy function called NPER that can help you work out how long it’ll take to pay off a loan. It’ll show how adding even a little bit per payment can help clear a loan faster and some practical advice on using NPER in the real world.
How to change the ‘Blank Document’ defaults like font etc. in Microsoft Word. Either ‘Set Default’ choices or update Word’s core template. What to do when the usual tips don’t work. In other words, all about Normal.dotm in Microsoft Word. Microsoft 365 customers are getting new default fonts called Aptos,
There’s been yet another failure of Microsoft’s Exchange Online service (aka Microsoft 365 hosted email) affecting customers around the world by stopping or delaying outgoing messages. Microsoft hid the extent of the problem by spreading the details across two separate bug reports. The first most people knew of the problem
There’s another way to make a list of all the fonts in a Word document. This method is probably faster than using VBA to search for fonts through large documents. This is an alternative to the VBA code in How to list all fonts in a Word document Word documents
