Microsoft Word lacks native support for adding prefix and suffix text through styles—but clever workarounds can make it possible. This guide from Office Watch shows how to simulate prefixing and suffixing paragraphs or character styles, just like CSS’s :before and :after elements. Learn how to format consistent labels, product codes,
Microsoft Word’s grammar checker might help with commas and verb tenses, but it misses one subtle yet frequent English mistake, putting numbers, amounts, times, or dates in the wrong order. After our article on adjective order in English , Aussie Office Watch reader “MJ” pointed out something that Word doesn’t
Did you know Windows quietly swaps out Helvetica font for Arial every time you open certain documents? This subtle substitution affects how text looks in Word, browsers, and more. Learn why Helvetica isn’t included in Windows, how Microsoft handles font replacements behind the scenes, and what you can do to
Microsoft’s default font family, Aptos, isn’t limited to Microsoft 365 or Office 2024. Anyone can download and install the complete Aptos font set directly from Microsoft to use across any app or platform. Whether you’re running Office 2021, older Office versions, or non-Microsoft software like LibreOffice, this quick download ensures
Need an attention-grabbing border for safety notices or urgent messages? Creating a striped border in Microsoft Word isn’t as simple as it seems—but with the right technique, you can design professional-looking emergency or warning signs in minutes. This step-by-step guide from Office Watch shows how to use Word’s background picture
Want to make your Microsoft Word pages or signs stand out? Skip the frustrating page background tool and try this smarter way to add diagonally striped borders. Get full control over stripe position, color, and layout — perfect for eye-catching warning signs, notices, or creative designs that look sharp on
Microsoft Office and Microsoft 365 have several save features, AutoSave, AutoRecover, background saves, and backup copies. Our guide explains the differences, limitations, and best practices so you can avoid losing important work in Word, Excel, PowerPoint, and other Office apps. Maybe you’ve seen these two options in Word Options |
Make sure your Microsoft Word documents look the same everywhere by embedding fonts, just in case the right fonts aren’t installed on recipients’ systems. How to embed fonts in Word on both Windows and Mac plus the options and alternatives for font embedding. Allow anyone opening the document to see
Take control of automatic formatting in Microsoft Word, the AutoFormat and AutoCorrect features. Whether you’re frustrated by Word turning your asterisks into bullet points or want to customize how your documents handle quotes, lists, and spelling corrections, this guide explores every option available. Discover how to manage, disable, and fine-tune
Hiding and protecting an Excel worksheet is NOT the same as full encryption. Protected workbooks can be encrypted and not available without the right password. Worksheets protected or hidden with a password are absurdly easy to view whether you have the password or not. Excel has long had the ability
Calculating the ‘Standard Error of the mean’ or SEM is simple using Excel’s in-built functions. Understanding ‘Standard Error of the mean’ isn’t hard either. We’ll explain the formula and what it all means. To calculate standard error of the mean get the Standard Deviation of a sample (STDEV.S() or STDEV())
Understanding Standard Deviation isn’t hard, especially with Excel’s help. This quick guide shows the difference between sample and population functions so you can choose the right one and get accurate, informative results every time. Standard Deviation in Excel The standard deviation measures the variation from the average or mean of a
How did we make a Word table with a picture background for a recent article – asks an Office Watch friend? She meant this table of Zoom shortcuts for toggling audio and video . There’s a similar table for Teams shortcuts. The quick answer is … we cheated! Word can’t
Create awesome retro, classic or original WordArt in Microsoft Word 365, Word 2024 and earlier version. It’s simple, just follow these steps. At the time, WordArt was a big step for Microsoft Word. It was a quick way to add fancy text, not possible before. Alas, like many Office design
Transform how you format Word documents with keyboard shortcuts—going beyond the built‑in ones for Headings 1–3 by adding your own for Heading 4, 5, 6 (and beyond) that Microsoft has forgotten. With these simple tweaks, your document structuring becomes faster and more consistent. Word’s in-built Heading styles come with some shortcut keys, but
When will your version of Microsoft Office stop getting security bug and software bug fixes, what Microsoft calls the “end of support“. This is important because software updates are necessary for Office apps. Mainly because outdated versions are more vulnerable to hackers, particularly in the case of opening malicious emails,
Add the US National flag “Old Glory” “The red, white and blue” into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help can be used for any other national flag, just look for a different source or our articles about
Still using .doc, .xls, or .ppt files? These outdated Microsoft Office formats are not just relics—they’re major security risks and should be banned. Hackers exploit these older files to spread malware, ransomware, and steal data, as they often bypass modern antivirus protections. After our suggestion to ignore old style Office
RTF files may seem safe, but they can carry hidden risks. Hackers use RTFs to exploit Microsoft Word and even infect systems through email previews. Learn why RTF isn’t as harmless as it looks—and how to stay protected. The confusion is understandable. After all .RTF (Rich Text Format) files aren’t
Struggling with a sea of worksheet tabs at the bottom of your Excel window? Whether you’re managing dozens of tabs or juggling shared workbooks with tight screen space, discover how to fit more visible tabs across your Excel workbook can transform your workflow. In this guide, we walk through both
In Excel there are various options for making sure a text label singular (e.g. person) or plural (people) matches the quantity. There’s the standard answer (IF() functions) or clever cell formatting tricks. For example if the cell has 1 item you want the singular label: 1 cookie But if the
You might think that the hyphen is a simple small horizontal line … but no. There are NINE different hyphen or short horizontal line choices in Microsoft Word. The common ones (hypen, En-dash and Em-dash) have shortcuts in Word, Windows and Mac. Let’s start with the standard hyphen, actually called
There’s a little trap in Excel when figuring out the number of days between two dates. Excel has one way, but the real world has two others. It’s easy to forget the differences and it can matter when the date calculation is close to some limit, for example in a
Google offers a great variety of free open-source fonts that can be used in Microsoft Office, Windows or Mac. You just need to know the right trick to access them for Word, Excel or PowerPoint. Over 1,800 Google Font families There are 877 1,816 Google Font families currently available at
