AutoCorrect is great for larger blocks of text & acronyms in Word
How to use AutoCorrect for more than a word or single character. It can speed up typing of large blocks Read More
Office Watch
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 Read More
Easily compare a series of values with ChiTest() Excel
How to compare one set of numbers with another list of values using ChiTest() in Excel. ChiTest() or ChiSq.Test() sounds Read More
What can you put in your email address?
A simple question – what characters can you put in an email address? Like many things to do with the Read More
The trick to Find or Replace web links in Word
Find or change many web links in Word documents using the Replace command, here’s the trick. For example, you might Read More
8 tips for great Excel Sparklines
Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis Read More
Excel - a history of rows and columns
How many rows and columns does Excel have? All the talk about 64-bit versions of Office has raised the issue Read More
Sparklines make simple graphs for Excel
A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Read More
Two choices to make a PDF - Save or Print?
How you choose to make a PDF file from Microsoft Office can make quite a difference to how the PDF Read More
WTF? Word's Alphabetical order is different from a dictionary!
Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what Read More
Two Factor Authentication: Straight Talk
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter Read More
Full CONVERT() measurement list for Excel
A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table Read More
Hide any footnotes and endnotes in a Word doc
Hiding Footnotes or Endnotes in a Word document is possible but needs a little trickery. Maybe you want a ‘clean’ Read More
Word Footnote hidden bug
Hiding footnotes in Word triggers an annoying bug that’s been there for at least ten years. There’s no sign of Read More
Outlook's 'Permanent' delete but doesn't - how we tested it.
When Outlook displays a ‘This will be permanently deleted’ it’s not really deleted. For anyone interested in the gory details Read More
Avoiding Comic Sans with these alternatives
Free alternatives to the overused Comic Sans font. The Wall Street Journal has a history of Comic Sans, the font Read More
Changing Word zoom to custom fixed settings
How to change Word zoom to your preferred Zoom settings. Ray R writes … “I have been having some vision Read More
Making QR Codes for Word and Office
QR Codes are those funny little boxes you see on ads and signs … Scan that code with your smartphone Read More
Paste tricks and tips for Microsoft Word
There’s more to Paste in Word than just the keyboard shortcut. Demystifying the many paste options in Word and workarounds Read More
Beating Bots, Spies & Cock-ups - easy and secure sending of files
We’re delighted to announce a timely update to Beating Bots, Spies & Cock-ups All about safely and securely sending files Read More
