Microsoft 365 – the subscription / annual fee plan for Microsoft Office on Windows, Mac, iPhone, iPad and Android.
Includes Word 365, Excel 365, PowerPoint 365, Outlook 365 and many other ‘365’ programs, apps and services.
Better ways to add date lists in Excel
Excel has ways to add a list of dates by day, weekday, month or year either by the fill handle or the Series command. Date Series with Fill Handle You probably know about the Fill handle tool to fill the remaining cells. Once highlighted, just hover your mouse in the bottom right corner and a […]
Fancy gridlines to make Excel look great or at least different.
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Here’s what it looks like with the pink, black and red in comparison to the default […]
Easy Table of Figures in Word
Microsoft Word can generate a list of all the images, graphs, tables or equations in a document – called a Table of Figures. Just like a table of contents, this list can include page references or links to each figure or picture. A Table of Figures can be useful for creating a proper appendix of […]
How to update your Microsoft 365 licence before going offline
Microsoft 365 does an online licence check at least every 30 days. If your device will be offline for weeks, how can you make sure you have a full 30 days licence before disconnecting from the Internet? Here’s how to update your Microsoft 365 licence before going offline. Office 365 / Microsoft 365 software and […]
Automatic Capitalization fixes in Word
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the AutoCorrect dialog at File | […]
Where are Word styles saved – document or template
Styles can be saved in a Word document but are most effective when saved in a template. Changing the style in a template will affect any document that uses the same template. At the bottom of the Modify Style dialog are two choices for where to save the style. Microsoft has reworded the choices to […]
Law & Order title card in PowerPoint and Word
Here’s how to make a lookalike for the Law & Order TV show title card in either PowerPoint or Word. Last week we showed how to make the Law & Order opening screen image and how to use that look in slides or documents. Many readers asked why Office-Watch.com didn’t do the main title card. […]
Law & Order titles and sound in PowerPoint and Office
One way to open a PowerPoint presentation could be to copy the opening of the Law & Order TV shows. Here’s how to get the same look in your PPT slides or Word documents plus the distinctive sound. The same formatting can be used in Word, maybe as a callout to highlight some text. But […]
Teams can be a source of malware
Microsoft Teams is becoming another way for criminals to infiltrate an organization or spread malware. According to Help Net Security viruses are being distributed via Teams Chats. A program with an innocent name like UserCentric.exe allows hackers to remotely control computers, install DLL’s and get more information about the user and organization. Infected Office documents […]
Can’t edit a document in Teams? Try these workarounds
Sometimes a document can’t be edited in Teams for no good reason. Here’s some things to try and workaround the problem. Teams uses SharePoint to manage documents and sometimes the technology doesn’t behave the way it should. A document that you should have full access to, can only be viewed. Before becoming overly frustrated with […]
Free and secure conversion of .doc .xls or .ppt to the newer Office formats
Here’s how to convert an older .doc .xls or .ppt into a safer and smaller .docx .xlsx .pptx even if you don’t have Microsoft Office. Any smart computer user is wary of documents received in the old .doc .xls .ppt formats because they are regularly used to transmit viruses. The new document formats are much […]
Beat the Microsoft price increases
There are just a few days left for Business customers to lock in lower prices for Microsoft 365, before Business plans get more expensive on 14 March 2022. No customer likes a price increase but Microsoft’s targeted rises in Microsoft 365 Business plans have been unpopular with both customers and the vital partner or sales […]
Life Saving use for a collaborative spreadsheet
Spreadsheets aren’t just for numbers and money, they can also be used to save lives when saved online and collaborating with other people. Lismore is northern NSW, Australia has been struck with massive floods leaving many people stranded in their homes, some trapped against rising waters. The emergency services were overwhelmed so it was left […]
Flash Fill Magic in Excel
Flash Fill is a simple way to split and join text automatically in Excel for Windows or Mac. Flash Fill was added in Excel 2013 for Windows. It’s both useful and looks good in the demonstrations. In Excel there’s often need to join, separate or reformat strings of text. Flash Fill copies your actions at […]
Adding Footnotes to Pictures in Word
How to add footnotes just below a photo in Microsoft Word The trick is similar to adding Footnotes to a Word table. Use Endnotes, instead of Footnotes (assuming you don’t use Endnotes elsewhere in the document). Add a Continuous Section Break and change the Endnotes settings to put them at the end of the section. […]
Faster Numbered and Multi-Level Level changes
Moving the selected lines/s to a different numbering level in Microsoft Word is officially done from the Numbering Gallery | Change list level but there’s are quicker keyboard shortcuts. The faster way to do this is shortcuts: Alt + Shift + RIGHT arrow Down / right one level Alt + Shift + LEFT arrow Up […]
