Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Freezing Rows and Columns

You might create worksheets that are so large that you cannot view all your data on the screen at the same time. In addition, if you have added row or column labels and you scroll down or to the right, you’ll lose sight of your labels and which data field you’re reviewing. For example, if you are reviewing sales data in columns E and F, it would be nice to see the row title of the cells you are referencing. To help, you can freeze the heading rows and columns so that they’re always visible.


circle_1.jpg Click in the cell below the row you want to freeze.

circle_2.jpg On the View tab, click the Freeze Panes command.

circle_3.jpg Click Freeze Top Row. At this point, you will be able to scroll down and still see the first row of your data table.

circle_4.jpg To unfreeze the panes, go back to the Freeze Panes command and click the Unfreeze Panes command.

  • + Share This
  • 🔖 Save To Your Account