Hiding stuff in Word, Excel and PowerPoint


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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 images and objects in word microsoft office 32253 - Hiding stuff in Word, Excel and PowerPoint

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 columns and rows in excel microsoft office 31983 - Hiding stuff in Word, Excel and PowerPoint

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.

hide a powerpoint slide microsoft powerpoint 32373 - Hiding stuff in Word, Excel and PowerPoint

Hiding Text in PowerPoint

PowerPoint has options for hiding slides and also hide & reveal text or content within slides.

subs profile e1563205311409 - Hiding stuff in Word, Excel and PowerPoint
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address