“I’m confused. In Outlook there are two choices for a UK/London time zone. UTC or London. Both are zero meridian (+00:00). What’s the difference and why isn’t an entry for GMT?” Oscar R, Missouri. The quick answer is to always choose the time zone entry that matches the city or
Here are the major marks Microsoft Word displays with the Show All option on. There’s common ones like Paragraph Mark, Tab and Space and lesser known such as optional hyphen and hidden text. Show All will also display the seven different types of break in Word. Paragraph Mark, the symbol is called a Pilcrow. It’s the symbol used for
If you are working on a Word document with complex formatting, sometimes you need to see the hidden characters and unseen workings. It helps figure out Word’s secrets or what’s going on when the layout doesn’t behave. That’s where ‘Show All’ becomes essential. Microsoft Word was designed to hide all
Email Read Receipts sound great but don’t often work these days. Articles like “How to tell if someone opened and read your email” aren’t telling the whole story. Here’s the reality behind the Outlook ‘Read Receipt’ feature and how it works across the Internet. The idea is to send an email
There are limited options for entering the current date and time into PowerPoint slides, notes and handouts. PowerPoint doesn’t have field codes like in Word, so Microsoft seems to have shoehorned in some field like features. Insert Date and Time in slide On the Insert Tab, right side there’s an
The COUNTIF worksheet function in Microsoft Excel has a simple format that provides a quick and easy way to count the number of times a certain condition is met in a data set. By Kara Monroe That sounds imposing but it isn’t. Most likely you already use COUNT to count
Excel has an in-built feature to remove duplicates from a list but what if you want to delete both items if they are duplicated or more than two? Remove Duplicates Remove Duplicates is tucked away on the Data tab, Data Tools | Remove Duplicates. It will ensure that an Excel
The appearance of all your captions in Microsoft Word can be changed by modifying the style that is applied to them or selecting the text and formatting manually. See Adding Captions in Word Caption Style All captions use the ‘Caption’ style, so modifying that style will modify the format of all
Captions let you add autonumbered labels under most Word objects including pictures (figures), tables or equations. Captions can be combined into a list of all the figures/tables/equations in the document, along with their page numbers. As usual in Word, there are many options beyond the simple adding of captions and
Three ways to insert or import an EPS (Encapsulated PostScript) graphic into Word, Excel, PowerPoint or Outlook. There are two a ‘quick and dirty’ options and a way that allows some editing. Microsoft Office did support EPS files for many years but dropped them in 2017/2018 because the EPS format
What’s the difference between aligning to a page and align margin in Word documents? Quite often, there’s no practical difference between ‘Align Page’ and ‘Align Margin’ in Word. These options appear when positioning an object on a page and other places. Centering an object has to be done compared to
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.
Like an image in an Microsoft Outlook email? Here’s how to save it to a separate picture file. Sometimes you get an email with a nice picture displayed in the message (as opposed to an attachment). You can ‘grab’ any image and save it to your computer. On most web
How can you change the default program for .RTF documents away from Word and make it stick? We’ve talked about the virus security risk of Rich Text Format .RTF files which even Microsoft has, at times, suggested blocking. Despite that, .RTF files are associated to Word during the Office installation.
There are two ways to make a text box transparent in Office; Word, Excel or PowerPoint. There’s a quick option and other that gives you some more control. The Word, Excel or PowerPoint ‘Text Box’ feature is presented as a way to have ‘pull quotes’ or sidebar text in your
With an Microsoft 365 plan, Family or Personal, how many tablet and smartphone devices can you install Office Mobile? The rules have changed over time, so confusion is understandable. Some emails to our Feedback page plus people we’ve met shows some confusion about how many tablets/smartphones you can load up
What is an RTF document, is it safe, how to use in Microsoft Word and why is it still being used? “I’m looking for a job and many employers are asking for my resume in RTF format. How do I do that and why can’t I just use a Word
2022 is the Chinese year of the Tiger. Here are some tiger images, emoji and graphics in Word, PowerPoint and Office apps. Drop any of these into your documents or slides for a little New Years fun. See our related article Make your Chinese New Year graphics pop with these
There are simple and traditional color choices for Chinese New Year graphics and text plus some Microsoft Office graphics tricks to make them look a lot better in Word and PowerPoint. Simple design done in a few moments with just the icons and tools in Word 365 or PowerPoint 365.
Insert the Identical To ≡ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Identical To ≡ symbol, also known as the triple bar, is a mathematical symbol. The three lined symbol means that something is identical or like another value, but this
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,
