Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a chart in a spreadsheet. If I click on it and select 'advanced edit' > Start, it offers to 'Use row 12 as headers'. How can I use a different row for the header names? My data has rows for the headers, some rows of old data I dont want displayed, the data (which starts at row 12).

share|improve this question
up vote 4 down vote accepted

Yes. On that same tab there is a selection for Data Select Ranges

enter image description here

On the popup, choose your HEADER row first. This is important. Then click on add another range. enter image description here

Now choose your data. Click Ok

Under "combine ranges" choose vertically.

Make sure the box is checked that says "use row XX as a header". (this would be the first range you chose).

I think that is what you are looking for.

share|improve this answer
thanks - that worked – spiderplant0 Jan 30 '13 at 14:03
@William: It only works if you put your header row first in the textbox, so you may have to change Results!K77:P77, Results!K1:P1 to Results!K1:P1, Results!K77:P77. – Gruber Jun 18 '14 at 7:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.