You can sort paragraphs, lists and tables in a Word document with all manner of tricks available under the simple ribbon button. Following our look at different alphabetical orders, here’s a look at the sorting options in Word. Select the list or paragraphs then choose Home | Paragraph | Sort.
It is possible to add videos to a PowerPoint Kiosk or self-running presentation. Recently we’ve talked about Self-running of kiosk display in PowerPoint as well as the related PowerPoint Photo Album feature. But what about video’s? You can add videos to a PowerPoint presentation, you’ve been able to do that
How to make an Excel chart that changes as you add more cells or rows is really simple these days. Forget all the old stuff about named ranges or changing the Chart data. Setup your Excel list correctly and any linked charts will update automaticall. In a recent article we
Getting started with Word’s footnotes and endnotes. Footnotes is one of those Word features that’s been around for a long time and so it often ignored in all the hoopla about new features. In this article we’ll have a close look at Footnotes and Endnotes. In Word there are Footnotes
Microsoft Word’s ‘Pickup where you left off’ or ‘Welcome back’ message is different from the Shift+F5 shortcut. All the recent talk about the ‘Pickup where you left off’ feature in Word had a few Office-Watch.com readers asking how it’s different from the long-standing GoBack shortcut in Word – Shift +
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
The latest updates to Office for iPad are good for Microsoft marketing but not existing customers. Microsoft has just released updates to their Office for iPad apps (Word, Excel and PowerPoint for iPad). What’s new and fixed for Office 365 customers? Nothing …. If you’re already an Office 365 renter/subscriber
Dropbox plays ‘catch up’ on OneDrive and Google but still lose the cloud storage lead. And there’s a competitor that might beat them all. Dropbox has announced price decreases / storage increases to match offerings from Microsoft and Google. The lowest level of paid Dropbox is ‘Pro’ for $9.99 a
The last man on the moon is missing from Microsoft Office. Let the conspiracy theories begin! The last man to walk on the moon, Captain Eugene Cernan, is a notable omission from the Microsoft Office dictionary. Update: as of November 2015 we’re delighted to see that Gene Cernan is now
When the August 2014 update was finally released it disappointed in more ways than one. Oh dear, for all the hype, rumor and promise of the Windows 8.1 update, it turned out to be a damp squib. The feature additions were not as interesting as Microsoft strategic leaking led us
Microsoft adds the Ruble symbol to Windows 8.1 and we show you how to add it to earlier versions of Windows. Part of the Windows 8.1 August 2014 update is the addition of the new Russian Ruble currency symbol. All Microsoft will say about this change is “This feature adds
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
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
Forget the Romans … what use is a smartphone? The Guardian has an interesting article “From cameras to keycards, everyday devices killed off by the smartphone”. It could read like a scene from Life of Brian titled: “What have smartphones ever done for us?” “Well, aside from mobile phones, landlines,
Microsoft needs to play ‘catch up’ with email encryption. Yahoo is going to join Google is supporting not just email encryption but the same type of email encryption. Sadly we’ll have to wait until sometime in 2015 for Yahoo to release their version of OpenPGP. That’s good news … but
Some programs let you email documents directly – here’s now. Microsoft Office for iPad has an ‘Email as attachment’ as one of its limited options for sharing a document. Here’s some clever ways to make use of that and workaround the Office for iPad limitations. Some cloud services offer an
Updates now available free for our popular Windows 8.1 and Office for iPad ebooks. We’re pleased to tell you about TWO free updates to our ebooks that are now available. Free updates are just one of the unique benefits of Office-Watch.com ebooks. Office for iPad: The Complete Guide A third
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
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
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
The two procedures will let you easily clear up redundant Word documents, and alphabetize lists of declarations. Access versions: 2007-2013 Level: Intermediate Introduction The two procedures described in this article will let you easily clear up redundant Word documents, and alphabetize lists of declarations. When working on the 3rd edition
Microsoft confirms Office across devices, including Android. There has been plenty of unquestioning press reports from the Microsoft Worldwide Partner Conference 2014. Statistics and commitments are quoted without much consideration for their worth. The good news is another commitment to Microsoft Office ‘cross platform’ meaning, for the moment, not just
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
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