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.
Word
Hidden Text, Images and objects in Word
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.
Hidden text positioning and formatting tricks in Word
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.
Find and Remove Hidden Text in Word
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 …
Show Hidden Characters in Word with Show All
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.
Excel
Hiding Columns and Rows in Excel
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.
Hiding Cell Contents or Formulas in Excel
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
PowerPoint
Hide 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.
Hiding Text in PowerPoint
PowerPoint has options for hiding slides and also hide & reveal text or content within slides.
