Question

how to freeze rows and columns together in excel

Answer 1

hyy mates

here ur answer

hope this will help you

To lock one row only, choose the View tab, and then click Freeze Top Row.

To lock one column only, choose the View tab, and then click Freeze First Column.

Answer 2

To lock one row only, choose the View tab, and then click Freeze Top Row.

To lock one column only, choose the View tab, and then click Freeze First Column.

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. 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.

To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.

To lock multiple columns, select the column to the right of the last column you want rozen, choose the View tab, and then click Freeze Panes.

.