What is the Questioned Equal To ≟ symbol and how to type in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. ≟ is a question mark above an equals sign. It isn’t properly used in equations but can be useful to show an
Function keys can be a hassle, specially on smaller laptop keyboards without a dedicated F key row. Happily there are two alternatives for Microsoft Office user plus another for both Windows or Mac generally. Many laptop users avoid the Function keys because they aren’t directly available on the keyboard. Instead
Many inbuilt Word styles are hidden until they are used but there’s a way to force hidden styles to appear right away. The most obvious example of ‘Hide until used’ styles are the Heading styles. Word initially shows only the first three headings ‘Heading 1’, ‘Heading 2’ and (drumroll) ‘Heading
There are two ways to hide Excel cell contents that you don’t want visible, but still available able to use in calculations. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are separate options for hiding row,
If you want to find then change or remove hidden text from your Word document, there are two ways to do it. Either reveal or find the hidden text OR use Word’s in-built Document Inspector. For a shorter document, you can use the Show/Hide button to see what’s hidden and
Make an image using the original Microsoft Office WordArt designs, courtesy of some clever web work by Mike McMillan. Or use the better WordArt that’s still available in modern Microsoft Word. Does anyone miss the original WordArt from the 1990’s? Now you can get it back https://makewordart.com/ recreates, with scary
Microsoft Word has some simple but frankly inadequate options to make a sign or page with a thick black border. Office Watch shows you the best, most flexible option which is better than the official, direct features. Following the death of Her Majesty Queen Elizabeth II, I was asked to
There are two ways to drop a PowerPoint slide into a Word document. A simple, one-time method or a slightly advanced but dynamic trick which lets the Word document slide change if the original slide is updated. A few months ago we showed how to add Excel worksheets into a
‘Plus’ email addressing (aka sub-address or disposable email) is a really useful option for managing your incoming messages, if your mail host allow them. The + trick lets you change the email address given out while still letting the messages to a single mailbox. A ‘plus’ email address looks like
Here’s how to discover what type of connection Outlook for Windows is making to each mailbox. That’s occasionally important information but it’s hidden in an unexpected place. Connection Status has vital details to know if support asks what type of mailbox connection Outlook is using. At the moment, Microsoft is
How to open the Outlook Connection Status box to see what type of connection Outlook for Windows is making to each mailbox. It’s hiding on an Outlook menu most people don’t even know about. Microsoft’s instructions aren’t complete, try this: Outlook for Windows must be running Open the notification pane
How to find words with or without accented characters in Microsoft Word. You might need to find both naïve and naïve or café and cafe. There are many options in Word Find or Advanced Find but not the choice to ‘ignore accented characters’ or ‘treat accented characters as if not
Type the Division ÷ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Division ÷ symbol is an alternative to the / character. Made up of a dash and two dots. ÷ symbol isn’t recommended these days. It’s not universally known and
How to typing words with a diaeresis or umlaut in Word for Windows, Mac, Apple or Android plus the shortcuts on Mac computers. They aren’t normally needed in English except some organizations that require diaeresis for words like: naïve coöperate reëlect Brontë Noël Noël Coward Or you might be typing
Many OneNote users would like to save their notebooks on their computer and not OneDrive. Saving a notebook to a local folder is possible. It might become impossible in the years ahead. Only OneNote 2016 for Windows supports saving a notebook to any folder. OneDrive is the only notebook option
How to get rid of an email conversation or thread in Outlook – it’s called Ignore or Mute. Sometimes you get emails on a topic that doesn’t matter to you and is cluttering up your Inbox. Outlook for Windows has a fairly simple solution – the Ignore button. Ignore tells Outlook
Some good advice for better spreadsheets from the distinguished science journal, Nature, (established 1869!) who have tips about the right way and wrong way to use Excel or Google Sheets. The article Six tips for better spreadsheets opens with a horror story about a list of latitude/longitude “It was a
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of
Deep in Microsoft Word is the choice “Automatically Update Document Styles“. What does that do and which documents are affected? There are several similarly worded options to do with ‘Style’ and ‘Automatic’ so let’s be clear … we’re talking about File | Options | Add-ins | Manage | Templates |
Excel shows midday or noon as 12:00 PM which doesn’t suit everyone, here’s how to change the defaults to a word such as ‘Midnight’ or any other time label you’d like. ABC News in Australia delves into the argument about showing 12 PM – There is no such time as
In many situations, there’s common text or even whole messages that you want to reuse in emails. Here’s an option to save and add that text with a single click. It’s a lot faster, more consistent and already in Microsoft Outlook. Outlook has a feature that’s good for recycling text
The Apple command ⌘ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Apple command ⌘ symbol appears on Mac and iPad keyboards but only as a command option, not as a symbol to type. The ⌘ symbol predates
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite
There are some great and editable Periodic Table of Elements options available in Microsoft Office – Word documents, Excel spreadsheets and PowerPoint slides There are many Periodic Table ‘documents’ on the net but most are PDF’s or images that can’t be changed. We’re looking for editable Word documents and Excel
