The wildcard is an advanced finding feature that has some powerful options beyond the standard * and ? options for Word. What Word calls ‘wildcard’ is really Regular Expressions, or at least a version of RegEx. Beginning or end of a word The beginning of a word can be represented
Using Strikethrough in Word seems straight forward but, like many things in Office, there’s extra tricks hiding away for double, long and short strikethrough. Why use Strikethough? Strikethrough has various uses. Perhaps most commonly to show a discounted price Was $100 now $99.99! Or to show that a change was made from the original: Turn left right at the corner.
TrimMean() function is a slightly different and useful measure than the regular Excel Average(). It’s still an average/mean but without the high and low, extreme or outlier values in the list. Average() (and its partners AverageA() and AverageIFS() use all the values in the array or list provided. TrimMean() excludes
How does Microsoft Word’s spell check go with the 2021 Words of the Champions list from the US annual spelling bee? Each year the Scripps National Spelling Bee releases a Words of the Champions study list to educators, featuring up to 800 new words. We grabbed a selection of the
Type the Weary / Distraught face 😩 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Weary / Distraught face 😩 emoji is also called Wailing, Frustrated or Sadness. How Weary / Distraught face 😩 looks in different fonts. Here’s some examples of
Microsoft Word seems to have two pairs of shortcuts that do the same thing – increase or decrease the font size. This is how they are different. The shortcuts are: Ctrl + Shift + < or Ctrl + Shift + > – which are also buttons on the Home tab.
The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch
Office 2007 and later to Office 365 not only has keyboard shortcuts but in many ways they are better than previous versions of Microsoft Office. For the most part the shortcuts used in Office XP and Office 2003 still work in Office 2007 through 365 also – despite the very
We place all of the “Shortcut of the Week” tips from 2004 in the one convenient place. Tip 1 – Undo The Undo function has become especially important over the years as Microsoft puts more ‘intelligence’ into their products. Sometimes it ‘corrects’ your spelling or re-formats something you were quite
Another round of bug fixes for both Window and Office including an update to the PrintNightmare fix. PrintNightmare is a serious security breach found in all versions of Windows and Windows Server back to Windows 7. The original ‘out of band’ patch was flawed, stopping some USB printers completely. A
The latest and serious Windows security bug is called ‘PrintNightmare’. We’ll explain what it is, how serious the bug could be, what you should do about it balancing the ‘known unknowns’. UPDATE: Almost as predictable as the sun rising … the PrintNightmare patch caused problems for some Windows users. The
Our annual Microsoft Word vs the Spelling Bee Champions contest has returned for 2021. Word has done better than in the past but was still beaten by an extraordinary 14 year-old. Here’s the list of words used in the final rounds, (rounds 10-18) of the Scripps Spelling Bee as they
Type the Fire 🔥 symbol or emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Fire 🔥 emoji has many names like Hot, Lit, Flame and Snapstreak How Fire 🔥 looks in different fonts. Here’s some examples of how Fire 🔥 looks
Excel isn’t just for budgets and number crunching, you can use it for making lists and even organizing your love life! Lisa used Excel to find her True Love. She listed all her dates in Excel with details somewhat like this… Excel, combined with some personal rules. eventually led her
Criminals try using Microsoft Office to get money from you using various phone scams impersonating Microsoft. Here’s how to protect yourself. Scammers are clever, sophisticated and look very sincere. Often there are stark warnings about dire consequences. In the end they want your money, infect your computer, steal your personal
New email notifications in Outlook can be quite distracting, especially in Windows. Here’s how to stop them or change the notices to make them less distracting and suit you better. Or just change the new email sound to something you prefer. The default email notification appears in the bottom right
Tim Harford has an interesting long read on spreadsheets from its origins in the late 14th Century Italy to modern Excel with diversions into smallpox, Enron, Covid and even teasing Bill Gates. The Tyranny of Spreadsheets is on the Financial Times web site. It’s usually firewalled but the link should,
How to embed the necessary fonts into a Word document so everything is included that the receiver needs to view and edit it. You’ve made a document, it looks great and you send it off to someone or a print shop. They call complaining that it looks weird and claiming
It is possible to add videos to a PowerPoint Kiosk or self-running presentation. Recently we’ve talked about Self-running of kiosk display in PowerPoint as well as the related PowerPoint Photo Album feature. But what about video’s? You can add videos to a PowerPoint presentation, you’ve been able to do that
PowerPoint can show slides on a screen as a high-tech signboard, using a self-running presentation known as Kiosk display. Here’s how to do it plus all the settings and tricks available. We’ve all seen screens displaying information on a series of slides – maybe in a shop or conference. Maybe
How to type Ghana Cedi currency character in Windows or Office, especially Word. After our article about inserting Numero and other symbols into Office – trust an Office Watch reader to find a character not available in a supplied Windows / Office font: ” The currency in Ghana is the
Microsoft Word has footnotes and endnotes features but it’s surprisingly clumsy when it come to the common need for footnotes immediately after a table. Normally, Word puts Footnotes at the bottom of the page but for tables (and occasionally pictures or diagrams) you want them immediately after the table like
How to type the ‘Numero’ symbol and other special characters – there’s many ways to do it in Word and Office. It all started with a single, seemingly simple, question from a reader. As often happens, the question opens up a whole range of options in Office Entering the Numero sign
How to sort a list using a hidden or unseen column in a Microsoft Word table. Sometimes you want to sort a list in a way that isn’t apparent to the reader. To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with
