freeze only columns a and column z in google sheets
Searching Internet đ
Unfortunately, Google Sheets does not support freezing non-adjacent columns, such as columns A and Z. The freeze functionality allows you to only freeze contiguous columns or rows. This means that if you want to keep certain columns visible while scrolling, you must select a continuous range of columns rather than skipping columns in between.
To freeze columns in Google Sheets, you can follow these general steps:
-
Open Your Spreadsheet: Start by accessing your Google Sheets document.
-
Select a Column: Click on the letter header of the column that is immediately to the right of the last column you want to freeze (for example, if you want to freeze column A, click on the header of column B).
-
Access the View Menu: In the top menu, click on "View".
-
Choose Freeze Option: Hover over the "Freeze" option in the dropdown menu and select "1 column", "2 columns", or âUp to current columnâ, depending on how many you want to freeze.
For further information, you might find the official Google Help page useful, which explains how to freeze rows and columns here. Additionally, you can explore community discussions and examples in forums like Reddit for more context on handling data in Google Sheets.
In conclusion, if you need to keep both column A and column Z visible, youâll have to find an alternative approach, such as arranging your spreadsheet differently or using a filter to manage your data effectively, since the functionality to freeze non-adjacent columns is not available.
Sources

:max_bytes(150000):strip_icc()/001-how-to-freeze-and-unfreeze-rows-or-columns-in-google-sheets-4161039-a43f1ee5462f4deab0c12e90e78aa2ea.jpg)
Related Questions
Work fast from anywhere
Stay up to date and move work forward with BrutusAI on macOS/iOS/web & android. Download the app today.