There is a way to make a shortcut or menu button to jump directly to the Find dialog box, as compared to the Navigation pane which is now the default for Ctrl + F. Thanks to all the Office Watch readers who sent in the tip including: Karen, Ron, Geoff, Calvin and Alice. Also thanks […]
When you type or paste a web link into Office, it normally converts it into a web link automatically. But occasionally that feature doesn’t work right. We found one example when researching the famous artist Roy Lichtenstein and one of his best known works. Click on the image to see the Wikipedia article about Whaam! […]
As part of the Outlook for Mac release, Microsoft has indicated their Office for Mac plans. A new Office for Mac (Office 2015 for Mac?) will be released in the second half of 2015. Office 365 subscribers/renters will be able to switch to the new Office for Mac at no extra charge. There will also […]
Outlook has had a Categories feature for a long time … here’s how you can use it and why. Categories let you group Outlook items (emails, contacts, calendar and tasks) into broad topic areas or subjects … all without moving from their original folders. They can be subjects that a normal Outlook search could not […]
WinBeta is reporting that emails are going out to people who qualify for the next step in Office software testing. This marks a major step in the progress to yet another version of Office. A few months ago Microsoft asked people to ‘indicate interest’. Now they appear to have culled those requests and sent emails […]
While Microsoft Word lumbers along, there’s some interesting and genuinely creative word processors out there. We’re not talking about direct rivals to Microsoft Office 2013 like OpenOffice, LibreOffice, Kingsoft Office Free, Google Docs, iWork or earlier versions of Office. Instead we’ll look at software that takes a very different approach to putting words on the screen […]
Microsoft has made it easier for students to get a free copy of the Microsoft Office suite with a major streamlining of their existing Student Advantage program. How to get the free Office The student (13 years and older) has to be enrolled at a school which has MS Office licenced for all faculty and […]
Choosing the sort type is really important and Word doesn’t always guess correctly. Office-Watch.com reader Peter M. reminds us that choose the sort type is really important: Text, Number or Date. “I just thought it worth pointing out that, for example 8, 70, 600 would sort in one order as Text and the reverse order […]
How to sort a list using a hidden or unseen list in Word. Sometimes you want to sort a list in a way that isn’t apparent to the reader. To continue our Apollo theme, here’s a list of the twelve men who walked on the moon with the order they stepped onto the surface. To […]
You can hide a column in Word, all it takes is a little trickery. Sometimes you want to hide a table column in a Word document but according to Microsoft you can’t do it. Here’s how to do it anyway. It’s true that there’s no explicit ‘hide column’ option like in Excel but you can […]
In-depth and clever tricks with sorting in Word. Following our look at different alphabetical orders, here’s a look at the sorting options in Word. You can sort paragraphs, lists and tables in a Word document. Select the list or paragraphs then choose Home | Paragraph | Sort. For tables there’s similar sort options are at […]
Why Excel PivotTables get messed up and how to stop it. Time and again we’ve heard from people who try PivotTables and only get nonsense tables. That’s understandable since Microsoft’s hype about PivotTable ignores the basics that we’ll cover in this article. You’ve probably seen a Microsoft demonstration of PivotTables where it looks sooooo easy. […]
How to add and remove data from a PivotTable. Thanks for the great feedback from our article on PivotTables. One concern some of you have is about adding or removing source data after the PivotTable has been created. That’s understandable because the original PivotTable releases where unclear and curiously sensitive about the data ranges used. […]
Quickly insert symbols, characters and emoji in Microsoft Word without taking your fingers off the keyboard. Inserting Symbols into Word documents is a pain, go up to the ribbon Insert | Symbols | Symbol which takes time … or you can use a trick from the 20th century to keep your fingers on the keyboard. […]
A simple, practical and non-scary example of how Excel PivotTables can work for you. Excel’s PivotTables are a great feature but one that seems way too hard for most of us … so here’s a simple and practical example of how PivotTables can help. A little fear of PivotTables is understandable. It’s one of those […]
Word: how to find the character code used for a particular letter or symbols. Last week we talked about the Unicode v7.0 symbols and how to use symbols in Word. With over 100,000 characters in the Unicode specification, it’s important to know the character code number for the symbol you want. That raises the question, […]
How can you get the new Unicode symbols in Office documents? There’s plenty of new symbols included in the Unicode 7.0 standard, here’s how to get them into your Office documents. Most fonts do NOT have all the Unicode characters, after all, there are over 133,000 of them. There are far too many characters so […]
A guide to getting more life and value from your printer. The Guardian has a nice little guide to maintaining an inkjet printer and saving money. We’ve never had good experiences with recycled ink or toner cartridges and have always found their quality to be poor. But others swear by recycled/refilled cartridges so if you […]
Plenty of free ebooks about Office 2013, Office 2010, Office 365 and more. Microsoft has released another 130 free ebooks for anyone to download. It includes titles about Windows 8, Office 2013, Office 2010 and Office 365. A list of the Office related titles with links is below. Free ebooks should be enough to boast […]
How to get the World Cup schedule into Outlook automatically. The football/soccer World Cup is about to start with 64 matches being played over the next month. Here’s how to get a reliable schedule into your Outlook calendar quickly and easily. Outlook lets you import an Internet feed of calendar items. This is better than […]
