#How to freeze a row in excel how to

When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet. In the Page Setup dialog box, click Sheet tab, and then select the row or column range that you want to print on each page under the Print titles section, see screenshot: 3. Immediately the first row is fixed and you can freely scroll up and down. In our example, since we want the first two rows locked, we have to select row number 3 (row below the one we want to be frozen) and then go to View Freeze Panes Freeze Panes. If you select a cell in the first column, only the rows above it will freeze (no columns). To freeze (or to lock) multiple rows (starting with row 1), you have to select the row below the last row you want frozen, and then use the option Freeze Panes.

Select a cell next to the row and/or column you want to freeze. In order to change the freeze point, you must unfreeze and freeze the cells again. Excel Details: To always display the first row in the Excel table, we click on the top row and then click on View > Freeze Panes > Freeze Top Row. When you freeze panes, the rows above and columns to the left of the active cell are immobilized. Step 2: Go to the View tab, click Freeze Panes > Freeze Panes. Step 1: Select a cell below the last row and to the right of the last column you want to freeze.

#How to freeze a row in excel how to

760How do I freeze/fix column or row headings in Excel? How to freeze rows in Excel, freeze columns in Excel - App New. How to Freeze Rows and Columns simultaneously Excel provides the option of freezing rows and columns simultaneously.