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
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
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
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
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
Insert the Eye of Horus 𓂀 into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Eye of Horus 𓂀 is an Egyptian Hieroglyph symbolizing protection. According to Egyptian myth, Horus lost his left eye during his struggle with Seth, and it was restored
Using simple animations in PowerPoint presentations is relatively easy, but you can also take them to the next level, to jazz up your photos in PowerPoint. Using this method might take a few more steps than just creating a straightforward animation, but the result is well worth it … In
The Researcher button on Word’s References tab lets you lookup information online and copy into a document with formatted but optional citation. It’s likely to dismay many teachers and lecturers. Researcher is a cloud service, only available in Word 365 for Windows and Mac. The Researcher pane is really a
Word and Office have several up “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 Up pointing hand options in Unicode: Index – a pointing index finger with
A slip of the typing fingers can be funny, insulting or embarrassing, turning an innocent word into a naughty one. There are features in Word to help avoid these mistakes which have improved over the years but they aren’t 100% reliable It only takes a single letter to turn an
Google has just doubled the cells available in their Sheets spreadsheet, taking it to 10 million cells. Still well short of Excel’s 17 million cells. Sheets can now stretch to 18,278 columns (column ZZZ) for all Google Workspace customers, as well as legacy G Suite Basic and Business customers. Excel has
A long-standing bug in Microsoft Word quietly breaks your document navigation when you place Heading styles inside a table. The Table of Contents shows all your headings correctly, but the Navigation Pane silently drops any heading that lives inside a table cell. The same broken behavior ripples into PDF Bookmarks
As long time space and SF nerds, Office Watch can’t resist putting the look of 2001: A Space Odyssey into Word documents and PowerPoint slides. We’ll show you how to make a ‘close match’ using just the fonts and features in Microsoft Office. We’ll also explain the details behind that
Character Map is a Windows feature that’s very useful for Microsoft Office users. It lets you insert symbols and, importantly, find them which is not possible within apps like Word. Windows Character Map has been around for as long as we’d like to remember and it’s mostly done right. If
Google has a color selector among the many features in their home page. It’s free, works in any browser and it’s easy to copy color codes into Office. Search for ‘Color picker’ or https://www.google.com/?q=color+picker then move the two circles to choose the exact color and shade you want. The HEX
Excel has ways to add a list of dates by day, weekday, month or year either by the fill handle or the Series command. Date Series with Fill Handle You probably know about the Fill handle tool to fill the remaining cells. Once highlighted, just hover your mouse in the
Gridlines are on every spreadsheet in Microsoft Excel workbooks. Did you know those grey lines can be colored to make them fancy, more obvious or more discreet? Let’s look at two ways you can make colored gridlines in Excel. Here’s what it looks like with the pink, black and red
