The Office Watch “Shortcut of the Week” tips for Outlook, Excel and PowerPoint from 2005 in the one convenient place. Tip 1 – Outlook navigation The Outlook navigation shortcuts could be more intuitive but here they are: Switch to Mail CTRL+1 Switch to Calendar CTRL+2 Switch to Contacts CTRL+3 Switch
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 type Ghana Cedi currency character in Windows or Office, especially Word. After our article about inserting Numero and other symbols into Office – trust an Office Watch reader to find a character not available in a supplied Windows / Office font: ” The currency in Ghana is the
Excel’s Unique() function itself can’t show distinct values that appear more than once in a list. Repeated only items in a distinct list are possible with a simple extended formula. We’ve already shown the basics of Unique() either getting a list of Distinct values or values that only appear once
=Rand.old() is a Word trick which adds common sentences that use all, or most, of the letters in that language’s alphabet. Here’s what Word does in English, French, German, Danish, Polish and many other languages. It’s useful filler text for testing formatting or other Word features just like “Lorem Ipsum
Re-creating the “Don’t be a Spock” sign in Word wasn’t hard especially since the original sign seen at the laboratory was probably made in Microsoft Word. Here are some comments on the design. The standard Arial font was used throughout. The two images and captions are in a 2 x
How to use AutoCorrect for more than a word or single character. It can speed up typing of large blocks of text or expanding an acronym into the full name. Paul G writes: “Autocorrect is fantastic for the numerous standard letters, or specific instructions for various computer actions (downloads, etc).
Excel’s Sparklines have a good range of options for highlighting high and low values, text or calculated overlays, changing axis and handling blank or zero values. Sparklines are in Excel for Windows and Mac. Excel Mobile (iPhone, iPad, Android) shows existing Sparklines made elsewhere but they can’t be changed, only
A strange name but Sparklines is a useful new part of Excel which makes simple single-cell graphs in Excel for Windows or Mac. Mea Culpa – we thought that ‘Sparklines’ was a fancy name made up by Microsoft after a long liquid lunch … Office Watch readers, John F, Nick
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter Deegan has been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost quite beyond
Hiding footnotes in Word triggers an annoying bug that’s been there for at least ten years. There’s no sign of it being fixed. While looking into Footnotes and Endnotes in Word for Office-Watch.com we came upon a strange bug. Anyone trying to hide the footnotes in a document will strike
When Outlook displays a ‘This will be permanently deleted’ it’s not really deleted. For anyone interested in the gory details or testing themselves, here’s how we checked that out. It’s standard database procedure for a deleted record simply to be flagged ‘deleted’ rather than fully erased or overwritten. Tagging as
We’re delighted to announce a timely update to Beating Bots, Spies & Cock-ups All about safely and securely sending files and documents. Keeping your personal and business information private on the Internet. suits Windows and Mac, Office 365, Office 2019, Office 2016 and earlier New! April 2020 The April 2020
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 +
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
SoftMaker’s FreeOffice 2018 has received a major revision. Possibly borrowing from Microsoft, the July 2019 release is called the Anniversary update. A few years ago, Windows 10 got an ‘Anniversary’ update. Anniversary of what was never made clear and didn’t seem to matter. Some of the interesting features in FreeOffice
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
One of the first major Word viruses, the Melissa virus, is 20 years old. It’s amazing to see how much and how little has changed over two decades. Office viruses today follow much the same pattern as they did back in the 20th Century. Melissa was a Word macro virus
Thanks to everyone who tried out Microsoft Forms by filling out our example survey. Here are the results. Our form was mainly an example of what’s possible in Microsoft Forms as part of Microsoft Forms – a quick look and sample We took the opportunity to get a better idea
An embarrassingly simple security breach in Microsoft account logins (including Office 365) has been fixed but it took Microsoft way too long to do anything. It was possible for someone to take over the logins of Microsoft account users to get login details including passwords. There’s over 400 million Microsoft
Microsoft has re-released the October 2018 update to Windows 10 after (hopefully) fixing the bug which deleted some customers vital files. The October 2018 update problem was caused by changes to Known Folder Redirection or KFR which we’ll explain below. Windows 10 October 2018 update – take two The Windows
New Zealand is getting some unfair bad publicity after a change in their laws which allows Customs officials to ask for the passwords to access computers or devices brought into the country. Customs officials all over the world can usually search anything you bring in and that includes password protected
Microsoft’s Project Natick now has two live camera feeds showing fish around their underwater data centers. One of the big problems for server farms is heat. All those computers generate a lot of heat that must be dissipated somehow. Microsoft’s servers store your OneDrive files, Azure data, run Office cloud
A North Carolina woman and her son are accused of sharing their discounted Microsoft Office access with her ex-husband, a clear breach of the Home Use Program. Source: WLOS, “your Western Carolina News Leader” We’ve been talking about the Home Use Program for many years. It’s a heavily discounted Microsoft
Like almost any web site, we use technologies like cookies to store and/or access device information. We aim to keep that to a minimum. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. We apologize for this box but it's legally required in some regions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.