Clever Geek Handbook

How to keep google spreadsheet sorted by date

I have a google spreadsheet that lists expenses in rows, for example:

Date          Amount
2014 12 24    $34
2014 12 22    $83

I would like the entries to be sorted by date (i.e. most recent).

The obvious idea is to choose Sort sheet by column A, Z->A

from the menu Data

(the dates are in column A). However, this will sort the header row ( Date Amount

) along with the actual data rows.

My current solution is to temporarily replace it Date

with some compilation date in the distant future, then Sort sheet by column A, Z->A

and then restore the title Date

. It's cumbersome and a little silly.

Is there a way to "Sort rows 2 ~ infinity by column A, Z-> A"?

+3


source to share


2 answers


Try to "set" the first line in the "view" menu (free translation). This should prevent the header row from shifting when sorting the column.



+1


source


Go to Data ==> Sort Range ...

Select the Data with header check box , select Sort from the list and click Sort .



This should sort your sheet based on the selected column without affecting the header row.

0


source






More articles:


All Articles