Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Icon: Flag: (c) Microsoft
Get up to speed
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Demo: Hide or unhide rows and columns
 

Download the 2007 Office release

Worksheet with columns hiddenPlay Demo Demo button
(Or Download arrowdownload 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.
advertisement