how to freeze two columns in excel

Freeze Two Columns in Excel: Step-by-Step Guide

By Joseph Thompson
AD

Are you looking to make your Excel data easier to read and navigate? One helpful feature is freezing panes, which allows you to lock certain rows or columns in place while you scroll through the rest of your data. In this guide, we'll show you how to freeze two columns in Excel, making it a breeze to reference your important information while you work in other areas of your spreadsheet.

Before we dive into the steps, it's important to note that this process is slightly different depending on whether you're using a Mac or Windows version of Excel. We'll cover both below, so you can choose the method that applies to your setup.

Freezing Two Columns in Excel on Windows

If you're using Excel for Windows, follow these steps to freeze two columns:

AD
How to Freeze, Unfreeze, and Lock Rows, Columns, and Cells in Microsoft Excel
How to Freeze, Unfreeze, and Lock Rows, Columns, and Cells in Microsoft Excel
How to Freeze Rows or Columns in Excel
How to Freeze Rows or Columns in Excel
Excel Tricks: How to Freeze Rows or Columns in Excel
Excel Tricks: How to Freeze Rows or Columns in Excel

1. Open your Excel spreadsheet and select the column to the right of the ones you want to freeze.

2. Click the "View" tab in the ribbon, then select "Freeze Panes." A drop-down menu will appear.

How to Hide Columns in Excel Without Deleting Data
How to Hide Columns in Excel Without Deleting Data
Freeze and unfreeze columns in Excel
Freeze and unfreeze columns in Excel

3. Choose "Freeze Top Row" to freeze just the top row, or select "Freeze Panes" to freeze multiple rows. Note that this will only freeze one column at a time.

4. To freeze two columns, you'll need to repeat this process twice. Select the column to the right of the second column you want to freeze, and follow steps 2-3 again.

AD

Keyboard Shortcut for Freezing Panes

If you prefer using keyboard shortcuts, you can use the following method to freeze one row or column at a time:

1. Select the column or row below or to the right of the one you want to freeze.

2. Press "Alt + A + F" simultaneously on your keyboard (for Windows).

AD

3. This command will freeze the top row or leftmost column, so use it twice to freeze two columns.

Resetting Frozen Panes

If you change your mind and want to unfreeze the panes, follow these steps:

1. Select the cell where the frozen panes start. In most cases, this is cell A2 or the first column that isn't frozen.

AD

2. Click the "View" tab, then select "Freeze Panes."

3. Choose "Unfreeze Panes" from the drop-down menu. Your spreadsheet will return to its original state, with no frozen panes.

Freezing Two Columns in Excel on Mac

For Mac users, the process for freezing columns is slightly different. Follow these steps to freeze two columns:

1. Open your Excel spreadsheet and select the column to the right of the ones you want to freeze.

2. Click on the "Window" menu in the menu bar, then select "Freeze Panes." A drop-down menu will appear.

3. Choose "Freeze Top Row" to freeze just the top row, or select "Freeze Panes" to freeze multiple rows. Again, this will only freeze one column at a time.

4. To freeze two columns, repeat this process twice, selecting the column to the right of the second column you want to freeze for each step.

By following these steps, you'll be able to easily reference important information in your Excel spreadsheets while scrolling through other data. Keep practicing, and you'll soon master this helpful feature. Happy Excel-ing!

AD