Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

add comment

1 Answer 1

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

=SUM(G2:G)

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
add comment

Your Answer

 
discard

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.