How To Freeze Multiple Columns In Excel

To freeze multiple columns in Excel, select the column to the right of the last column you want to freeze, go to the “View” tab, click on “Freeze Panes” and select “Freeze Panes” from the drop-down menu.

Excel is a powerful tool that provides numerous functionalities for organizing and analyzing data. One of the handy features that can greatly improve your productivity is the ability to freeze multiple columns. This feature allows you to keep certain columns visible on the screen while scrolling through large datasets, making it easier to compare and analyze data without losing important context. In this blog post, we will explore how to freeze multiple columns in Excel, providing you with step-by-step instructions to master this useful feature. Whether you are a beginner or an experienced user, this guide will help you streamline your workflow and make the most out of Excel’s capabilities. So, let’s dive in and learn how to freeze multiple columns in Excel!

How To Freeze Multiple Columns In Excel: Step-by-Step


Step 1: Open Your Spreadsheet

To access the desired Excel spreadsheet, locate the file on your computer or cloud storage, and open it using the Excel software application.

Next Step

Step 2: Select the Column

This action allows you to freeze the columns on the left side of your spreadsheet, keeping them visible as you scroll horizontally, providing a convenient way to compare data in the frozen columns with the rest of the sheet.

Next Step

Step 3: Open Freeze Panes Options

Click on the “View” tab at the top toolbar. In the view toolbar, locate and click on the ‘Freeze Panes’ option to access the Freeze Panes menu.

Next Step

Step 4: Click on Freeze Panes Option

From the Freeze Panes drop-down in your spreadsheet software, locate and select the ‘Freeze Panes’ option. This will allow you to freeze certain rows or columns in your sheet for easier scrolling and reference.

Next Step

Step 5: Freeze Effect

By freezing your columns, like A and B, you can scroll horizontally without losing visibility of your selected columns.


In conclusion, freezing multiple columns in Excel can greatly enhance your data analysis capabilities. By being able to scroll through large datasets without losing sight of important column headers, you can save time and improve accuracy in your work. Whether you’re comparing data, performing calculations, or simply organizing information, the ability to freeze multiple columns is a powerful feature that every Excel user should take advantage of. So go ahead, give it a try, and see how it can revolutionize your spreadsheet experience. Happy freezing!

Table of Contents