Freezing rows and columns in spreadsheets

When a spreadsheet is very long or wide, you can freeze table headers or other contents and make them visible on the screen all the time by using the Freeze Rows and Freeze Columns commands.

About this task

You cannot freeze columns that contain only part of a merged cell. In addition, images and charts that span the frozen area and unfrozen area are hidden. To freeze or unfreeze rows or columns, do one of the following: