All about Microsoft Office Word, Excel, PowerPoint and Outlook, Microsoft 365, Office 2021 and earlier versions.
Telephone location ✆ emoji in Word, Excel, PowerPoint and Outlook
Insert the Telephone location ✆ symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Telephone location ✆ symbol is supposed to be used as a sign for a phone box or booth but can be used for any ‘phone’ purpose. See also: Telephone Receiver 📞 Emoji In Word, Excel, […]
Office Watch annual fundraising drive with Thank You gift
If you enjoy the stuff we do here at Office Watch we’d really appreciate you chucking a few dollars at our annual fundraising drive – and we have a new 2023 ebook for all contributors as a special gift. Donate via Paypal or credit card. The financial support of readers is the only thing keeping […]
Making a Word linked style for lead in paragraphs
Here’s how to make a linked style with an outline level in Microsoft Word. Use this for many reasons like Table of Contents styles in Word. The ‘outline level‘ is how Word knows what to put in the Table of Contents, Outline View and, mostly, Navigation Pane. Any Paragraph, Linked or Table style can have an […]
Table of Contents basics in Word
Let’s explore the basic options for making a Table of Contents (TOC) in a Word document. Table of Contents is very easy to do in Word and it’s not just for people who are making books. TOC’s can be useful in any long document such as a contract. Beyond the simple Table of Contents there […]
All Word’s Table of Contents options
Microsoft Word has many Table of Contents options, a lot of them hidden away. Here’s a complete list of all the switches available with a Word {TOC … } field code. We’ve covered the basics of Table of Contents and some Table of Contents tricks already, here we’ll go in-depth with the TOC field codes […]
Export / Import your Outlook Signatures
Where are Outlook email signatures stored and how to copy them to another computer. There’s no import/export option for Outlook email signatures so how can you move them to another computer? This page applies only to signatures saved to the local computer, not signatures for Microsoft hosted mailboxes see Roaming email signatures in Outlook 365, […]
Signatures for all occasions in Outlook
How to have email signatures in Outlook for all the different roles in your life. Most of us wear different ‘hats’ – a family member, friend, person, employee or volunteer. Each of those ‘hats’ can have a different Outlook email signature. Which Outlook signature you use depends on the situation and, perhaps, the email account […]
Essential keyboard shortcuts for the Office Selection Pane
Use these essential keyboard shortcuts to make best use of the Selection pane in Microsoft Office. Alt + F10 Open Selection Pane F6 Move the keyboard focus through the major regions until reaches the Selection Pane Tab Navigate by keyboard through the buttons in the pane and then into the list Up arrow, down arrow […]
See more with Selection Pane in Excel, PowerPoint and Word
Selection Pane is essential in Word, Powerpoint and Excel to hide or display the objects or to change the order, rename objects, group / ungroup, and delete objects. If you’re using images, graphics, Text Boxes, charts, SmartArt or other objects, the Selection Pane is a must. So, let’s start with some basic details of how […]
How to use Excel’s Business Assist – Forecast
Business Assist – Forecast is a new Excel add-in from Microsoft which forecasts future volumes based on past data. How to use the add-in, if you can and understand its limitations. From the promotion, Business Assist – Forecast sounds like a useful tool but it’s a different story when we tried the add-in for ourselves. […]
2001 movie design: using in Office, Word or PowerPoint
Make your own Word or PowerPoint designs inspired by the movie ‘2001: A Space Odyssey‘. See 2001 A Space Odyssey – in Word and PowerPoint and 2001: A Space Odyssey and font kerning for details on the fonts, colors and styles used in Kubrick’s famous movie. PowerPoint slides Moving from film stills to PowerPoint slides […]
Designer home page changes are a welcome improvement
The Microsoft Designer home page has a major update that highlights some of its hidden features. These changes aren’t just cosmetic, but are a welcome boost to the functionality and usability of the opening page. The new Designer home page is in two parts: Get Started and My Projects. Get Started Get Started has links […]
Is OpenAI’s Sam Altman move a good thing for customers or Microsoft?
It seems Sam Altman might be joining Microsoft to work on their artificial intelligence technologies with maybe 500+ of his staff following him. Is that really a good thing for customers wanting to get the most from AI technology. Microsoft actions over the last few days suggest it’s not the best move for them either. […]
Roaming email signatures in Outlook 365, 2021, 2019
Here’s how roaming email signatures work (supposedly) in Outlook 365, Outlook 2021 and 2019 for Windows including the traps and pitfalls for the unwary. What is a roaming Signature? For most of Outlook’s history, Email Signatures were saved on each computer/device only. If you have multiple computers with Outlook, you setup signatures on each device. […]
Excel trick uses a single cell to get the latest stock or exchange rate
Here’s the Excel trick to grab a recent stock price or currency exchange rate using a single cell. It bypasses the multiple steps needed for the Stock/Currency data type and the annoying lack of configuration in the standard stock/currency data type. The single cell trick makes for more compact and workbook plus letting you select […]
Great guide to harnessing Python in Excel
In a great development for data analysts and coding enthusiasts, John Lam’s new guide that expertly explains Python programming with Excel from the start to a practical example. Book of Python in Excel goes through the basics like using the XL() function in Python to grab data from an Excel workbook, importing external data and […]
