Google Sheets doesn’t have as many features as Microsoft Excel, but you can still add a workbook title, sheet name, date, page number, and stuff on the spreadsheet. Here’s how to add a header in Google Sheets.
If you’re talking about adding a header, it mostly means a header that is placed at the top of the spreadsheet. Either a workbook title or sheet name. The thing that you can definitely add to Google Docs documents on Format > Headers & footers.
But Google Sheets doesn’t have the same functionality feature. While Google Sheets is free and easy to use, it’s an online service that doesn’t provide more advanced features like adding a header and customizing it.
You can still add a header in Google Sheets, although you might not be able to change the style, font size, and stuff. But, you can change the margin and the position.
Another thing to know is that Google Sheets doesn’t provide a way to directly add a header in the menu. It’s a little bit hidden and people who are newly using Google Sheets might find it difficult to find.
How to add a header in Google Sheets
Inserting a header in your spreadsheet is easy. Simply open Google Sheets, and open the spreadsheet you want to add a header.
Now, click the File menu. Choose Print. Yes, the feature to put a header is under the print menu.
You would see the print settings here. You need to scroll down the sidebar at the right to see where you can add a header and footer to your spreadsheet.
Under Headers & footers, you can directly check which stuff to show on your header and footer. You can add page numbers, workbook title, sheet name, current date, or the current time.
By default, the header and footer will be placed automatically. If you want to customize the position and the content of the header and footer, click Edit custom fields.
Here, you can add a header to Google Sheets easily. There are six positions you can choose to add header/footer content to.
Click to add a header or to edit it. There are some buttons that you can use to add page numbers, title, date, or time with different formats.
Click the first one to add a page number. There is page number with only a number, with “Page” before it, and “Pg” that stands for “page” with a number afterward.
You can choose to show the workbook title or sheet name.
You can add many different formats of dates.
You can also add different formats of the current time.
It would show a shortcode like this. You can definitely add a workbook title, sheet name, and stuff in the same position in the header or footer.
To save it, click Confirm, which is at the top-right.
To print, simply click Print. You can also save the spreadsheet as a PDF by choosing Microsoft Print to PDF in the printer section.
Unfortunately, you can’t size the font size and the style of the header or footer. Google Sheets hasn’t provided the feature at this time of writing.
How to add a row header in Google Sheets
If you mean a row header instead of header and footer in the Format menu, then you can definitely add a row header easily.
You can add that manually but inserting a new row at the top. You can also make a table out of your spreadsheet to make it look good.
While you can use Google Sheets easily, you might get confused every time you want to add a header. Google Sheets provide the feature to do it, but you can’t customize the font size and the style.
RELATED: How to Autofill in Google Sheets