1
Select the table
Highlight the whole table, including the header row, so every row moves together.
How to sort by date in Google Sheets
Put rows in date order with Data > Sort range, keeping the header row in place.
Operations
2
Click Data
Open the Data menu.
3
Click Sort range
Hover over Sort range.
4
Click Advanced range sorting options
Choose Advanced range sorting options.
5
Check Data has header row
Tick Data has header row so the headers stay at the top.
6
Click the Sort by box
Open the Sort by list.
7
Click the date column
Choose the column that holds the dates.
8
Choose A to Z
A to Z puts the oldest date first; Z to A puts the newest first.
9
Click Sort
Click Sort.
10
Sorted by date
The rows are now in date order, earliest first.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.