A list you keep — family phone numbers, addresses, club members — earns three jobs: putting it in alphabetical order, keeping the headings in sight while you scroll, and printing it so the headings appear on every page. This lesson does all three in Google Sheets and in Excel, on one small worked list, including the one sorting warning that protects your data.
Six family phone numbers, typed in the order they were remembered — which is to say, no order at all:
| Cell | Type this | Cell | Type this |
|---|---|---|---|
| A1 | Name | B1 | Phone |
| A2 | Maria Lopez | B2 | 555-0142 |
| A3 | Tom Becker | B3 | 555-0119 |
| A4 | Ann Ruiz | B4 | 555-0177 |
| A5 | Joe Novak | B5 | 555-0105 |
| A6 | Sue Park | B6 | 555-0131 |
| A7 | Dan Ellis | B7 | 555-0126 |
(The 555 numbers are practice numbers, the kind films use — kind on strangers if this page is ever shared.) Three jobs turn this scribble into a tool: put it in alphabetical order, make the headings stay put while you scroll, and print it with those headings on the page.
The one warning first, because it matters: names and numbers must travel together. If you ever sort only the Name column, the sheet will cheerfully alphabetise the names and leave the numbers behind — Maria ends up wearing Tom’s number. Both programs below are safe if you let them take the whole table; the safe method is the same idea in each.
In Google Sheets (computer):
In Excel:
Either way, the same result — every name carrying its own number with it:
| Name | Phone |
|---|---|
| Ann Ruiz | 555-0177 |
| Dan Ellis | 555-0126 |
| Joe Novak | 555-0105 |
| Maria Lopez | 555-0142 |
| Sue Park | 555-0131 |
| Tom Becker | 555-0119 |
On a phone (Google Sheets app): tap the letter A at the top of the Name column to choose the whole column, tap the three dots, and choose Sort A–Z — Sheets offers to extend the sort to the neighbouring column; accept, so the numbers travel. In the Excel phone app, sorting hides behind Home > Sort & Filter; it is genuinely easier on a computer, and there is no shame in that — some jobs are.
A list of six fits on one screen. A list of sixty does not — and by row 40 you have forgotten which column was Phone. Freezing pins the heading row to the top of the window while the rest scrolls beneath it.
Print a long list and page two arrives anonymous: numbers with no idea which column is which. The heading row needs to repeat, and each program has its own switch:
Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082