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

 
 
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.

Freeze!


Column titles disappear when scrolling down the worksheet
Callout 1 Column titles in row 1.
Callout 2 Column titles disappear after scrolling down one or two rows.
AUDIO TEXT

Imagine scrolling down the Excel worksheet in the picture. As you scroll, the column titles disappear. Then you wonder, do the numbers in column G refer to Units in Stock, or Units on Order?

In this lesson you'll learn how to keep titles in sight by freezing or locking them in place. That way, after you scroll past the first row or two, you won't have to guess what data refers to or keep scrolling back up the page to see the titles again. In the practice session you'll have a chance to freeze titles for yourself.

  Go to previous page    Next Go to next page
advertisement