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

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
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.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Demo: Freeze or unfreeze rows and columns
 

Download the 2007 Office release

Worksheet with column selectedPlay Demo Demo button

(Or Download arrowdownload the demo.)

(You may experience a delay while the demo is loading.)

Navigating a large, complex worksheet with thousands of cells can be a challenge sometimes. The problem is that, as you scroll down, the column and row labels are no longer visible, so it's hard to tell what the data you're looking at refers to. By using the Freeze Panes command in Excel, you can make sure specific rows and columns stay visible while you scroll. Watch the demo to learn how to freeze and unfreeze rows and columns, and make viewing your worksheet a snap.

How to do it (text version):



Assistance Problems watching the video? Try our troubleshooting tips.
advertisement