How do I freeze multiple columns and rows in Excel at the same time?

Freeze rows or columns

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.

How do I freeze both the top row and first column in Excel?

To freeze the top row or first column:

From the View tab, Windows Group, click the Freeze Panes drop down arrow.
Select either Freeze Top Row or Freeze First Column.
Excel inserts a thin line to show you where the frozen pane begins.

How do you freeze rows and columns at the same time in a spreadsheet?

To pin data in the same place and see it when you scroll, you can freeze rows or columns.

On your computer, open a spreadsheet in Google Sheets.
Select a row or column you want to freeze or unfreeze.
At the top, click View. Freeze.
Select how many rows or columns to freeze.

How do I freeze the first row and column?

To freeze the first row and column, open your Excel spreadsheet. Select cell B2. Then select the VIEW tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Window group. Then click on the Freeze Panes option in the popup menu.

How do I freeze 4 columns in Excel?

Freeze columns and rows

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Select View > Freeze Panes > Freeze Panes.

How do I freeze the top row and first column in Excel 2020?

On the View tab, click Normal.

Freeze the top row. On the View tab, click Freeze Top Row.
Freeze the first column. If you’d rather freeze the leftmost column instead, on the View tab, click Freeze First Column.
Freeze as many rows or columns as you want. Want to freeze multiple rows and/or columns?

How do I freeze 5 columns in Excel?