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 —
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again 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
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You
OneNote for Windows has a better future after some reverse-course announcements from Microsoft. OneNote desktop program gets extended life and a promotion. The desktop and app versions merging into a single codebase. We’ll also explain the strange case of two OneNote for Windows. The announcements amount to a 180° reversal
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control
The Microsoft Whiteboard app can now import pages from Word documents or selected slides from a PowerPoint deck. The new feature is better than it’s promoted because you can select pages/slides not just entire documents or decks. Start from the Insert menu where there are now options for Word document
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of
A new Windows 10 bug patch has some fixes for Microsoft Outlook. Microsoft’s documentation is typically brief, so we’ll fill in some details. The time zone changes are too late to help some customers … why? KB4520062 has many Windows 10 fixes but a few affect some Outlook users and
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know
Outlook on the web is now blocking another 38 email attachments because they can be carriers of viruses. But Microsoft doesn’t block the most commonly used files for infecting computers. Far and away the most common infected email attachment is old-style Word documents, with .doc extensions. Excel .xls worksheets and
As we suspected, there are more holes in the Office Document Inspector. Our clever readers came up with some possibilities for revealing secrets in documents, worksheets and presentations. Document Inspector is good but could be better. As you’ll see, there really should be a warning about objects with multiple layers.
PowerPoint has many choices for printed/PDF handouts to go with a presentation. Here’s a guide to the options spread in different places on the PowerPoint ribbon and menus. Quick PowerPoint Handouts Under File | Print is the basic handouts option to print slides and lines for people to handwrite notes.
While printing PowerPoint handouts for your audience with just the slides can be useful, sometimes you may want to give them your notes as well as the slides, which is where Notes Print comes in. Contrary to its name, Notes Print includes slides as well as your notes underneath them.
Handout Master lets you customize your presentation handouts more than the basics; changing the position and formatting of headers/footers, adding a background color or gradient. Maybe you can help uncover some unexplained mysteries of Handout Master, see below? Our Quick PowerPoint Handouts article showed you how to go to File
There are many ways to make a paper/PDF version of a PowerPoint slide deck, this is the quick ‘only a few clicks’ option. There are other choices that we’ll cover in upcoming articles. PowerPoint has some ‘Handouts’ features but they aren’t all in the same place and some aren’t even
The venerable SUM() function in Excel is simple, really too simple. It just adds up a range of cells with no way to filter or limit what’s included. SumIF selects what to add-up from a longer list. SumIf sometimes confuses people because they, understandably, expect the range to be SUMmed
The long-standing Ursnif trojan is back in a new form to infect computers and steal personal information, all via a Microsoft Word document. To begin, we’ll repeat a warning we’ve been making for years … No .doc files DO NOT open .doc files from any source (not .xls or .ppt
There are two similar text formatting options in Excel. The well-known Merge & Center and the hidden away Center across selection. Both have their advantages, the choice is yours. Merge & Center Most Excel users know ‘Merge & Center’ because it’s atop the Merge list at Home | Alignment |
