28th November 2019


How do I freeze more than one column in Excel 2016?

To freeze rows:
  1. Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3.
  2. On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
  3. The rows will be frozen in place, as indicated by the gray line.

In this way, how do you freeze multiple columns in Excel?

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 frozen, choose the View tab, and then click Freeze Panes.

How do I freeze columns in Excel?

There are two quick steps to freezing or locking rows.
  1. Select the row right below the row or rows you want to freeze. If you want to freeze columns, select the cell immediately to the right of the column you want to freeze.
  2. Go to the View tab.
  3. Select the Freeze Panes command and choose "Freeze Panes."

How do I freeze column A and B in Excel?

Example 1 – How to Freeze the Top Row in Excel
  1. Open your Excel spreadsheet.
  2. Click the View tab on the ribbon.
  3. Double-click the Freeze Panes button.
  4. Click the option Freeze Top Row.
  5. Scroll down your sheet to make sure the first row stays locked at the top.
Write Your Answer


80% people found this answer useful, click to cast your vote.

4 / 5 based on 1 vote.


Press Ctrl + D to add this site to your favorites!