Extend UNIQUE() for distinct values that appear more than once
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in Read More
Office Watch
Word's =Rand() around the World
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s Read More
How we made the 'Adjust your monitor' sign
Re-creating the “Don’t be a Spock” sign in Word wasn’t hard especially since the original sign seen at the laboratory Read More
Don't be a Spock - Adjust your monitor height
A great sign about positioning your monitor – now available for download. You have to hand it to the boffins Read More
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
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
