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.
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.
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.
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 …
If you are working on a Word document with complex formatting, sometimes you need to see the hidden characters and unseen workings. It helps figure out what’s going on when the layout doesn’t behave.
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.
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
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.
PowerPoint has options for hiding slides and also hide & reveal text or content within slides.