- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
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.
Click in the cell below the row you want to freeze.
On the View tab, click the Freeze Panes command.
Click Freeze Top Row. At this point, you will be able to scroll down and still see the first row of your data table.
To unfreeze the panes, go back to the Freeze Panes command and click the Unfreeze Panes command.