← Using a Computer, in Practice
Spreadsheets · 51 of 111
Keep one table: one row per thing, no gaps
Expert guidance
Do this
- Put column headings in row 1: Name, Class, Fee paid.
- Give each person or thing one row.
- Put one kind of thing in each column, so numbers stay numbers.
- Leave no blank rows or columns inside the table.
- 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
- Applying AutoFilter, LibreOffice 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.
