There are two ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are important with the Stock and Currency data type in Excel 365 but also other situations. Normally Excel will update itself when you change a cell value. These days there are situations where cells
Insert the Water Pistol or Gun emoji 🔫 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. AND how to make the ‘gun’ point to the right. Water Pistol 🔫 symbol is the only ‘gun’ style symbol in the emoji collection. It’s officially
There are at least ten ways to ‘reverse’ ‘mirror’ or ‘flip’ text or images in a Word document. Horizontal, vertical, reversed, combined or any angle you like. When people say those terms they can mean different things so we’ll look at many options and how to do them. Also along
Modern PowerPoint has made an ‘improvement’ to slide linking in PowerPoint which hides an important feature that’s been in PPT for years … linking to slides or web pages. Sometimes Microsoft gets so enthusiastic about some innovation they forget the basics that customers use on a daily basis. Insert |
Type the fun Eyes 👀 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eyes 👀 symbol / emoji is a bit of fun for documents and PowerPoint slides. How Eyes 👀 looks in different fonts. Eyes is available in symbols fonts like
A few years ago, Microsoft quietly added a little Word trickery to make it easier to Insert Symbols and not get the dreaded blank box or box with question mark. Here’s what Word does and how to workaround the, sometimes unhelpful, fix. Back in the olden days of Word 2007
Google unveiled a little update designed to streamline the experience for Outlook enthusiasts. Outlook meeting organizers will now appear as that in Google Calendars. According to the Google Workspace blog, Google introduced a subtle yet notable modification in the integration between Calendar and Outlook. The update clarified: Previously, if a
Insert the Ballot Box with Ballot 🗳 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ballot Box with Ballot 🗳 symbol can be used for any situation around voting or choice. For example to decorate this PowerPoint slide. How Ballot Box
What are the legal limits on fonts supplied by Microsoft in Windows or Microsoft Office? Is there anything special for the Microsoft 365 only Aptos fonts? A few readers have asked us about the font license rules that apply to fonts provided by Microsoft. Can the fonts be embedded in
Insert the Statue of Liberty 🗽 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. “Lady Liberty” has symbol/emoji plus stock images, SVG icons or 3D models. How Statue of Liberty 🗽 looks in different fonts Two standard Windows fonts have the Statue
There are a lot more Office Icon or SVG graphics available than the ones in Microsoft 365, Office 2021 or 2019. Jazz up your documents, emails or presentations with a wider range of graphics than the (overused) ones that come with modern Word, Outlook or PowerPoint. Microsoft 365, Office 2021
Word and PowerPoint have options to embed a font into the document, so why doesn’t it work? In theory you can select the ‘Embed fonts’ option for a document / presentation and all the necessary fonts will be included in the document. That means the fonts will appear, as the
Inside the Microsoft Office (Word and PowerPoint) embedding fonts feature within documents. Font embedding adds the font into the document/presentation file itself so that anyone reading will see the same text as the creator. Normally fonts are installed on the computer and used by whatever programs need them. If the
Type or enter the ° Degree symbol into Microsoft Word, Excel, PowerPoint or Windows / Mac programs generally. Degree ° is a common symbol and should be available in most fonts. If not, try another font or one of the fonts with a very wide range of characters like Arial
Here’s some Office Watch readers suggestions for using Microsoft Office’s Autocorrect with to quickly type common phrases and symbols like the degree sign and temperature. Yehuda Z says: “I use (0) to auto-correct to the symbol for degrees ?. It makes things much easier. I also use ty and tyvm
Insert a World Map 🗺 symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Of course, there are many Earth map images or drawings available on the Internet. There’s also some Microsoft Office Icons that we’ll explain below. We’re mostly talking about
In 2018 Office for Mac took a huge step towards true document compatibility. Font embedding was finally added to Word for Mac (Word 2021, Word 2019 and Word 365 for Mac) and PowerPoint for Mac. Font embedding adds the font details into the document itself. When another computer opens that
The new Aptos range of fonts is only available on Microsoft 365 apps. We investigate what happens when a document, sheet, slide or email with an Aptos font is opened on a computer without Microsoft 365 and the Aptos font range. In short: if Aptos fonts are not available, it’s
How to insert the Mount Fuji 🗻 or snow-capped mountain into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Mount Fuji (富士山 or Fujisan) is a Japanese Holy Site and World Heritage Listed. The symbol or emoji 🗻can be used for the famous mountain
Like to know some more about your Microsoft 365 for Windows software license? How long the Office apps will run without an Internet connection? Here’s how to see that hidden license info, how it’s changed and a little good news too. Microsoft 365 software occasionally checks with Microsoft servers to
In addition to Manual, Paragraph and Style page breaks there are two unusual ways that Microsoft Word can insert a page break where you might not expect one. Keep with next and Keep lines together. Learn about Word Page Breaks: Visible and Invisible Page Breaks in Word and Add a Manual
There are many different ways to insert a page break into a Microsoft Word document, some are visible and others invisible even with Show All turned on. Luckily, Word has a straightforward way of doing this with a manual or separate Page Break. It’s also possible to associate a page break with the paragraph, which is a lot easier manage page breaks but they are somewhat invisible and it’s not
There’s a simple way to manually insert or force a page break in Microsoft Word. Also delete a page break later. Word will automatically insert page breaks in your text depending on the size of paper you have selected; they may not be in the place you want them. You can’t delete
Every Microsoft Word Style has an option to ‘Automatically Update‘ which sounds great, but can lead to more confusion. Here’s what ‘Automatically Update’ really means, why it’s wise to turn it off and the better alternative. There are many ‘Automatic’ options in Word that are spread all over the place.
