There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel release, old and new. Advanced Filter One is hiding at Data | Sort & Filter | Advanced […]
A Word document and a floppy disk caught a serial killer back in 2010. There are current lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in 2004. He liked sending notes […]
The venerable SUM() function in Excel is simple, really too simple. It just adds up a range of cells with no way to filter or limit what’s included. SumIF selects what to add-up from a longer list. SumIf sometimes confuses people because they, understandably, expect the range to be SUMmed to come first followed by […]
There’s no need to switch out of Word to do simple calculations because Word for Windows has its very own built-in calculator. Calculate in Word has some nice tricks but also problems and traps. Type a calculation, hit the button (see below) and the result appears in the status bar AND it’s loaded into the […]
There are plenty of options to fit text in Excel but not all of them are obvious. Here’s your choices for wrapping text, adding line breaks and merging cells. At first, when you type text in a cell it just keeps going across the next cell, if it’s empty. Sure, you can drag the edge […]
Microsoft Word has several ways to quickly insert placeholder text into documents. Sometimes you want to add some random text to a document as filler, but don’t want to think of something to write yourself. While there are websites that will generate placeholder text for you, it is also possible to do this directly within […]
Our articles about saving past events with anniversary reminders begs the question; How far back can Outlook save an event. The answer in Outlook for Windows, Mac and online is 1 April 1601. Trying to enter a date before 1st April 1601 brings up an error: “You must specify a valid date and/or time”. That […]
Here’s a practical example of how to share an appointment or event with reminders using the iCalendar .ics standard. Some Apollo 11 events ready to download and add to your calendar (in Outlook or other software). Outlook supports .ics files and so does most other calendar programs. They are small text files which have all […]
There are many ways to share an entire calendar or individual events in Outlook software. Sharing can be ‘live’ and connected. Any changes or updates to the event or calendar are automatically sent to everyone sharing. Or it can be a ‘one-off’ item. A special attachment which is emailed or a little .ics file. Receivers […]
Back in the 16th Century, italic fonts were invented and that trick can still be used today in Microsoft Word. Italics let you fit more text into the same space. An innovative Venetian publisher, Manutius, needed to make small and affordable books. Paper was expensive so anything that put more text on the page was […]
How can you buy an older version of Microsoft Office to fit in with your other computers? Fran, a loyal Office-Watch.com reader has that problem getting Office 2013. “ I have Office 2013 on two computers now. Is there a way to get another copy for the new Microsoft Surface I just bought for less than the price […]
A US government department has accidentally revealed a secret by overlooking the obvious in Office document security. Office helps you scrub documents of private or secret information before sending. It’s easy to overlook the obvious data leaks that ‘Inspect Document’ doesn’t cover. ‘Inspect Document’ checks for hidden information in the document that you might not […]
Office Watch reader Steve G is having a problem in Word. The F9 key is starting Cortana instead of updating fields in a Word document. He suspects a buggy patch of Windows or Office. F9 is the most common problem but redirecting to different commands. That’s probably because F9 is a most common Office function […]
The inverted or Spanish question mark ¿ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¿ is most commonly used in Spanish for the start of an question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need the inverted question mark. See […]
The inverted or Spanish exclamation mark ¡ is available in Microsoft Word, regardless of language setting. There’s even an in-built shortcut. ¡ is most commonly used in Spanish for the start of an exclaiming sentence. As far back as the 1660’s there have been attempts to introduce ¡ inverted exclamation to denote irony. Despite its […]
You might think the simple ! exclamation mark is obvious in Microsoft Word or Office but there’s more possible even with this humble symbol. We’ll show you ways to insert FIVE different exclamation marks into Office, as characters, symbols and emoji with infinite variations possible on those five base symbols. We’re not including the inverted […]
Don’t bother using cut / paste to manually sorting or adjusting a list. There’s a faster shortcut for moving a line or paragraph around a Word document which isn’t in the usual lists of Word keyboard shortcuts. Word has a simple shortcut to that move the current line or paragraph up or down without selecting […]
Here’s some other problems with the Word Sort feature and tricks to work around them. Generally speaking, long or complex sorting is better done in Excel. Excel has much better data management features to split and sort. The final result can be copied into Word. Sort a list of names by surname or more in […]
Word’s Sort feature is OK, up to a point but has its limitations.We humans insist on variations of the simple ‘first and last’ name that confuse a computer. For short lists, it’s probably enough to do a Word surname sort then manually adjust the list for any anomalies. Longer lists need the power of Excel […]
Yet again, Microsoft Word is beaten by mere humans when we pit the software against words used in the 2019 Spelling Bee finals. We made a list of some words from the 2019 Spelling Bee finals including the last eight words which confirmed the winners. See for yourself how Microsoft Word did against the human […]
