Buzz
This article explains how to insert a header row with column titles into your spreadsheet when using Google Sheets on a computer.
Steps
Go to https://sheets.google.com in your web browser. If you are not logged into your Google account, you will need to log in first.
Click on the spreadsheet you want to edit. To create a new spreadsheet, click the 'Blank' option at the top left of the list.
Insert a blank row into the spreadsheet. If you’ve already created a new spreadsheet or have a header row, you can skip this step. If not, follow these steps to add a new row at the top of the spreadsheet:
- Click the number next to the top row in the spreadsheet to highlight the entire row.
- Click the Insert menu.
- Click Row above. This will insert a blank row at the top of the spreadsheet.
Enter titles into the header row. If you've already named the columns/headers, you can skip this step. Otherwise, type the title for each column into the blank cells at the top of your data table.
Click the number next to the header row. This highlights the entire header row.
Click the View menu.
Click the Freeze menu.
Click on the 1 row (1 row). The header row is now frozen, meaning it will stay visible as you scroll down through the spreadsheet.
- To enable the feature that allows sorting and filtering by clicking on the header containing the column, click on the number of the header row, then select the Data menu and choose Filter. Now you can click on the green icon in each header to sort the data.
