Like any other text in Word, the appearance of all your captions 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 past and […]
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 some ‘gotchas’ as well. See Changing […]
There’s a TV show just starting its last season, maybe you’ve heard of it <g>? Here’s how to get the Game of Thrones look in Word documents and PowerPoint slides. Plenty of people have borrowed the Game of Thrones or GoT look, including a certain US President. All these uses are contrary to various trademarks […]
Microsoft has admitted a security breach which allowed hackers to access the accounts and data of customers. The admission from Microsoft isn’t complete and the hackers say it’s worse than the company is saying. Who is affected? Some people with a free Microsoft accounts like Outlook.com, Msn.com Hotmail.com etc. Microsoft says that a ‘limited’ number […]
The May 2019 update to Windows 10 includes a long-awaited and important addition, an updated Emoji Panel. What a pity that it totally sucks and is incredibly dumb. Emoji Panel is better than what we had before (nothing) but not by a lot. We’re talking about the Emoji Panel or ‘keyboard’ which appears in Windows […]
Word has settings to automatically change the case of words that you type, fix common capitalization typing problems add items of your own to have capitalized the way you want them as you type. Word also has options to manually Change Case in Microsoft Word. The settings are in the AutoCorrect dialog at File | […]
If, while typing, you notice that Word has automatically changed capitalization of something you did not want changed, you can correct this easily as you type. Hover your mouse over the part of the word that has been automatically changed. A blue line will appear under the changed part. We typed AUtomatic and Word immediately […]
It’s income tax time in the USA and that means a new round of email scams and infected Excel documents to watch out for. IBM Security Intelligence reports on a series of scam emails courtesy of the Trickbot hackers. All the emails look like legitimate messages from big companies like Paychex, a payroll provider and […]
Microsoft continues to struggle with their support for Japanese Era date format in Excel. The new Imperial Era, ‘Reiwa’ is known but the necessary changes for Excel aren’t released yet. New Japanese Imperial Era changes in Excel and Office explains how to add the new Reiwa era without waiting for Microsoft’s patch. Meantime, yet more […]
How to insert the different Ellipsis … marks into 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 in maths e.g. 1,1,2,3 …. 377 […]
Change Case options in Word, like many Word features goes beyond the obvious choices on the ribbon. Alter the upper/lower case of words, phrases or more. ‘change case’ can become ‘Change Case’ or ‘CHANGE CASE’ without retyping. There are four ways to change the case of existing text in Word: Keyboard shortcut Change Case button […]
Changing the case upper/lower for text through all of a Word document is easy because the default 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 peculiar case choices like iPad, eBay or reCAPTCHA. […]
Microsoft has never been great about documenting patches and bug fixes but this month they have sunk to a new low. Maybe it’s a delayed April Fool’s prank with Microsoft ‘taking the Mickey‘ or treating Office customers with contempt? Sustained Engineering isn’t sustained Maintaining Office software is the thankless job of the Office Sustained Engineering […]
There are shortcuts that automatically format bold and italic text in Word. The same shortcuts and more work in WhatsApp texting as well. AutoFormatting Bold and Italics as you type In Microsoft Word and Outlook it’s possible to make words bold or italic as you’re typing. For touch-typists that’s faster than stopping to highlight text […]
An update for Excel users on the upcoming new Imperial Era in Japan and how to type the Reiwa era name in Office documents The Japanese government has now announced the new Era name that will coincide with new Emperor. From 1 May 2019 we’ll be in the 令和or Reiwa era. This might not seem […]
Converting SVG icons into JPG is essential for older Word and Office versions that don’t have native icon/SVG support. SVG’s are great with many advantages for Office 365 and Office 2019 users. Not everyone has the latest Microsoft Office or shares documents with others who have earlier versions of Office. Scalable Vector Graphics (SVG) are […]
In Japan there are two amazing uses of Excel. Excel used for displaying train timetables and to make beautiful works of art. The Michelangelo of Excel Tatsuo Horiuchi has become the Michelangelo of Excel. On retirement he wanted to turn to art but didn’t want the expense of paint, brushes etc. He turned to his […]
The Word Style Gallery doesn’t have to be left the way Microsoft supplies it. Fix the Gallery to make it work better for you. Microsoft Office often has menus and options aren’t designed for the customer. Instead they are setup for Microsoft’s needs in ‘out of the box’ demonstrations or to showcase as many choices […]
Rename Word styles or give them alternative names/aliases. Sometimes you’ve got no choice but to make an alias because the original style name is fixed. Any style can have an alternative name which appears in the Style Gallery. That’s a useful trick because there’s limited space for the style name on the Gallery and the […]
Many inbuilt Word styles are hidden until they are used but there’s a way to force hidden styles to appear right away. The most obvious example of ‘Hide until used’ styles are the Heading styles. Word initially shows only the first three headings ‘Heading 1’, ‘Heading 2’ and (drumroll) ‘Heading 3’. Hidden away are Heading […]
Laundry care symbols you see on clothes tags can be typed or inserted into Word, Excel or PowerPoint in various different ways. Laundry care symbols can be for laundry area signs or for fun like this t-shirt. T-shirt seen in a Zurich clothing store Or alternative symbols in a PowerPoint slide. All five symbols were […]
Which font to use if emulating a true laundry care or clothing text label in Word, PowerPoint or other Office program? We’ve already talked about how to put standard laundry care symbols in Word, Excel or PowerPoint but what about the text that usually goes with the icons? In our research we couldn’t find any […]
Microsoft is rolling out a ‘patch’ to Windows 7 which is really a series of annoying ads for Windows 10. The ads are reminders that Win7 support ends in mid-January 2020 as encouragement to buy Windows 10. Here’s how to stop the patch or the ads it installs. See Microsoft starts ‘reminders’ for Office 2010 and […]
Soon Windows 7 and perhaps Office 2010 users will start seeing on-screen reminders that support for the two products is ending with sales pitches for Office 365 and Windows 10. Windows 7 support, including security updates, ends on 14 January 2020. Office 2010 support, according to Microsoft, ends ‘shortly thereafter’. It’s actually 9 months later […]
What can you do when Outlook won’t connect to a new mailbox no matter what you try? Long time Office Watch reader, Phil, found himself with an especially stubborn Outlook which would not connect to his new mailbox. He’s changed Office 365 mail servers so had to reconnect Outlook to the new mailboxes for him […]
Continuing our look at Excel tab/worksheet listing here’s a fully automated alternative with more control and filtering. See Make Excel tabs list in a worksheet Automatic worksheet/tabs list in Excel Fit more tabs across an Excel workbook There are many VBA code samples on the Internet, we’ve taken one we like and added some extras based […]
Does Excel have enough significant digits for Pi in the inbuilt Pi() function? Modern computing can calculate Pi to 3.14 trillion digits which is a good trick but even extreme situations only needs Pi to 15 significant digits. What’s extreme? How about interplanetary travel? JPL/NASA calculate the paths of probes to Mercury, Mars, Jupiter and […]
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 more commonly separate with a […]
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 in Word’s Grammar settings see Sentence […]
An automatically updated list of all worksheets or tabs in Excel but there are ‘gotchas’ which aren’t often mentioned. We’ve already talked about fitting more tabs on the screen or making a manual list of tabs/worksheets. Now we’ll take the next step and make an automatic list of worksheets that will update as the workbook […]
Make your own clickable list of workbook tabs in an Excel worksheet to workaround the small number of tabs that can fit in a single line. See Fit more tabs across an Excel workbook for some suggestions to squeezing more across the single line available. Those suggestions work to make a bit more space available […]
Tabs in an Excel workbook can easily be hidden away on that single line. Here’s some tricks to fit more visible workbooks or workarounds when the tab list is way too long. Here’s the common problem with too many worksheet labels and not enough width. The three-dots at either end are the clue to the […]
A long-standing and unpatched problem in Office provides a stealthy doorway to other security problems in Office with Equation Editor already being targeted. Mimecast discovered an undocumented behavior in OLE (Object Linking and Embedding) which is a doorway into security bugs in Office. It isn’t a security problem on its own, instead it’s a sneaky […]
How to insert the Registered Trade Mark ® currency symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Registered Trade Mark ® not to be confused with the Unregistered Trade Mark ™ symbol Registered Trade Mark ® codes These are the important code numbers or values you’ll […]
Type the Trademark ™ TM symbol into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Trademark ™ TM symbol is, strictly speaking, called the Unregistered Trademark symbol. Its counterpart is the Registered Trademark ® Trademark in Word and Outlook The Trademark ™ sign has an inbuilt shortcut in […]
Let’s look at the basic options for making a Table of Contents (TOC) in a Word document. The basic TOC options haven’t changed for a long time. The look of the dialog boxes and galleries changed with Word 2007 however under those superficial features, the fundamentals are the same. Table of Contents is very easy […]
Like many things in Microsoft Word, there is more than one way to add a PDF file into a Word document. From a simple link to another file to converting the PDF into a Word document. Here’s three ways to add a PDF into your Word document. In most cases you’ll link to a PDF […]
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 link to the PDF and paste it into your document or email. The key question to ask is ‘Where is the PDF located or saved to?’. Next question is […]
Word for Windows has three options for saving a document to a web page, Web Page, Single Web Page or Web Page, Filtered. Here’s a look at all three and how to choose the best option for you. What you choose depends on how much similarity you need between the Word document and the web […]
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 sometimes other currencies like the Chinese Renminbi / Yuan. ¥ symbol is easy on some keyboards but for most there’s no specific key for Yen. Word […]
