Skip to content

← Using a Computer, in Practice

Spreadsheets · 51 of 111

Keep one table: one row per thing, no gaps

Expert guidance

Do this

  1. Put column headings in row 1: Name, Class, Fee paid.
  2. Give each person or thing one row.
  3. Put one kind of thing in each column, so numbers stay numbers.
  4. Leave no blank rows or columns inside the table.
  5. Avoid merged cells.

Why this way

A program takes a table to end at the first empty row. LibreOffice’s help warns that its filter stops at the first empty cell if you haven’t selected a range. So a blank row can leave half your list out of a sort, and your names can end up with the wrong marks. Keep totals below, with a gap, or on another sheet. Expert guidance.

Do it today

Look at a sheet you’ve made and remove one blank row or merged cell. 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