In our example below we are freezing the first three columns. Simply drag the border of the top right box across to the end of the last column you want to freeze. You can also use the mouse method to freeze more than one column in a Google Sheet. If you scroll horizontally the first column remains on screen. The first column in your Google Sheet is now frozen.
When hovered over the right hand border click your left mouse button and drag the border across to the end of the first column border. Now move your mouse over the right border of this square. Hover over the top left square above the first row number. There are two ways to achieve the same objective: Method 1 – Using the mouse In our example we have a Google Sheet with some sales data and we wish to freeze the first column, which contains dates, so when we add more columns of data the first column remains static as we scroll horizontally. We will assume you have a Google Sheet ready and you would like to freeze one or more columns in the Google Sheet. The most frequent use for freezing columns is to freeze the first column so any row titles that may be in the first column remain on screen when scrolling horizontally.
#How to freeze more than one column how to
The process is very similar to that explained in our recent quick tip article – How to freeze a row in Google Sheets. In this quick tip article we explain how to freeze columns in Google Sheets.
0 kommentar(er)
