Function Keys in Excel are a convenient and quicker way of doing tasks by using keyboard instead of mouse. Here’s the Excel function keys (F1 to F12) and their many tricks. F1 – Help, Ribbon, Chart, new sheet F1 – Displays the Excel Help pane Ctrl +F1 – Displays or hide the
There’s a simple trick to ensure that an email is real, not a phishing trick to get your personal information. But Microsoft makes it easy for phishing attacks to pretend that are the real thing.. Hover over a link in an Outlook email to see the real url that you’ll
There’s a faster way to clone or reuse slides from existing PowerPoint presentations. Reuse Slides lets you pick a slide and copy it in a flash. Which sounds great unless you’re an unlucky person who hits a useless and unhelpful Microsoft error message. Reuse Slides is mostly promoted as a
Word’s Readability check is a great extension to the familiar Microsoft Word Spelling & Grammar. Word can check the complexity of your writing and give you an idea of whether your text will be readable, meaning understood, by your target audience. We’ll show you how to see Word’s Readability Statistics,
Outlook provides you with many printing options to put your calendar onto real, physical paper or save to PDF. Print and customize your calendar information, be it your daily schedules, weekly schedules or monthly plans. It also allows you to print specific dates you want to. It might seem ‘old
Here’s how to quickly print a blank calendar from Outlook with no appointments, notes etc – monthly, weekly or a single day. Use a blank printout to roughly plan a week or month in a way not possible in Outlook. Or save the printout to a PDF that you can
Why does the same picture appear rotated sideways or flipped in Outlook for Windows/Mac but right side up elsewhere? It’s an image annoyance in older versions of Microsoft Outlook which we’ll explain. Outlook for Windows or Mac lets you preview a picture by clicking on the attachment icon but sometimes
Scaling Text in Word is another Microsoft Word text effect to make the text larger or smaller. Specifically, the Scale option stretches or contracts the horizontal width of the characters and spaces between. Here’s an example of normal, 150% and 66% scaling. To change the scaling of text in Word, select the text you want to
Chemistry add-in for Word or Chem4Word is a way to “to insert and modify chemical information, such as labels, formulas and 2-D depictions, from within Microsoft Office Word” and works with Word for Windows including Word 365, Word 2021, 2019 and earlier. The Chemistry add-in started as a Microsoft Research
Here’s some Outlook tricks to help planning for the Soccer World Cup or any other event. (Obviously, we’re joking about ‘normal’ people😄. Our football ⚽ loving friends are sure they are normal and pity humans with no interest in the round-ball game.) We’ve already looked at how to import a
Deep inside Microsoft Word’s (Windows/Mac) grammar checks are some detailed settings like one to look for contractions such as: I’m, you’re, shouldn’t, couldn’t and haven’t. These contractions are normal and accepted by Word 2016 Windows/Mac in it’s standard settings but you can change that. Formal Language, Consider avoiding contractions You’ll
One of the ‘emergency’ options to remember is WordPad, which can open Word documents, available in modern Windows 11, 10, 8.1 and 7. Often overlooked, WordPad can be very useful. It’s always available when Windows is running even in the Safe mode. No extra install or setup needed. It’s on
Two ways to put left and right aligned text on the same line in Microsoft Word. There’s the commonly used option and the less well-known choice. BONUS: putting left, center and right aligned text on one line. We’ll show how to make Left and Right aligned text looking like this.
Type the Facsimile sign or Fax symbol ℻ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. FAX ℻ symbol is a single character with the letters FAX, normally used to prefix a telephone number in a letter heading or footer. For younger readers:
Type the Hundred points 💯 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. 100 points 💯 symbol is also known as ’100’, ‘Keep it 100’ or ‘Keeping it real’. How 100 points 💯 looks in different fonts. Here’s some examples of how
Type the Face with Tears of joy 😂 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Face with Tears of joy 😂 emoji is one of the most popular, if not THE most commonly used emoji. Also known as Laughing Crying, Laughing Tears,
Microsoft Create is a new part of Microsoft 365 that will replace the existing Office templates site and more. Office Watch explains how to use the Create site now, the many categories available and what’s to come. Cut through all the usual Microsoft Hype™ like “ultimate creator launchpad” and the
Kerning is a font setting that’s important in Word and PowerPoint. We’ll explain kerning and why you mostly don’t have to worry about it except for large size text like titles and headings. Kerning adjusts the horizontal space between letters so they look right to the human eye. It’s necessary
Insert the TEL – Telephone symbol ℡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. TEL – Telephone ℡ symbol is a single character with the letters TEL, normally used to prefix a telephone number in a letter heading or footer. How
Type the Tilde ~ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Plus an emoji alternative to Tilde. Tilde is used to mean ‘approximate’ as in “ ~30 minutes late”. In maths it means ‘similar order of magnitude’ e.g. “ a ~
Changing the order of styles in Microsoft Word’s Style Gallery is possible but buried way down inside the message boxes. A standard Word Style Gallery looks like this. Right-clicking on a style gives some options, including Remove from Style Gallery. Moving the styles into another order is more complicated. You’d
Word can check if you use a single or double space after a sentence (fullstop/period) but how can it be changed single space to double throughout a document? The Sentence Spacing settings (single, double or don’t care) is in Word’s Grammar settings see Sentence Spacing in Word. These days, sentences
There are many ways to save an Outlook email or other items to a separate file. Which one you choose depends on your needs. One Outlook message or many? Compatible for many people or not? Easy to search or not? Some options work for a single message only. Others can
Ronny, a loyal Office Watch reader asks “OK, I now understand that entering dates in Excel as plain text isn’t a good idea. How do I convert my cells with MM/DD text into proper Excel dates?” It’s a trap for Excel novices. Typing in a date as plain text seems
