Freeze One Row Of Cells In Excel For Mac

Now when you scroll down, you should still continue to see the column headings.Range1,range2rangen is the range of cells you wish to subtotal. Then click on the Freeze Top Row option in the popup menu. Select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. To freeze the top row, open your Excel spreadsheet.

This means that no matter where you scroll in the spreadsheet, those rows or columns always stay visible.For example, locking the row of column headings keeps the categories visible as you navigate through the worksheet. (A and 1)One small feature that makes it easier to manage all of that data is the ability to freeze rows and columns. This will automatically freeze and lock the very first row and column in your document.

You will want your cursor to be below the row (s) you want to freeze and to the right of any column (s) you want to freeze.Along with the freeze feature in Excel is a lock option. To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. To lock one column only, choose the View tab, and then click Freeze First Column.

Freeze One Row Of Cells In Excel For Mac