Freeze Columns In Excel

How to Freeze Multiple Columns in Excel

• Step 1: Click the column to the right of the last column you want to freeze.
  For example, to freeze columns A and B, click on column C by selecting its column letter at the top.
• Step 2: Go to the View tab in the top ribbon.
• Step 3: In the Window group, click Freeze Panes, then choose Freeze Panes again from the dropdown menu.

Result: The selected columns (e.g., A and B) will stay frozen as you scroll horizontally.

Tip: You can also freeze both rows and columns at once by selecting a cell below and to the right of the rows and columns you want to lock.