Sort a List, Freeze the Top Row, and Print Your Sheet

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.

Our example list

Six family phone numbers, typed in the order they were remembered — which is to say, no order at all:

CellType thisCellType this
A1NameB1Phone
A2Maria LopezB2555-0142
A3Tom BeckerB3555-0119
A4Ann RuizB4555-0177
A5Joe NovakB5555-0105
A6Sue ParkB6555-0131
A7Dan EllisB7555-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.

Job one: sort the list into alphabetical order

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):

  1. Click any one cell inside your list — say A3.
  2. Click Data, then Sort range, then Advanced range sorting options.
  3. Tick Data has header row — this tells Sheets that row 1 is headings, not a person.
  4. Set Sort by to Name and A → Z, then click Sort.

In Excel:

  1. Click any one cell inside your list.
  2. Click the Data tab, then the Sort button. Excel selects your whole table by itself.
  3. Tick My data has headers, set Sort by to Name and Order to A to Z, then click OK.

Either way, the same result — every name carrying its own number with it:

NamePhone
Ann Ruiz555-0177
Dan Ellis555-0126
Joe Novak555-0105
Maria Lopez555-0142
Sue Park555-0131
Tom Becker555-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.

Job two: freeze the top row, so the headings stay while you scroll

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.

Job three: print it — with the headings on every page

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:

  1. Google Sheets: freeze the top row (job two) — Sheets then repeats frozen rows at the top of every printed page on its own. Click File > Print and check the preview: Name and Phone crown page two as well.
  2. Excel: click the Page Layout tab, then Print Titles. Click in the Rows to repeat at top box, then click row number 1 on the sheet (the box fills with $1:$1 — that is Excel’s way of writing “row 1, always”). Click OK, then print as usual.
  3. Print only part of a list: choose the cells first (drag across them). In Sheets, File > Print and set the top box to Selected cells. In Excel, File > Print, and under Settings choose Print Selection.

Words in this lesson

📖 Goes with: Google Sheets: The Grid That Adds Up for You and Excel Formulas: Let the Sheet Do the Sums — this lesson is their shared toolbox for lists that grow.

Straight 2 Work Tech, LLC — patient, plain-words tech help.
(813) 770-6082