Google's office suite has a spreadsheet called Google Sheets. With a few clicks in a spreadsheet, you can insert a header to a table.
Step 1. Go to the Google Sheets web page
In your internet browser, search for the Google office suite spreadsheet or click on this link: Google Sheets. If your Google account is not open, use your credentials to sign in.
Step 2. Open a spreadsheet
Select the sheet you want to modify or take a new sheet by clicking on the sheet with a multicolored cross which is at the top left of the Google Sheets web page.
Step 3. Add a new row
In the worksheet, insert a blank row. If you already have a line planned to create the header of your table or if it's a new sheet, go to the next step. Otherwise, insert the new line.
- Select the number on the left side of the sheet that corresponds to the first row of your table. The line is now highlighted.
- In the sheet menu, click Insertion.
- In the pop-up menu that appears, tap Line above. You now have a blank row at the top of your table.
Step 4. Enter the titles
At the top of each column, write the title you want to give each one, depending on the content of the column. Choose a title, if possible, short, but revealing on the data below.
Step 5. Select the row number
In the worksheet, click the number that corresponds to the header of your table to highlight it.
Step 6. Open the View menu
Access menu features Display by selecting it.
Step 7. Click Freeze
In the pop-up menu that appears, press the function Freeze.
Step 8. Select 1 row
By performing this operation, you have just frozen the header row of your table. In other words, when you scroll through the rows of your sheet, you always keep the row containing the table header in the same place.
- To insert a filter in each column of your table, select the first cell at the top left of the table header. Once this cell is highlighted, click Data in the main menu of the spreadsheet. Then click on Create a filter. You now have the option of filtering the data in each column by clicking at the title of a column on the small triangle made up of 3 horizontal lines.