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 […]
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 […]
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 […]
Type or enter the ° Degree symbol into Microsoft Word, Excel, PowerPoint or Windows programs generally. Degree ° is a common symbol and should be available in most fonts. If not, try another font or one of the fonts with a very wide range of characters like Arial Unicode MS or Ludica Sans Unicode. Typing […]
If the Translation options in Microsoft Office don’t do it for you, try the Google Translate full document translation option instead. For a long time, Google has a word and text translation between languages. The app is a godsend to travelers around the world, and the locals dealing with them! Entire Office documents can also […]
There’s a simple Microsoft Word trick that lets you shrink the vertical space between lines. Reducing below single line spacing. To set less than 1 line space go to Paragraph | Line Spacing and choose ‘Multiple’ – yes ‘Multiple’. Sounds screwy but it works. Set the Multiple line spacing value to less than one eg 0.7 […]
Pantone has announced its Color of the Year for 2019 but before you run off to grab color swatches, here’s how to get it in Microsoft Office – Word, Excel, PowerPoint etc. The color of 2019 is <drum roll> ….. Living Coral … As usual what’s more amazing than the color is the description from […]
Microsoft Word can print the selected parts of a document, not just the whole document, Select the part of the document you want to print. Word won’t let you print separated selections (made using the Ctrl key). Go to File | Print (or Ctrl + P) and from the Settings list choose Print Selection. The […]
A judgement from the US Court of Appeals turned on the Word Count feature in Microsoft Word and how it differs from the rules for court submissions. Most courts have rules about the length of submission which, in this case, were accidently exceeded. The plaintiff is representing himself (‘pro se’) so the judge was more […]
We already talked about the Microsoft Word ‘Shrink One Page‘ feature and its limitations. Here’s suggestions for how to move a few orphaned lines from the top of a page in more subtle and effective ways. Obviously, every document is different so the tricks you use depend on the situation. Pick and try from this […]
A new report from Sophos shows how hacking via Office documents has changed of lot in 2018 with new attacks coming much faster than in the past. Microsoft’s assurances that a security bug (sorry ‘exploit’) hasn’t been used ‘in the wild’ doesn’t mean a lot. Office document hacks made in bulk The people who find […]
Here’s how to add a keyboard shortcut for any Microsoft Word style including Headings and Normal style. A shortcut is faster than clicking on the ribbon anytime you want to apply a style. For commonly used styles it’s easier and faster to use a keyboard shortcut. Microsoft even supplies a few with Word, but not […]
There’s a little trap in Excel when figuring out the number of days between two dates. Excel has one way, but the real world has two others. It’s easy to forget the differences, in fact we forgot it ourselves in the Schenghen Visa Calculation. This article is part explanation, part warning and part mea-culpa. How […]
How to type the degree symbol (Fahrenheit, Celsius, Kelvin, latitude, longitude) into Microsoft Word, Excel or PowerPoint. Degree Symbol codes Decimal: 176 Hex: 00B0 Web: ° ° ° Word The degree symbol ° has an inbuilt shortcut in Word. Ctrl + @ or Ctrl + Shift + 2 followed by a space will enter a […]
Back in 2002 I wrote an Access Archon article dealing with reference issues, among them the problem of certain references being upgraded when a database is opened in a higher version of Access, but not downgraded when it is again opened in a lower version. You might think that over the last 16 years Microsoft […]
While North Korea’s leader, Kim Jong Un, was busy in Singapore, his government hackers were busy with new malware called TypeFrame and delivered by, you guessed it, a Microsoft Word document. Typeframe has eleven different elements bundled with a Word document. As usual, the hackers send the document and try to trick people into running […]
It’s time again to put the mighty brains and resources of Microsoft against the best and brightest of American youth. Yet again, the kids put Microsoft Word to shame. Each year, Office-Watch.com get the word lists from the finals of the US Scripps National Spelling Bee and runs them through the Microsoft Word dictionary. There’s […]
Your deadline is in four hours, you’ve got pages to write and BAM! the ‘M’ key breaks on your keyboard …. What do you do? That happened to Colin Chambers, a University of Buffalo student when a drink spilled on his keyboard and as he put it: “The letter between “L” and “N” in the […]
Empty or unwanted pages just after a Word table are especially annoying. Trying to select anything after the table can be difficult unless you know the tricks. Here’s the common problem in Word. A table goes to the end of a document or section but another empty page is added. Clicking Home | Paragraph | […]
