We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously at hiding things in Word and Excel, and PowerPoint also allows you to hide things, although the approach is a little different. The most common reason to want to hide text on a PowerPoint slide […]
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 can select multiple slides using […]
A new Excel add-in converts an Excel 365 worksheet into a Visio diagram. You don’t need to buy Visio to use the Microsoft Visio Data Visualizer in its simple form, just Excel 365 for Windows/Mac or Online. It’s an interesting tool and worth checking out if you make diagrams or flowcharts. The add-in inserts example […]
The first sign that OneNote 2016 is back from a slow death is the announcement of the first new feature in well over a year. OneNote 2016 is getting a Dark Mode just like the Mac and Apple apps. OneNote dark mode will be an option in OneNote 2016 for Windows but only for Office […]
We have recently discussed how to show hidden formatting characters in Word, but it is also possible to hide text and even images in Microsoft Word, as long as you are using Word on your computer. At this stage, Word Online and Word phone apps don’t allow you to hide text. See Find and Remove Hidden […]
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 their answers. Leaving space where […]
If you want to remove hidden text from your Word document, you first need to find it. For a shorter document, you can use the Show/Hide button to see what’s hidden and delete it manually, but that would be very time consuming for longer documents with lots of hidden passages. Never fear, there are a […]
In Wales, all teachers and their students can get Office 365 free, instead of about ₤60, thanks to an initiative of the Welsh government. It’s worth checking what access to the full Office suite your school, college or university kids might have. The Welsh government has arranged this as part of the HWB scheme that […]
A security vulnerability has been discovered in Excel for Mac. It’s been there for many years and affects Office 365, Office 2019, Office 2016 and Office 2011 for Mac. We have details and suggest a protection you can do yourself. It’s another problem with legacy support for an older Microsoft Office feature. In this case […]
Outlook for Mac also has Profiles to manage multiple setups on the one machine. Though they are managed very differently to Outlook for Windows, the basics are the same on both. To add a bit of confusion, profiles where called ‘identities’ up to Outlook 2011. Outlook 2016 and later for Mac use the ‘Profile’ name. […]
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 + 0 to hide a […]
If you have data in Excel that you don’t want to be visible, but you still need to be able to use it in calculations, there are two ways to hide cells. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are […]
Here are the major marks Microsoft Word displays with the Show All option on. Paragraph Mark, the symbol is called a Pilcrow. It’s the symbol used for the ‘Show All’ button on the Home tab. Line Break, angled arrow pointing left. Tab, a right pointing arrow Space, a dot in the middle of the line Hidden Text, dots under the text. Optional hyphen, line with bend at end. […]
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 years, a different worksheet for […]
Why does Microsoft demand a credit/debit card for Office 365 plans when you’ve bought your annual plans elsewhere, and probably cheaper? As Office Watch readers know, you don’t have to buy Office 365 Home or Personal direct from Microsoft. Microsoft is the worst place to buy or renew Microsoft Office because it’s always the highest […]
A few days ago we told you about a very good deal at Argos in the UK, half-price Office 365 Home. One couple has taken advantage of our tip, and other suggestions from Office-Watch, to get two years of Office 365 for the price of one. One of our readers saw our Office 365 Home […]
Microsoft has started its usual sales campaign to go with the end of support for Office 2010 in a year from now. There are alternatives beyond what Microsoft is selling. In a self-serving blog headed “Support for Office 2010 is ending—get current with Office 365 ProPlus” we see the tiresomely familiar marketing strategy playing out. Encouraging customers […]
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 about Open Authentication but there’s […]
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off of a thought, compared to […]
