Demo: Hide or show rows and columns

Worksheet with columns hidden Demo button

(Or Down 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):

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language