Skip to content

← Using a Computer, in Practice

Spreadsheets · 55 of 111

Sort the whole table, not one column

Expert guidance

Do this

LibreOffice Calc

  1. Select the whole table, headings included.
  2. Choose Data, Sort. Pick the column under Sort Key 1.
  3. On the Options tab, tick Range contains column labels.

Google Sheets

  1. Select the table.
  2. Data, Sort range, Advanced range sorting options.
  3. 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

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.

← All 111 things to do