Here’s how to force the ‘Draw with Touch’ button to appear in Word, Excel and PowerPoint when it doesn’t show up automatically. ‘Draw with Touch’ is an Office option to let you draw with a finger or stylus on a touchscreen. It should automatically appear on the right of the
There’s a fast way to Fill cells with sequential data into a list or rows without dragging the mouse. The Series command can insert all sorts of lists for dates, weekdays and numbers. It’s very handy for users that need to fill a large number of cells. Those that use
Excel provides some handy pre-selected styles that you can apply to your cells. Here’s a selection of styles that we use, improve from Microsoft’s bland defaults and will light up your worksheets. These are excellent for distinguishing headers from data, classifying data, or showing the function of each cell (calculations,
Type the White Right backhand pointer 👉 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. It’s officially called “White Right Pointing Backhand Index”. White Right Pointing Backhand Index 👉 symbol is great for signs, simple hand graphics in slides or an alternative
Excel’s Paste Special feature can be used to modify multiple numbers at once. Paste Special is more commonly used to paste only values or formatting, it has other tricks to offer. We’ll show you firstly how to multiply numbers in Excel by using Paste Special then add, subtract and division.
The Word Text Box Gallery gives you a head start on nice document effects. Under the Insert tab in Word is the Text Box gallery, a selection of pre-set options to jazz up your document. It’s the easy way to put in fancy design elements you see in books and
There’s a new “File Card” look coming to the Office ‘all in one’ app for iPhone and iPad which shows document thumbnails and other information. File Cards use the document thumbnails that are in most, but not all Office documents plus PDF files that are stored on OneDrive. Microsoft says
Adding thumbnail or preview image for Word, Excel or PowerPoint Office documents is easy, though you won’t find the choice anywhere obvious. We’ll dig into how thumbnails work for some nerdy extra detail. Thumbnails are the small images that appear in File Explorer and elsewhere instead of the standard icons
Excel has a way to rank a series of values, showing which is top, middle and bottom. As usual, what appears to be a simple thing has extra features to cope with the real world like equal placings. Here’s a simple ranking. As you can see, Excel has ranked the
Here’s a look at two things that you’d expect Excel to handle quickly and easily, but doesn’t. Showing a ranking of items with equal ranks shown (3rd equal etc) and ordinal numbers (1st, 2nd, 3rd etc) or ordinal names (first, second, third etc). All are possible in Excel but strangely
If you’d like to be really clever with Rank/Rank.EQ in Excel, here’s how to show different words for joint rankings (only two with the same rank) or equal rankings by three or more. It’s a small difference but can make your reports or merged documents look a lot more professional.
You can show ordinal numbers in Excel; 1st, 2nd, 3rd. Sadly, it’s not as simple as you’d think. The ‘Ordinal Rank’ column, 1st, 2nd etc you’d expect to be provided by Microsoft, but it’s not. There’s no in-built function nor a number format. After all, Excel has many different number
insert the Black Right Pointing Backhand Index 🖝 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Right Pointing Backhand Index 🖝 symbol can be used as a creative bullet symbol in lists or to point a direction on a sign. It’s
Almost Equal sign ≈ can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The Almost Equal symbol ≈ is commonly used within Mathematics to indicate two values are roughly equal, but not exactly equal. Or use it whenever you need
How to move rows or columns up, down or across an Excel worksheet. There’s a quick way but it’s not obvious. Excel has a variety of different ways in doing this, but it’s important to know the fastest and easiest way, to save you a lot of time and hassle.
WOFF are a new-ish type of font that you might have seen mentions or downloads. Here’s how to use them in Microsoft Office; Word, Excel or PowerPoint. WOFF is Web Open Font Format designed to be compact and easy to download. WOFF is for web sites and mobile apps, not
Type Up Down Arrow with Base or underline ↨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Up Down Arrow with Base ↨ looks in different fonts. Here’s some examples of how Up Down Arrow with Base / Underline ↨ looks
Is it possible to share or send a single Excel tab or worksheet from an entire spreadsheet? Sharing a single worksheet or tab isn’t possible. Excel’s sharing features work on the workbook or entire document level. But it is possible to send out or share a single worksheet/tab with a
The new look Office 365 (and Office 2021) is coming. For the moment you might have the option to try it or not. Here’s how. Look for the megaphone If a megaphone appears on an Office app title bar, you can try the new look Office for Windows. Click on
Type the Up Down Arrow ↕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Up Down Arrow ↕ symbol is a vertical line with arrowheads on both ends, pointing up and down. How Up Down Arrow ↕ looks in different fonts. Here’s some examples of how Up Down Arrow ↕ looks in common Office fonts. Up
Pantone has announced their “Color of the Year” for 2022 and, as usual, we’ll explain how to use those exact colors in Word, Excel, PowerPoint and Outlook. For 2022, the new color will also be appearing in Microsoft products with a nice PowerPoint template with extra color palettes. The color
The Financial Modelling World Cup or Excel esports Final was held a few days ago and you can watch the whole event. There were eight finalists from the USA, Canada, UK, India and Australia. If you can’t get enough of Excel champs at work, check out the earlier rounds. Last
The Ink Editor button in Word 365 has gone, replaced with the ‘Action Pen’ on the Draw tab in Word 365. Some of the ink gestures have quietly changed since the original release of the Action Pen. The ‘Action Pen’ is now on right-side of the Draw tab | Drawing
The gradual rollout of the new look Office for Windows (Microsoft 365 and Office 2021) continues. More users, but not all, can now try the revamped Office interface. We’ve had a lot of feedback from Office Watchers about the new look. Some approve, others definitely don’t. Some users are eager
