Reasons why a Word document or email can look different on one computer than another device and what you can do get ‘fidelity’ or the same look across many machines. In short – you can’t assume that what you see is the same as someone else. You get a document
Adding comments to Microsoft Word documents isn’t just for groups, use them yourself for your own reminders and side-comments while you’re working on a doc. Word has a feature to let you add ‘side’ comments to documents – comments that don’t show up in the final document, don’t effect the
Any Excel worksheet that has lists with headings on the top row can quickly get pull-down menus to filter or sort the data. For a regular Excel worksheet, go to the Data tab and click the Filter button. This adds extra pull-down menus to each of the headings. For an
You can translate a Pantone PMS code or name into something Microsoft Office; Word, Excel or PowerPoint understands? Sometimes you’re given a specific color using the Pantone color scheme. Most commonly this happens for a corporate logo. The Ford car company specifies ‘PMS 294C’ for their blue logo. McDonald’s uses
Another way to convert text to dates is by adding zero to the text. This is a trick which forces Excel to convert the text into an Excel value so it can then add the zero. Since adding zero doesn’t change the value, you end up with text converted to
It’s easy to share appointment details with other people, whether they use Outlook or not. No need to type in appointments when you can send and receive the details right in your calendar. We’ll explain how it works for both sender and receiver (organizer and invitees) on various platforms, including
Like Word, PowerPoint and Excel also have options to add borders to pictures to add that extra oomph to your work. Users can choose between fairly simple borders or add some further complex, fancy styles to their images. If all this seems very familiar, it’s because the same picture tools
There’s a small but important point about Microsoft Word with Footnotes and Endnotes. It’s so important we’ve made this separate little article about copying or moving. The footnote or endnote is stored in that little superscript character in the document text. Copy, move or delete that superscript character and the
Inserting a link to a PDF (or any other file) into a Word document or email is easy to do. All you need is the web or other link to the PDF and paste that link into your document or email. The key question to ask is ‘Where is the
Add a background image to any page in a Word document instead of a solid color or pattern. Using a picture as the background for Word page isn’t as straight forward because the official or approved method doesn’t work very well. We’ll show you other Word features that work better
Styles can be saved in a Word document but are most effective when saved in a template. Changing the style in a template will affect any document that uses the same template. At the bottom of the Modify Style dialog are two choices for where to save the style. Microsoft
Here’s how to convert an older .doc .xls or .ppt into a safer and smaller .docx .xlsx .pptx even if you don’t have Microsoft Office. Any smart computer user is wary of documents received in the old .doc .xls .ppt formats because they are regularly used to transmit viruses. The
Immersive Reader, as seen in Word and older versions of OneNote, is returning to the latest releases of OneNote It’s a worthwhile tool to use, designed for those with dysgraphia or dyslexia, but perfect as well for those wanting to improve their reading experience. Here we’ll be using OneNote for
It’s vexing that the numbering features in Word aren’t all in the one place. Instead they’re spread across different dialog boxes including “Adjust List Indents … ” and “Set Numbering Value…”. Those two bland names hide some useful Word tricks. Numbering can also be set as a style. The main
Word has at least seven in-built numbering for common uses in documents, some that you know and appear automatically with others hidden away and little understood. We’ve told you about Word Numbered List tricks and Hidden Numbering options in Word plus Faster Numbered and Multi-Level Level changes Headings have numbering options at
You can combine Excel cell formatting into a style, but not like in Word. Excel has Styles … truly it does. Word has a way to combine formatting attributes of a letter, word or paragraph into a single block with a name like ‘Heading 1’. Excel has a feature also
Jon has found a clever way to show words (singular, plural or zero) with many numbers in Excel using conditional formatting. We already shown you several ways to put singular or plural words against numbers in Excel – like 1 cookie or 3 cookies. At the end we noted how
Microsoft has recently added the ability to resize Embed content within OneNote Web. It was already available for the Desktop versions, but now it has been introduced to the OneNote browser based version too. Simply by inserting, pasting, or linking content right in your notes, you can embed a variety
There’s been an uptick in interest for coloring in pages, having the power to relieve anxiety and a form of mindfulness or just pass the time. No wonder Microsoft jumped on the bandwagon and provided a number of coloring-in templates for Word and PowerPoint. As you browse their template selection,
Draw with Touch is available for users with a touch-enabled device. Simply draw with your mouse, digital pen, or even your finger on your OneNote page. You might be familiar with Draw with Touch on OneNote for Windows desktop. Great news, this feature has recently been added to OneNote for
At long last, OneNote can sort the pages (tabs) either alphabetically or by date. Previously in OneNote, if you wanted to sort out your pages, had to do it manually by dragging and dropping the tabs. Microsoft has now added an automatic Sort Pages option. Right-click on a page tab
Set Picture as Background in OneNote is a handy feature for those looking to fill in forms or wish to draw and highlight on top of images pasted into their OneNote page. Generally, the page can shift, and your notes can become a complete mess when inserting images, so it’s
Excel’s Find All lets you locate all cells matching a search criterion in a single step. It will generate a list of all cells that match the current search and report them all at the bottom, for both Windows and Mac releases of Excel. Find All has been in Windows
How to show original text and a translation side by side in Word. The recent versions of Word have had an in-built translation feature that, like so many things in Microsoft Office, doesn’t quite go far enough. The basics are simple enough. On the Review tab there’s a Translate button.
