How To Freeze Columns In Google Sheets

You can freeze columns in Google Sheets by selecting the desired column, clicking on the View menu, and choosing the Freeze option.

Google Sheets is a powerful tool for organizing and analyzing data, but sometimes, working with large spreadsheets can be overwhelming. One way to make it easier to navigate through your data is by freezing columns. This handy feature allows you to lock certain columns in place while you scroll, ensuring that important information stays visible at all times. In this blog post, we will guide you through the step-by-step process of freezing columns in Google Sheets, enabling you to work more efficiently and effectively with your data.

How To Freeze Columns In Google Sheets: Step-by-Step


Step 1: Open Google Sheets

To freeze columns in Google Sheets, open the Google Sheets app on your device or go to ‘’ on your browser. Create a new sheet or open an existing one where you want to freeze columns.

Next Step

Step 2: Select the columns

To freeze a column in Google Sheets, simply click on the column’s letter at the top of the page.

Next Step

Step 3: Access the ‘View’ menu

To access the ‘View’ option in Google Sheets, click on the ‘View’ text in the top menu bar. This will open a drop-down menu where you can find various viewing options for customizing your spreadsheet display.

Next Step

Step 4: Select ‘Freeze’

In the ‘View’ menu, locate the ‘Freeze’ option. Hovering your cursor over it will reveal an expanded menu with additional choices and settings.

Next Step

Step 5: Select desired number of columns to freeze

When using this menu, you can choose to freeze either 1 column, 2 columns, or none at all. Selecting ‘1 column’ or ‘2 columns’ will freeze the corresponding number of columns from the left side of your sheet.

Next Step

Step 6: Verify your frozen columns

Once you have chosen the number of frozen columns, they will be highlighted and remain fixed when scrolling horizontally through your sheet in Google Sheets, completing the column freezing process.


Freezing columns in Google Sheets can greatly improve your productivity and enhance the readability of your spreadsheet. By exploring the different options available, such as freezing multiple columns or merging frozen rows, you can tailor your sheet to meet your specific needs. Whether you’re working with a large dataset or collaborating with colleagues, the ability to freeze columns ensures that important information remains in view at all times. Don’t let a cluttered spreadsheet hinder your workflow – take advantage of Google Sheets’ freeze column feature and effortlessly navigate through your data with ease.

Table of Contents