‘Spy Pixels’ is the new name for a common tracking method used in commercial emails. We’ve written about them many times over the 20+ years of Office-Watch.com, the only new thing is the name. What are Spy Pixels? So called ‘Spy Pixels’ are tiny images (1 pixel only) linked in
An Excel Table Form is a simple no-code way to view a single table row in an editable box. If a row of data is too wide, instead of scrolling left/right to find what you need, use a data form to add, edit, find, and delete rows. Table Form is
How to use AutoCorrect for more than a word or single character. It can speed up typing of large blocks of text or expanding an acronym into the full name. Paul G writes: “Autocorrect is fantastic for the numerous standard letters, or specific instructions for various computer actions (downloads, etc).
The full collection of Van Gogh masterpieces are available online, ready to be used in PowerPoint slides. Here’s how to get good quality images of the great man’s work and use them wisely in slides. Not interested in Van Gogh? These tips show how to fit any image into PowerPoint
How to insert the white right pointing hand ☞ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Officially called “WHITE Right POINTING INDEX” ☞ symbol is a different or novelty form of the right arrow as a hand. It can be used
Shutterstock are offering two nicely designed PowerPoint templates for free. We’ll explain how to get more from the professional templates with a few clicks. Minimalistic PowerPoint templates comes in two styles: Dawn and Midnight. Dawn Template Evokes a meadow at dawn with a muted color scheme. Midnight Template Midnight template
There are two different levels of hidden sheets within Excel, hidden and the less well-known very hidden worksheets. We can easily hide our worksheets by right-clicking the sheet tab and selecting hide. There’s a more extreme option available. Very Hidden means the sheet/tab doesn’t show up at all in regular
Excel users owe thanks to Sumit Gulwani . He’s the guy who turned the Flash Fill feature from a vague dream into something that makes life easier for Excel and other Microsoft customers. Flash Fill is a way to join, split or reformat text in Excel without coding. You type
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with a black background and white center graphic. This isn’t part of the official ISO specification for the symbol but it’s widely used. It’s done by adding a black circle under the main circle/line & graphic (which is
Entering blocks of text in Excel is quite easy. What’s not obvious are all the options to make the text easier to enter and look better. Just typing in a cell will enter text. By default it will extend into any unfilled cells. If there’s something ‘in the way’ the
Microsoft announced 83 security bug fixes for January 2021, the count is really 96 once you add the Edge browser patches from last week. At first look, it seems there’s only five Office related patches including two each for Word and Excel. It’s important to keep both Office and the
Benford’s Law is an amazing tool that is simple to use in Excel. Benford’s Law is one of those mathematical laws that seems to defy common sense but works for most naturally occurring number sets. It says that in most groups of naturally occurring numbers, the leading digit 1 will
Continuing our series on the ‘Not Allowed’ symbol, let’s make a versions with text instead of a graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Text in circle Instead of
Continuing our series on the ‘Not Allowed’ symbol, let’s make a version with text and graphic or icon. Check out our article on Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint about creating, resizing and coloring the basic shape. Better ‘Not Allowed’ red circle/line symbol with
How to convert metric to imperial and other measure conversions in Excel. Converting measurements from one system to another can be done by Excel using the CONVERT function … here’s how it works and then we’ll tell you what CONVERT can’t do or should do better. As usual, we decided
There’s plenty of scope for variations on the basic Not Allowed symbol (red circle with diagonal) using the tools in Microsoft Office. See Make a ‘Stop’ circle / diagonal symbol in Word, Excel & PowerPoint for how to insert the basic ‘Not Allowed’ shape and change to suit your needs.
Pantone has announced not one but TWO ‘colors of the year’ for 2021 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. The colors of 2021 are … Illuminating and Ultimate Grey As usual what’s more amazing than the color is the description
Microsoft has released some ‘sweater’ backgrounds for Christmas, Hannukah or anytime of year. The PNG images are intended as backgrounds for Teams calls but can be used anywhere. A PowerPoint slide, Word background, Zoom call background or whatever. Adding Virtual Background or blurred video to TeamsAdd your own background image
The only specific 2020/2021 calendar template in Microsoft Word is an academic calendar from August 2020 to July 2021, here’s how to use it and make it better. In File | New search for ‘academic calendar’ there are a few options. We’re looking at ‘Academic year calendar’. A few notes
Adding a video as the background of a PowerPoint slide is surprisingly easy. You might expect that it requires special features but it doesn’t. There are some tricks to know if the slide gets muddled up. A true PowerPoint slide background has to be still a solid color, gradient, pattern
Some people have way too much time on their hands …. and this was pre-lockdown! Hunter Hobbs decided to find out how long it takes to scroll down to the very bottom row of Excel. That’s row 1,048,576. It only takes a moment and two keystrokes to get there, but
The Quick Access Toolbar (QAT) is located on the left side of the Word, Excel, PowerPoint or Outlook title bar. You can add commands, options and even symbols for easy and quick obvious access By default, the QAT only has Save, Undo, Redo and Touch/Mouse commands but you can cut down
A quick way to type a ü tick or check mark character in Word. Another great Autocorrect suggestion from Morris B. ” … the one that I have found the most useful is to replace ‘./’ with a tick (wingdings 252 – or wingdings 254) “ Using the fullstop/period is
