Spreadsheets

Design a Google Sheet that works on a phone screen

Lay out a Google Sheet that works on a phone: narrow columns, a frozen header, a one-column summary tab, checkboxes and dropdowns instead of typing.

Editorial illustration for Design a Google Sheet that works on a phone screen

A Google Sheet works on a phone when each tab has only three or four narrow columns, the header row is frozen, the totals sit on a separate one-column summary tab, and common entries are checkboxes or dropdowns rather than typing. Build the phone version on purpose; shrinking a wide desktop sheet onto a small screen never works.

What does a phone-friendly layout look like before and after?

Before: one tab with twelve columns, Date, Amount, Category, Sub-category, Paid by, Merchant, Note, Month, Year, Flag and two formula columns. On a phone you see about three columns at a time and scroll sideways to find where you are.

After: a Log tab with Date, Amount, Category, Paid by, in that order, and the other columns moved to a Calc tab. A Summary tab lists a label in column A and a figure in column B, one line per row. Everything you need fits without sideways scrolling.

How do I set up the Log tab?

  1. Freeze the top row: View, Freeze, 1 row. The headings stay put as you scroll a long list.
  2. Keep columns near default width. A default column is 100 pixels, so three or four of them fill a phone screen; widen only the Category column if names are cut off.
  3. Turn on wrapping for the Note column: Format, Wrapping, Wrap, so long notes do not push the sheet wide.
  4. Make rows taller, which gives bigger tap targets. Select the rows, right-click, Resize rows, and enter a height of 30 pixels or more.
  5. Replace typing with choices. Select the Category column cells, then Insert, Dropdown, and add Food, Fuel, Rent, Medical, Travel and Other. Do the same for Paid by.

Where do checkboxes help?

Checkboxes suit things you tick rather than type: a Paid column on a bills list, a Reviewed column for statement lines. Insert, Checkbox adds them. A tick is one tap, while typing Yes on a phone keyboard is three. They also make counts easy: =COUNTIF($D$2:$D$200,TRUE) counts ticked boxes.

What goes on a single-column summary tab?

Keep the Summary to two columns, label and value, one item per row, so it reads like a list of cards. Put a month start date in B1, for example 1-Apr-2026, and let the other cells react to it:

  • Month total: =SUMIFS(Log!$B$2:$B$1000,Log!$A$2:$A$1000,">="&$B$1,Log!$A$2:$A$1000,"<"&EDATE($B$1,1))
  • Food this month: =SUMIFS(Log!$B$2:$B$1000,Log!$C$2:$C$1000,"Food",Log!$A$2:$A$1000,">="&$B$1,Log!$A$2:$A$1000,"<"&EDATE($B$1,1))
  • Cash this month: the same formula with Log!$D$2:$D$1000 and "Cash" as the criteria

Change B1 to the first of another month and the whole tab updates. Make the Summary the first tab, so it is what opens when you launch the file.

Does this still work when the sheet gets bigger?

The bounded ranges stop at row 1000 on purpose, so the summary stays quick. When the Log nears that row, extend the range or start a new tab for the next financial year, April to March, which also keeps the file light. Once you are importing hundreds of statement lines a month, a sheet starts to strain, and SpendixAI can take the statement upload and categorise the rows for you to review.

Phone layout checklist

  • Top row frozen on every tab.
  • No more than four visible columns on the Log tab.
  • Dropdowns for repeated text, checkboxes for yes-or-no.
  • Summary tab first, two columns, formulas tied to one month cell.
  • Open the file on your own phone and try adding a row with one thumb before you call it done.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports