This wikiHow teaches you how to freeze a row in a spreadsheet using Google Sheets on your computer.
Steps
-
Navigate to https://sheets.google.com . You can use any web browser to access Google Sheets.
- If you don't see a list of spreadsheets on your Google Drive, you'll need to sign in to your account now.
-
Open the spreadsheet that contains the row to freeze. Click any spreadsheet in the list to open it in Sheets.
- If the spreadsheet is on your computer, click the gray folder at the top-right corner of the file list, click Upload , then click Select a file from your computer . Now you can double-click the spreadsheet and click Open .
- To create a blank spreadsheet, click the box with an “+” at the top-left corner of Sheets, then add some data.
Advertisement -
Click the number next to the row you want to freeze. Each row has its own number running along the left side of the screen. Clicking the number will highlight the entire row.
- You'll have the option to freeze only the selected row, or all rows up to the selected row.
- For example, if you want to freeze the first row in your spreadsheet so it stays in place as a menu, click 1 .
- If you want to freeze the first 10 rows, click the number next to the 10th row.
-
Click View . It's in the menu bar at the top of Sheets.
-
Select Freeze . This expands the Freeze menu.
-
Select the number of rows to freeze. Choose one of the following options:
- To freeze only the selected row, click 1 row .
- To freeze the selected row and the one above it, click 2 rows .
- To freeze all rows up to the selected row, click Up to current row .
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Article Summary
X
1. Sign in to Google Sheets
.
2. Open the spreadsheet.
3. Click the row number.
4. Click View
.
5. Select Freeze
.
6. Click 1 row
, 2 rows
, or Up to Current Row
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 333 times.
Advertisement
