Demo: Hide or show rows and columns

Worksheet with columns hidden Play Demo Demo button

(Or Download arrow download the demo.)

You may experience a delay while the demo is loading.

Are you fighting your way through the clutter of a huge worksheet with thousands of data entries, trying to get at the specific data you need to analyze? In Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This demo shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.

How to do it (text version):

Assistance Problems watching the video? Try our troubleshooting tips.

 
 
Applies to:
Excel 2007