Excel Function Keys explained
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 ribbon of Excel. By hiding […]
Complete Christmas emoji, fast find and copy
Need a Christmas emoji or symbol? Here’s a quick and searchable list of all the Xmas emoji for documents, sheets, slides, emails or messages that you can use or copy. This list has all the Christmas related emoji we can think of, the broadest sense both secular and religious. These emoji are supported (with different […]
Getting Microsoft Forms results into Excel
Microsoft Forms can export survey/quiz results to an Excel workbook, here’s how to do that easy and efficiently and the limitations that Microsoft hasn’t fixed for most customers. The current method of getting Microsoft Forms results into Excel isn’t very elegant. It doesn’t make use of Excel’s excellent data import and update features. Microsoft has […]
Two ways to get one line of Word with left and right aligned text
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. You’ll often see it in […]
100 points 💯 emoji in Word, PowerPoint and Office
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 100 points 💯 looks in […]
Face with Tears of joy 😂 emoji in Word, Office
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, LOL (Laugh Out Loud) or […]
Make your own blue checkmark Twitter ‘verified’ in Office
You can add a Twitter blue or gray checkmark to your Microsoft Office documents including Word docs, PowerPoint slides. We’ll show you how to add the ‘verified’ graphic at any size you need with the exact blue, gray or some other color. Oh, and save yourself $8 a month <kidding>. We’ve all seen the Twitter […]
Inside Microsoft Create, the new Office templates site and more
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 dreadful phrase “uplevel your creative […]
Tilde ~ symbol in Word, Excel, PowerPoint and Outlook
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 ~ b “. Tilde ~ symbol […]
Converting Text with month and year into Excel dates
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 simple and easy … until […]
Easy Visa calculator for European visitors – with Excel
Here’s a handy Excel worksheet for visitors to Europe, including UK citizens. It’ll help you stay within the legal limits for ‘short stays’ by visitors to the EU Schengen zone. Most visitors to Europe are allowed to stay in the Schengen group of countries for 90 days out of the previous 180 days. It’s a […]
Three ways to stop people changing your Word document
Word, Excel and PowerPoint have options to stop people from changing a document, making them ‘read only’ in tech speak. These options protect your documents from unauthorized editing or even reading them at all. There are different levels of protection, they are all under File | Info | Protect Document. While they are mostly talked […]
Insert a signature picture into a Word document
There are some nifty tricks to inserting a picture of your signature into a Word or other document. Tips that make the result look realistic and professional. We’ve already explained the many ways to get a picture of your ink signature into Office. Now you have a picture of your signature, it’s ready to be […]
All the ways to sign a digital document in Word and more
Adding your signature or signing a document digitally is possible in different ways using Microsoft Word or other Office programs. Before we start, let’s clarify some terminology because ‘signing a document’ can mean several things in the computer world: Adding a signature to a document. Inserting a copy of a human written signature into an […]
Stock images or premium content in Microsoft 365
Word, Excel, Outlook and PowerPoint in Microsoft 365 have image and icon libraries plus stock images or ‘premium creative content’. Despite the ‘Stock Images’ name there are four types of extra content; Images, Cutout People, Icons and Stickers. We’re told there are ‘over 8,000’ images and icons with ‘more to come’. Insert Pictures The Insert […]
Plus or Minus sign ± in Word, Excel, PowerPoint and Outlook
Type the ‘Plus or Minus sign’ ± into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Plus-Minus ± symbol isn’t just used for equations, it’s also used as a shortcut for ‘plus or minus’. In statistics you’ll often see results given as being “ ± 3% ”. How […]
