A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function. This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. Here’s some options for conversion or sourcing alternatives. SVG’s are great with many advantages for Office 365 and Office 2021/2019 users. Not everyone has the latest Microsoft Office or shares documents
Microsoft Word has almost all you need to make ‘hand written’ notes and letters for a fraction of the cost of a special service. Dig into some of the lesser known Word font and line spacing settings to get that ‘written by hand’ effect. The New York Times has a
Outlook has had a Categories feature for a long time … here’s how you can use it and why. Categories let you group Outlook items (emails, contacts, calendar and tasks) into broad topic areas or subjects … all without moving from their original folders. They can be subjects that a
Find or change many web links in Word documents using the Replace command, here’s the two tricks – one is good and the other not so effective. For example, you might need to change the domain name due a corporate restructure or update links so they are secure (https) instead
In Microsoft Word you can use Find combined with your own actions and easily switch between the Find and editing. That’s great for situations where a simple Replace command isn’t enough. Find results show up in the left-hand pane or dialog box, you can move between find results and editing,
Microsoft Office rules might let two users or more use the same copy of Office on a computer. It depends on which type of Office you have on a Windows or Mac computer. Office can work for multiple separate users on the one computer. Most commonly, there are separate Windows
Why does the same picture appear rotated sideways or flipped in Outlook for Windows/Mac but right side up elsewhere? It’s an image annoyance in older versions of Microsoft Outlook which we’ll explain. Outlook for Windows or Mac lets you preview a picture by clicking on the attachment icon but sometimes
Word can check if you use a single or double space after a sentence (fullstop/period) but how can it be changed single space to double throughout a document? The Sentence Spacing settings (single, double or don’t care) is in Word’s Grammar settings see Sentence Spacing in Word. These days, sentences
There are many ways to save an Outlook email or other items to a separate file. Which one you choose depends on your needs. One Outlook message or many? Compatible for many people or not? Easy to search or not? Some options work for a single message only. Others can
Microsoft Word can check if you use a single or double space after a sentence (fullstop/period) but how can it be changed throughout a document? Make all sentences end with a single space instead of double spaces, triple or more. The Sentence Spacing settings (single, double or don’t care) is
There’s a useful and long-standing Office add-on for people who have many documents open at once and prefer them to appear in tabs (like web pages) instead of separate windows. Office Tab switches Microsoft Office for Windows from the usual ‘one document per windows’ view to ‘many documents in a
To my horror, I encountered something strange while working on a Word document with “strung out” or ‘stretched’ text on the last two lines with huge gaps of space between them. Here’s the two ways it can happen and the four fixes available. A stretched-out line in a Word document
Type the three different types of Ellipsis … marks in Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Ellipsis … symbol is used for a gap or break in some text, usually to drop out some irrelevant text or speech. The same applies
Combine or divide adjacent Microsoft Word or PowerPoint table cells into a merged single cell or split a cell in two. Welcome to ‘Merge Cells’ where you can combine adjacent cells into a single cell. It’s very handy for table formatting tricks and other unusual situations like a longer than
Type the Yen ¥ currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Yen is used for Japanese currency and the Chinese Renminbi / Yuan. Microsoft Excel also offers the Yen symbol for Mongolia even though the tögrög currency uses another
More ideas and a wish list for ending a PowerPoint presentation with a different slide. After our article on the ending slide options for PowerPoint, Vivian from the UK writes: “… it’s really very easy to do what I always do at the end of PPT presentations. Just add a
The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. The blank black slide which appears usually at the end of a slideshow is a default setting in PowerPoint. But it can be changed. Open PowerPoint
How to change the PowerPoint slide numbering to a different start number. In PowerPoint, slides are numbered by default from 1 but that’s not always what you need. For example, you’re working on some slides which are just part of a set of slides eg. working on slides from number
In PowerPoint you can record narration and comments during or after a slideshow. This makes the presentation more interesting and interactive. This feature is especially useful when you convert presentation to video. With narration the video would seem complete and the process of doing this is quite simple and easy.
Word can generate a list of all the tables in a document. Like a Table of Contents, this list of tables or Table of tables can include page references or links to each table. A Table of tables can be useful for creating a proper appendix or reference within more
A Word document and a floppy disk caught a serial killer back in 2010. There are still lessons for anyone wanting to keep their personal or business data confidential. Known as the ‘BTK killer’, he murdered 10 people in Kansas between 1974 and 1991. The murderer was finally caught in
Occasionally you’ll get someone who sends lots of messages you don’t want to see. Outlook has a few options for refusing or politely ignoring messages from certain email senders – either individually or automatically. Most commonly these are enthusiastic zealots on some subject and are trying to ‘spread the word’
If you look in folders that contain Office documents (Word, Excel, PowerPoint) you might see the occasional .tmp file. What are they? Could they be useful? How to look inside. Can they be safely deleted? The quick answers are: probably Word or Office document remnants, could be handy to recover
