Freeze or lock columns and rows in Excel

Sometimes it is difficult to read and understand large tables. When you scroll too far to the right or too far down, you will lose the headlines that are at the top and left of the sheet. Without headers, it’s hard to keep track of which column or row of data you’re viewing.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; Excel for Mac, Excel 365, and Excel Online.

Content
  1. Freeze Rows or Columns in Excel with Freezing Bars
  2. Freeze frame with active cell
  3. Unblock panels in Excel
  4. Freeze top row in Excel
  5. Freeze left column in Excel
  6. Add Freeze Bars to the Quick Access Toolbar

Freeze Rows or Columns in Excel with Freezing Bars

To always see the first column or top row in a spreadsheet, use the Freeze Regions feature in Microsoft Excel. This allows you to always see certain areas or panels of the spreadsheet when you scroll right or down.

When headings or rows are visible on the screen, it is easier to keep track of data as you enter values ​​in other parts of the spreadsheet.

Freeze frame with active cell

When using freeze bars in Excel, all rows above the active cell and all columns to the left of the active cell are frozen in place.

When you scroll through the table, these cells are not moved.

To enable this feature, select the cell to the right of the columns and just below the rows you want to freeze in place.

For example, if you want to keep row 1, row 2 and column A on the screen as you scroll:

  1. Select cell B3 .

  2. Select Vision .

  3. Select To freeze to open the drop-down list.

  4. Select To freeze .

This freezes all rows and columns above and to the left of the selected cell. The status of frozen cells or columns is shown as a dark line below the frozen rows and to the right of the frozen columns.

To lock panes in Microsoft Excel 2010, select Vision > Organize everything > Stop panels .

Unblock panels in Excel

When you freeze rows or columns in Excel and then save the file, the state of the frozen panes is also saved. This means that the next time you open the sheet, those pinned rows and columns will stay in place.

If you don’t want these rows or columns to remain static anymore, unfreeze all rows and columns with the Unfreeze Panes command.

To unlock rows and columns so you can scroll through the entire spreadsheet:

  1. Select Vision .

  2. Select To freeze to open the drop-down list.

  3. Select Defrost panels .

Your table is back to normal. All rows and columns will scroll when you scroll the sheet up and down or left and right.

When multiple people are working on the same spreadsheet, freezing windows can make it difficult for other people to keep track. Use Unfreeze Panels to quickly return the table to normal.

Freeze top row in Excel

To keep the top row visible in Excel, use the Freeze Top Row command. This command stops only the top row of the table, no matter which cell you select. This is usually used when the top row contains header information for all of the data in the spreadsheet.

To freeze the top row in a spreadsheet:

  1. Select Vision .

  2. Select To freeze to open the drop-down list.

  3. Select Freeze top row .

Freezes the top row so you can scroll down as much as you want and still see the top row.

There is no keyboard shortcut to stop the top row in Excel, but you can press multiple keys in sequence to move your keyboard to the top Freeze bar in the menu. Click on alt + W Click f and press R .

Freeze left column in Excel

You can quickly freeze the left column of a spreadsheet with the Freeze First Column command. This command freezes the left column of your spreadsheet no matter which cell you select. This function is useful when the left column contains information about all numbers to the right of it in the worksheet.

To freeze the left column:

  1. Select Vision .

  2. Select To freeze to open the drop-down list.

  3. Select Freeze first column .

This instantly freezes the left column, so you can scroll right as you please, but still see the left column.

To switch to Freeze first column using the keyboard, press alt + W Click f and press C .

Add Freeze Bars to the Quick Access Toolbar

If you frequently use the Freeze Panel function in Excel, you can add all the freeze commands to the Quick Access Toolbar.

The Quick Access Toolbar is located above the Ribbon, at the very top of the Excel window. This gives you quick access to the commands you use most often.

To add freeze bars to the Quick Access Toolbar:

  1. Select File .

  2. Select Options to open the Options dialog box.

  3. Select Quick Access Toolbar .

  4. In the list, select “Select commands from a list” To freeze .

  5. Select To add to add freeze bars to the list on the right.

  6. Select OKAY.

Freeze bar icon added to Quick Access Toolbar. When you select this icon, you will see the three window freeze commands described in this article.

Leave a Reply

Your email address will not be published. Required fields are marked *