can i freeze first two rows in excel spread sheet

With the proper cell selected, select the “ View” tab at the top and click on the “ Freeze Panes” button, and select the “ Freeze Panes” option in the drop-down.

For example, if you wanted to freeze column A and row 1, you would select cell B2 since it’s below and to the right of these columns and rows.

To freeze a set of columns and rows at the same time, click on the cell below and to the right of the panes you want to freeze.

“ Freeze First Column” will freeze only the left most column no matter what column you currently have selected.įreezing a column and a row at the same time is a bit trickier unless you only want to freeze the left column and the top row, since those options are there all the time.

“ Freeze Panes” will freeze all columns to the left of your selected column.With the column selected, click on the “ View” tab at the top, select “ Freeze Panes” and you’ll see several different options you can choose:.To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze.Note: If you don’t see the “Freeze Panes” option, it might be because you already have panes frozen. “ Freeze Top Row” will freeze only the top row no matter what row you currently have selected.“ Freeze Panes” will freeze all rows above your selected row.

With the row selected, click on the “ View” tab at the top, select “ Freeze Panes” and you’ll see several different options you can choose:.To select a row, you need to select the entire row on the left side. Select the row below the row you want to freeze.

Can i freeze first two rows in excel spread sheet