Office 2016 For Dummies
Book image
Explore Book Buy On Amazon

One problem with creating large spreadsheets in Excel is that your identifying row and column headings may scroll out of sight if you scroll down or to the right of your worksheet. To prevent this from happening, you can "freeze" a row or column that contains identifying labels. That way, when you scroll through your worksheet, your frozen row or column always remains visible.

To freeze a row or column in an Excel worksheet, follow these steps:

  1. Click the View tab.

  2. Click the Freeze Panes icon in the Window group.

  3. Click one of the following:

    • Freeze Panes: Divides a worksheet into multiple panes

    • Freeze Top Row: Always displays the top row, no matter how far down you scroll

    • Freeze First Column: Always displays the first column, no matter how far to the right you scroll

To unfreeze a row or column, repeat Steps 1 through 3 but click Unfreeze Panes in Step 2.

About This Article

This article is from the book:

About the book author:

Wallace Wang has written more than 50 computer books and has more than three million copies of his previous For Dummies books in print, including Office 2013 For Dummies and Beginning Programming All-in-One For Dummies. A veteran teacher, writer, and game designer, he's also done stand-up comedy.

This article can be found in the category: