All about the \# formatting switch in Word field codes lets you change the look of numbers in many different ways. Many examples plus a guide to the formatting codes. Use these options with Word fields that return a number like SEQ, REF, PAGE, SECTION, SECTIONPAGES, AUTONUM, EDITTIME, FILESIZE and
Excel 365 makes it incredibly easy to get past price and volume info for stock, fund and currency exchange data, then convert that into a professional-looking chart. Some may remember the days when stock prices were added manually from a newspaper. Now a single Excel cell formula can grab the
How to insert the Dog Face 🐶 emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Aside from the obvious the Dog Face 🐶 emoji can used as a variant of the Grinning smiley face emoji. How Dog Face 🐶 looks in
How to compare caffeine levels in coffee, tea, soda and other drinks from an Excel spreadsheet. The Guardian’s Datablog has interesting analysis of caffeine levels in different foods. Sounds boring until you read that: reduced sugar colas have almost double the caffeine of a regular, sugared, cola. 1 cup of
Microsoft’s digital ink notetaking app, Journal, has grown up. It’s no longer ‘Garage’ trial software but part of Redmond’s official software line up. If you like scribbling or notetaking with a digital pen, you can try out Journal. Journal was a Microsoft Garage project which are trials of an app
Microsoft’s To Do app can now automatically add due dates, reminders and repeat tasks automatically based on what you type. It works quite well but there’s some traps for the unwary. Whatever you type in a new task is analyzed for hints of due dates, reminders and repeat tasks. Here’s
Had you wondered what’s happening with the Outlook replacement: Project Monarch? Seems we won’t have to wait much longer to see a preview. Project Monarch is a Progressive Web App (PWA) that will run in your browser. It will have email, contacts, calendar and perhaps other ‘Outlook-like’ features. A Progressive Web
Changing the case upper/lower for text through all of a Word document is easy because the default Find / Replace settings don’t need changing. We’ve already talked about the manual Change Case options in Word, now we’ll move onto bulk changes. Sometimes the spelling of a product or brand has
Change Case options in Word, like many Word features goes beyond the obvious choices from the basic shortcut. There’s up to five choices on the ribbon with a keyboard shortcut to reach it. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE
Replacing images in Word, PowerPoint, Excel and Outlook is a lot easier using the ‘Change Picture’ option, especially now you can change to insert an image on your clipboard. We’ll show you a step by step on how to do it. There might not be one simple keyboard shortcut, but
Ever been confused by the \* formatting options in Word field codes? You’re not alone, believe me. Here’s a complete guide with the \* codes and examples of how they appear. In this article we’ll look at the named formatting codes which start with \* like \* Arabic and \*
StockHistory() is an Excel function that can add historical stock price info, as well as currency exchange rates at monthly, weekly or daily intervals. Date and Closing Price plus optionally Open, High, Low and Volume. All ready to make a chart for stock price analysis. Excel 365 has Stock and
Clipchamp video editor has been integrated into Microsoft’s product range but not in the way promised. Instead, it’s selling at a high price for relatively little extra. Though Microsoft has acknowledged part of the problem by upgrading all customers to a decent quality for exporting files, this article has been
The main Office.com page has an updated look for Business and Enterprise customers. There’s a Create pane, My Content section and Quick Access buttons plus some more useful features hiding away under obscure buttons that are easy to overlook. This is the overall Home https://office.com look if you’re logged into
How to view Text Boundaries in Microsoft Word, why they can be useful and how the feature has changed over time. Text Boundaries put a dotted line box around each text element on a Word page. Turn on Text Boundaries to solve formatting problems. For example, in the above example,
How to show the four corner Crop or Trim marks on a Microsoft Word page. The ‘L’ shapes are a guide to the useable part of the page, inside the margins, and appear in all four corners. The four marks are called Crop Marks also known as Trim Marks. Word
Microsoft Word has a ‘profanity’ check to warn you about rude, offensive or swear words in some places. In others, the same word won’t get any special marking. We’ll explain how to setup and use Microsoft Word’s Profanity check then show its limitations and traps. The Profanity, offensive or swear
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
If you have included equations in a document, Word can generate a list of them all for you. Like a table of contents, this list or Table of Equations can include page references or links to each equation. A Table of Equations can be useful for creating a proper appendix
Type the White or outline Chess King ♔ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess King ♔ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. There’s also a
Word and Office have several down “pointing hand” symbols available in some fonts. Here’s the Unicode options explained and shown with the codes and shortcuts to type them in Excel, PowerPoint and Outlook too. There are various pointing hand options in Unicode: Index – a pointing index finger with palm
If you’ve ever needed to split dates in Excel into separate day, month, and year, there are several options to choose from. Excel has different functions, Text to Columns or Flash Fill which can do the job. Here’s a quick guide on several methods: Using the DAY, MONTH and YEAR
With a little Office formatting trickery, you can make a Twitter ‘message’ that looks like what you see on the Twitter web site or app to put in a Word document or PowerPoint slide. Use this trick to recreate a real Tweet that’s part of a document. Or as a
There are disagreements about how to pronounce the acronym ‘GIF’ for the popular image format, even though there’s an authoritative answer. Even Microsoft Word is confused about how to say GIF with the Read Aloud feature. Stephen E. Wilhite, the developer of the Graphics Interchange Format or GIF passed away
