← Using a Computer, in Practice
Spreadsheets · 55 of 111
Sort the whole table, not one column
Expert guidance
Do this
LibreOffice Calc
- Select the whole table, headings included.
- Choose Data, Sort. Pick the column under Sort Key 1.
- On the Options tab, tick Range contains column labels.
Google Sheets
- Select the table.
- Data, Sort range, Advanced range sorting options.
- Tick Data has header row, then pick the column.
Why this way
Rows must move together, or Sita gets Ramesh’s marks and the file looks fine. Before a big sort, save a copy. If it goes wrong, Ctrl + Z at once. Excel has Sort on its Data tab. Expert guidance.
Do it today
Sort a marks list from highest to lowest, and check that each name kept its marks. Five minutes.
Where these facts come from
- Sort Criteria, LibreOffice Help.
- Sort & filter your data, Google Docs Editors Help.
General information. Menus and apps change, so look for the idea if a button has moved. You use it at your own risk: see our terms. Spotted a mistake, or know something better? Tell us.
