It is possible to freeze up to 10 rows and 5 columns in Google Spreadsheet. These will then be permanently displayed on the screen and therefore visible, no matter where you are on the spreadsheet. This feature is particularly useful for freezing rows that serve as headers for your data series. So you will always know exactly where you are in your spreadsheet and be sure to put your data in the right place. So if you are new to Google Spreadsheet or just new to this feature, quickly read the rest of this article to learn how to freeze rows or columns in Google Spreadsheet.
Step 1. Open an Internet browser
To start, open your favorite Internet browser (Internet Explorer, Mozilla Firefox, Google Chrome, etc.) by clicking on its icon on your computer desktop. Then go to this address: drive.google.com
Step 2. Log in
You can go directly to the next step if you are already signed in to your Google account. If this is not your case, Google Drive will prompt you to connect to it. To do so, simply use your connection information (username and password). You will only have to fill in the "Password" field with the correct information if your username is already indicated on the page. Otherwise, enter your username and password in the fields provided.
Step 3. Open a spreadsheet
You have the choice of opening an existing spreadsheet or creating a new one. Either way, the spreadsheet will open in a new tab in your browser.
- Note that a list of worksheets should be in the center of the screen. In case you already have a worksheet and want to edit it, just locate it in this list and click on its name to open it.
- If you want to create a new spreadsheet, click on the "Create" button in the top left corner of the screen and then select the "Spreadsheet" option.
Step 4. Access the “View” menu
Among the various options in the menu bar is the “View” option. Find it and click on it to drop down the menu of the same name.
Step 5. Place your mouse cursor over the option that interests you
As a reminder, Google Spreadsheet allows you to freeze rows or columns. A small window should then appear next to the "View" menu, regardless of the option chosen.
- Place your cursor over "Freeze Rows" if you want to freeze the cells that are at the top of your worksheet.
- Place your cursor on "Freeze Columns" if you want to freeze cells that are on the left of your worksheet instead.
Step 6. Select the number of columns or rows you want to freeze
You can freeze up to 10 rows and 5 columns. Just click on the number of rows or columns to freeze. There you go, you now know how to freeze cells in Google Spreadsheet!