From the course: Help Yourself: Tech Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Excel: Freezing rows or columns

Excel: Freezing rows or columns

From the course: Help Yourself: Tech Tips Weekly

Start my 1-month free trial Buy for my team

Excel: Freezing rows or columns

“

- [Instructor] For monster size worksheets, you might want to keep the top row and left column visible for reference purposes. The technique is to freeze these items, which prevents them from scrolling with the rest of the worksheet. To make it happen click the view tab, and in the window group choose freeze panes. And then to keep the top row from scrolling, choose freeze top row. Now as you scroll the document that top row stays in place. To undo choose freeze panes, unfreeze panes. Likewise for the left column choose freeze panes, freeze first column. And as you scroll that worksheet left and right, that first column stays in place. To freeze both choose the top left cell of the worksheet you don't want to scroll. In this case it would be cell B2, so everything above there and to the left of there would scroll. Choose freeze panes, freeze panes. Now we've locked the top row and left column, so we can scroll, and…

Contents