OneNote Pages can contain all manner of things; text, files, documents, PDF, drawing, images, tables, web clippings, lists, audio and video files. Pictures and recordings in OneNote have some nifty tricks and you can search everything you’ve added to OneNote. Text is very simple just ‘click on the page and
Styles in Microsoft Word would be very cumbersome if you had to set up each one individually. To make it easier, styles have inheritance. A new style is usually a copy, linked to an existing style with just some changes to selected items. Here’s an example of inheritance in a
There are good reasons to avoid the Normal style for the main text in a Word document and use the hidden ‘Body Text’ style instead. The standard Microsoft Word document structure has Headings (Heading 1, Heading 2) … with paragraphs of text in the Normal style. It sounds good but,
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
Word has many calendars in the File | New templates supplied by Microsoft. Search for “calendar” in the File | New pane then make simple changes to suit you. In Microsoft Word’s File | New pane, search for ‘calendar’. There are two basic calendar designs: Start of Week Some have
Here’s how to choose good looking font pairs for your Word headings and body text or PowerPoint titles and text. We’ve shown you how to use Google Fonts in your Office documents. The Google Fonts site itself is little help but others have curated suggested pairings. Most of the suggested
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
There’s a strange, almost prudish, feature in the Microsoft Word spell checker aka Microsoft Editor that’s used in many of the company’s products. We’ll explain Microsoft seeming avoidance of ‘Naughty Bits’ and why it’s happening. Warning! This article is unusually explicit (NSFW) for Office Watch. If sexually explicit but standard
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
Outlook replies can be a problem of invisible or hard to read text when the incoming email has a color background. We’ll explain the problem and how to fix your reply email. Messages with colored backgrounds might look OK to the sender but are a pain when you try to
If you want to change the background color on an email, Outlook’s option to do that has changed name and location. At least Windows users can change background color, Outlook for Mac users lost this option at few years ago! A color background can be nice in an email but
How to insert either of the Tilde ~ ∼ symbols into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Tilde ∼ symbol is easy on some keyboards but for other keyboards, there’s no specific key for Tilde. The two Tilde symbols There are
Microsoft loves tinkering with WordArt and in Word 2010 the entire feature was expanded to Text Effects and split into two features on different tabs. Here’s how to find all the old WordArt features plus a lot more. Back in Office 2007 there was one WordArt feature on the Insert
We’ve looked at design and typography in 2001: A Space Odyssey and how to use the ‘2001’ look in Microsoft Office. Two readers asked about some curious kerning in our version of the title font.Maybe you’re not interested in the fine detail of the text in a fifty year old
Use Word tables to do formatting tricks, make complex formats easily and solve Word formatting problems. There’s more to Word tables than just showing grids of information like this: Tables have all sorts of little tricks in them and let you do clever things in Word. Here’s a look at
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
Insert the Black Chess Queen ♛ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♛ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or just a generic crown icon. How Black Chess Queen ♛ looks in different fonts. Examples of
Rename Word styles or give them alternative names/aliases. Sometimes you’ve got no choice but to make an alias because the original style name is fixed. Any style can have an alternative name which appears in the Style Gallery. That’s a useful trick because there’s limited space for the style name
The Word Style Gallery doesn’t have to be left the way Microsoft supplies it. Fix the Gallery to make it work better for you. Microsoft Office often has menus and options aren’t designed for the customer. Instead they are setup for Microsoft’s needs in ‘out of the box’ demonstrations or
