Apr 6, 2019
In sheets I don't have the Headers choice. How do I get it?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Aug 5, 2019
Original Poster Anne Matson marked this as an answer
Jun 15, 2019
Original Poster Anne Matson marked this as an answer
Apr 6, 2019
Hello,
If you are referring to "Headers and footers" which is under the "Format" menu for Google Documents then Google Sheets doesn't have that. You can add headers and footers when you go to print your Google Sheet.
James :)
Original Poster Anne Matson marked this as an answer
In Sheets, users will normally use the top few rows to keep their headers but they are entered by the user. Depending on your sheet, you might be able to use a function that would create a header row but the formula would need to get the data for the headers from another part of your sheet.
It sounds like you have some specific needs and without seeing the structure of your sheet, we would only be giving you our best guess. For someone to best help you, would you please take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”? Thanks!
Adam
Original Poster Anne Matson marked this as an answer
All Replies (14)
Apr 6, 2019
In Sheets, users will normally use the top few rows to keep their headers but they are entered by the user. Depending on your sheet, you might be able to use a function that would create a header row but the formula would need to get the data for the headers from another part of your sheet.
It sounds like you have some specific needs and without seeing the structure of your sheet, we would only be giving you our best guess. For someone to best help you, would you please take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”? Thanks!
Adam
Original Poster Anne Matson marked this as an answer
Original Poster Anne Matson marked this as an answer
Jul 10, 2019
Original Poster Anne Matson marked this as an answer
Aug 26, 2019
Last edited Aug 26, 2019
Sep 11, 2019
If you have a header row, and wish to sort a table without including the header row in the sorted result, try this ...
(1) Select the entire sheet (by clicking in the empty cell that is above Row 1 and to the left of Column A).
(2) From the tabs at the top of the sheet page, select:
>Data
>> Sort range,
and you will be presented with a dialogue box.
(3) In the dialogue box:
(a) check “Data has header row”, and
(b) define your sort criteria.
Dec 18, 2019
Jan 23, 2020
work and the row number doesn't correspond with the responses due to the auto populated headings created by my form. I believe i have tried all the methods mentioned in the feed and any help would be much appreciated.Hi Liam,
Because you essentially have a new question, would you please post a new question in the forum that includes a link to a sample of your file. Take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”? Thanks!
Adam
Feb 15, 2020
Google user
Mar 10, 2020