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 Sheet1, which is automatically being updated via form entries.

I'm making Sheet2, which is a self-sorting version of Sheet1 (it intended to be a copy of Sheet1 but sorted by a column). Ideally I would just auto-sort everything on Sheet1 and not even make Sheet2, but it appears I can't.

If I attempt to select all of Sheet1 as a range, Google Docs will return "Sheet1!1:102". So if I get more than 102 entries on Sheet1, Sheet2 apparently will not include them.

If instead I select the columns on Sheet1, I get "Sheet1!C:J". That's better. But I want to exclude the very top row. Otherwise it will sort the column title as if it were just another value.

Is there an elegant way to specify this as a range? Or do I have to manually pluck out the top row with the filter function or something?

share|improve this question

migrated from superuser.com Nov 8 '10 at 22:47

This question came from our site for computer enthusiasts and power users.

There's an easy way. For example, for a sum, you can specify it like this:


So basically, specify the first cell you want, then the name of the column. That way, you can skip as many rows as you want.

share|improve this answer
Keep in mind you need to put this total somewhere other than in the column you are summing or you will get a circular dependency error. – Andrew Clark Jan 28 '15 at 23:40

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.