Here are four different ways to make a new email from an Outlook template file without the hassle of going deep into Outlook’s menus. You can choose to start a template based message from Windows or a button inside Outlook. See Email templates give you faster messages in Outlook for
Here’s how to add a taste of the logo or text from ‘Friends’ sitcom to a Word document, PowerPoint slide or other document. That includes the important dots between letters. All you need is available online plus a little Office trickery. Note for old-timers (like Peter, our Editor-in-Chief). ‘Friends’ was
For emails that you send regularly, there’s a way to have a ‘boilerplate’ email template with most of the details already filled in. Messages can be sent faster and be more consistent. Welcome to the little-known world of Outlook email templates. Outlook email templates can have all the message details
Microsoft promotes OneDrive as protection against ransomware however our tests show it’s not always as practical or complete as the company boasts. One recovery feature works fine but the other isn’t complete. While updating our book Everyday Backups, we tested the OneDrive ransomware protections, not taking Microsoft’s word about how
How to insert the Psi upper case Ψ, and Psi lower case ψ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Psi (uppercase Ψ / lowercase ψ) is the 23rd letter of the Greek alphabet. The symbols are commonly used within physics to
Insert the Xi upper case Ξ, and Xi lower case ξ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Xi (uppercase Ξ / lowercase ξ) is the 14th letter of the Greek alphabet. The symbols are used within various contexts. The uppercase letter
” How can I enter a duration in Excel with the format days:hours:minutes:seconds ? If I enter 5:32 Excel converts that to 5:32am but I want to record 5 hours and 32 minutes.” Time durations aren’t very clear in Excel, but they are possible. The time features are mostly aimed
There are a few strange, non-standard, behaviors to the FollowedHyperlink style that Word uses for visited links. FollowedHyperlink is a hidden style which Word uses for any link which has been clicked or visited by the current user. Because it’s automatically applied it has some peculiarities that don’t apply to
Word has special styles for hyperlinks which you can change from the standard blue, underlined look. Word link styles have some special behaviors to keep in mind. Word links can look very different or appear no different to regular text. All these are hyperlinks, believe it or not. Hyperlink and
About the RAND() function to make random numbers in Excel plus related functions RandBetween() and RandArray() plus some tricks for getting whole numbers only and even rolling ‘dice’ made in Excel. By Michael Barden Typing the =rand() function into a cell in an Excel spreadsheet will return a random number
A reader asks about sabotaging a random number generator. Steven H writes … The article on randomness in Excel was quite interesting, and the link to random.org was neat. Two thoughts come to mind almost immediately though: If you have an application where you absolutely need true random numbers, it
With Random.org you can get truly random numbers for Excel plus options not available in the spreadsheet program like random but unique numbers with no repeats and random dates. Using ‘True’ Random numbers in Excel Our article on Random Numbers in Excel continues to surprise us by being one of
There are two a simple ways to make a list of unique or non-duplicate entries from a longer list. Unlike the many automatic ‘unique’ options in Excel, these options work only once but it’s available in many Excel releases, old and new. Advanced Filter One is hiding at Data |
Since we’re talking about Star Wars, how does Microsoft Office 2016 for Windows handle the words and names from the famous films? A mixed bag. Most of the common names are in the MS Office dictionary but some surprising omissions. The evil Emperor isn’t included. Planet Tatooine has a major
The new iOS 14.5 has hundreds of new emoji but beware using them in emails and documents because they can look very different on other computers. We have examples of how a simple emoji can look very different in Word or Outlook. The new version of iOS for iPhone and
How to insert the Double Vertical Bar ‖ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Double Vertical Bar ‖ symbol is used to represent norms in mathematics, (for example ). It can also be used to signify parallel lines. It can
Type the Cross of Lorraine ☨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Cross of Lorraine ☨ symbol was originally a heraldic cross. In more recent times it was used in the global distribution systems, Sabre, Apollo, and Wordspan, as a delimiter
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s alphabet. Here’s what Word does in English, French, German, Danish, Polish and many other languages. It’s useful filler text for testing formatting or other Word features just like “Lorem Ipsum
The BBC has a ‘long read’ about hidden information inside almost all photos. Office Watch has talked about this problem many times before including how the extra image data hides in Microsoft Office documents, despite the ‘Document Inspector’. It’s too easy just to think of an image as just what
A more efficient way to mark index entries in Microsoft Word is with a concordance or AutoMark file. It’s a separate document with a table of words to be found in the document coupled with their index entries. See Simple Indexing in Microsoft Word for an intro to Word’s indexing
We’re going to talk about creating indexes in Microsoft Word. ‘Real’ books often have an index at the back which Word can create for you. An index is a list of terms or topics that can be found within the document. Microsoft Word has the ‘fixings’ to make an index
Re-creating the “Don’t be a Spock” sign in Word wasn’t hard especially since the original sign seen at the laboratory was probably made in Microsoft Word. Here are some comments on the design. The standard Arial font was used throughout. The two images and captions are in a 2 x
You’ve received a document, but when you try to open it, the file stubbornly won’t appear! We explain how to fix it. Our editor-in-chief saw that problem in an Internet cafe‚ in Ketchikan, Alaska and was surprised when neither the manager of the store nor the cruise computer ‘expert’ knew the
How to insert the Black Right Pointing index ☛ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Right Pointing index ☛ symbol can be used for pointing a direction on a sign or as a different bullet symbol. There’s also a
