The Verge has been given a look at the next release of Microsoft Office, most likely called Office 2015, and a few of its features. This was a calculated ‘leak’ by Microsoft of selected images in advance of their big ‘Windows 9’ splash on 30 September. We’ve seen these selective leaks too many times before […]
In Windows 8.1 for Microsoft Office users we have an entire chapter on the OneDrive features – the good and the bad. We include the policy and registry settings necessary to disable OneDrive entirely in Windows 8.1. But is it a good idea to entirely remove OneDrive features? Microsoft does ram OneDrive in the face […]
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 […]
Which version of alphabetical order does Microsoft Word use? I thought that alphabetical order was, well, alphabetical order. That’s what I was taught at school and apparently I was taught wrong. There are at least three ways, two used by dictionaries, another by Microsoft and that’s for English alone! Reading Sue Butler’s delightful book ‘The Aitch […]
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 […]
How to quickly insert symbols in Word without taking your fingers off the keyboard. Inserting Symbols into Word documents is a pain, go up to the ribbon Insert | Symbols | Symbol at the very least … or you can use a trick from the 20th century to keep your fingers on the keyboard. Type […]
The Insert | Symbol feature in Office is overdue for an overhaul. Our venture into the new Unicode symbols and symbol fonts highlighted how much work Microsoft needs to do on this part of Office. Insert | Symbol has changed for a long time and many versions of Office. Here’s Insert | Symbol in Word […]
A Windows feature that’s very useful for Microsoft Office users. Character Map has been in Windows for as long as we’d like to remember and it’s done right. Over the years, the ‘softies who’ve worked on it have given some thought to the needs of people trying to find and preview characters. You’ll find Character […]
Microsoft celebrates 25 years of the software suite. Microsoft quietly celebrated the 25th anniversary of their Office suite on 1 August 2014 but were they being a little ‘previous’ in their celebrations? While Word, Excel and PowerPoint for Windows were around on 1 August 1989, were they sold as ‘Microsoft Office’ or only as separate […]
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, […]
A funny example of how you can’t trust the spelling and grammar checks in Word. We laughed at this sign, seen in a Tesco’s supermarket in the UK. Guess what – according to Word 2013 that entire document has no grammar mistakes at all! Even ‘incontinence’ doesn’t get a contextual spelling query. It’s the same […]
Microsoft makes a ‘one stop’ page for the latest Office update details. Figuring out what are the latest updates for Microsoft Office isn’t easy which is why we’re delighted to see Update center for Office, Office servers, and related products from Microsoft. It’s been a long time coming but as Sam Seaborn once said ” Let’s […]
Some great tips on table formatting. Joey Cherdarchuk has a nice posting on a very different table styling to the type that Microsoft prefers. Under the banner ‘Clear Off the Table’ he suggests getting rid of gridlines and colors to simplify the look of tables. In his example, Joey takes a standard Microsoft auto formatted table […]
How Word can warn you about the ‘Oxford’ or serial comma’? The Oxford comma is one of those grammatical things that most people don’t worry about but can get others soooo excited. It’s a question of whether to add a comma at the end of a list for example: Word, Excel, PowerPoint and Outlook OR […]
Access Archon Column #229 – Fixing Normalization Errors Access versions: 2002-2013 Level: Intermediate Introduction Sometimes when you take over an Access database created by an amateur (or at least, someone with a minimal understanding of normalization), you will find data such as employee names stored in a Text field in the Orders table. If the […]
An interesting font idea from Spain – handwriting of homeless people turned into fonts. HomelessFonts.org is a series of fonts based on the handwriting of homeless people. For example, here’s the Francisco font. There are five fonts at present with more promised. Priced per font at €19 Euros for individuals and €290 for companies The […]
How to quickly change web links in Office documents. It’s possible to bulk change web links in Word documents using the Replace, here’s the trick. For example, you might need to change the domain name due a corporate restructure or update links so they are secure (https) instead of regular (http) links. The trick is […]
Another easy way to get images into Word and other Office documents. Last week we mentioned a faster way to get a scanned image into Word via the ‘scan to clipboard’ option available in some scanning software. There are similar options available for copying existing image files into Word, Excel or PowerPoint documents as well […]
Can you scan a picture or document directly into Word? Back in the day, you could click a button in Word to scan a document or image and drop it into a document. Can you still do that? Alas no. Microsoft dropped its imaging services within Windows and so Word lost the scan button. The […]
Finding the location of the Office object model DLL Q: Frank H. writes: “I want to use the FileDialog object to create a browser for selecting a file, but it requires a reference to the Office object library, and I can’t find that library in the list of Microsoft objects. Where is it?” A: For […]
Combine adjacent cells into a single cell or split a cell in two. Welcome to ‘Merge Cells’ where you can combine adjacent cells into a single cell. It’s very handy for table formatting tricks and other unusual situations like a longer than common text label. Or a three row heading like this with various merged […]
Why RE and FW are the best options for email subjects When you reply or forward a message your email program will add a prefix to the subject line. The question is – do you choose the standard ‘English’ prefixes RE: and FW: or your local equivalents? There’s plenty of alternatives to RE and FW […]
Outlook adds holidays from various countries but it’s not very clear or clever about it. Recently we’ve been looking at Outlooks Holiday support. We thought it would a simple matter of clicking ‘Add Holidays’ but instead we found an old-fashioned, unclear and poorly designed system that’s causes lots of hassles and frustration. From File | […]
Should Outlook be adding marketing holidays as well as real ones? The US Holidays list in Outlook 2013 adds some unexpected and non-holiday items to your calendar – the full list is below. There were some surprising entries in the list supplied by Microsoft. Administrative Professionals Day There’s no doubt that Administrative Professionals, Executive Assistants, […]
Best to get the Service Pack now. Despite the ‘retirement’ of Office 2003 and Windows XP, both programs continue to work and all past updates will be available for download from Microsoft. However we suggest that you grab the major updates to Office 2003 now to save yourself hassle and time later. The last major […]
Outlook tricks you may not have considered for New, Reply, Reply All, Forward and Resend. New / Compose The simple and easy one first. Click on the New Email button to start a new message. At the very least fill in the TO, Subject and some message text then click Send. There can be more […]
Some advice on what to do about Office 2003 and Windows XP on the 8 April expiry. Office 2003 Office 2003 won’t stop working on 8 April 2014. There’ll be no more security updates or patches, but the software will continue to work. All past Windows XP patches and service packs will continue to be […]
Why your PowerPoint slides should NOT make much sense … Over on Slate there’s a nice little slideshow about making PowerPoint presentations that don’t bore your audience into a coma. In short, the advice is to make your slides incomprehensible. Well, not quite. The idea is that the slide content should complement or support what […]
Can you use the free Getty images in your PowerPoint presentations? Getty Images, has announced that 35 million of their images are now available free. Does that mean you can use them in your PowerPoint presentations or Word documents? Sadly, no Getty Images is now allowing free embedding to some images in their vast collection. […]
Windows and Office gives you Arial font when you ask for Helvetica. We recently told you about the Helvetica font in Windows and Microsoft Office – or rather it’s noticeable absence. Microsoft plays some strange font substitution tricks that got us digging further. As we’ve noted, if you open up a document with Helvetica formatting, […]
Grab high-res pictures from movies to insert into Office documents or emails. We’ll show you how to capture or grab a proper, full size, high-resolution still image from a high quality video file then paste that picture into an Office document or Outlook email. Why do this? Sometimes a video turns out badly but has […]
Farewell, Mike Parker who brought Helvetica to the mainstream but alas not to Microsoft Windows or Office for Windows. Mike Parker isn’t a household name but the chances are the every household has an example of Helvetica, the font he helped make popular. When he worked for Mergenthaler Linotype Co., Mr Parker added many fonts, […]
A list of Microsoft Office versions and their latest Service Packs. If you don’t have Office 2013, don’t worry, you’re not alone. Here’s a list of the latest service packs for each version of Microsoft Office going back more than a decade. For the recent versions of Office, at least Office 2007 and later, you […]
How to update Microsoft Office with the new name, OneDrive, and remove the old SkyDrive name. Recent versions of Office have the name SkyDrive (with the extra capital letter) in the supplied dictionary. However the new OneDrive name hasn’t made it to the Office dictionary yet. Here’s what you’ll see in a default Word 2013 […]
How to find your pictures to insert into an Office document. Even a simple thing like adding a picture to an Office document or email has subtleties and annoyances. When you choose Insert | Picture in recent versions of Office, it opens, by default, in the Picture Library. That seems sensible, at least to Microsoft. […]
How to get a message when certain RSS feeds are updated As you probably know, it’s possible to get an alert or an action when certain email messages arrive into Outlook using the Rules feature. Office-Watch.com shows how to do the same thing for an RSS feed. It will let you filter down a larger […]
What it really means for Office 2003 users plus a better countdown to the ‘end’ of Office 2003 and Windows XP Microsoft has a countdown to the end of support for Office 2003 and Windows XP in months, days and hours. We could not resist making our own … Microsoft is counting down to midnight […]
2014 looks like the year of long movie titles with colons – here’s how to save yourself some typing. More and more movies are sequels and that means longer and longer movie titles. Most have colons because the studios don’t trust us to figure out that a movie is a sequel. Coming in 2014 we […]
An industrial dispute involving CAPS has ended. One of the most interesting industrial disputes of 2013 has now ended with a new agreement between staff and management of the Melbourne Fire Brigade in Australia. Being an emergency service, the administrative staff didn’t feel that a full ‘stop work’ strike was appropriate so they resorted to […]
