Skip to main content
    Step 1 of 5
    Mac Guides
    Beginner
    4 min read 5 stepsApril 19, 2026Verified April 2026

    How to Use Apple Numbers for Simple Spreadsheets

    Apple Numbers on iPhone, iPad, or Mac lets you create expense trackers, shopping lists with totals, and simple budgets — no experience needed.

    At a Glance

    Category
    Mac Guides
    Difficulty
    Beginner
    Read Time
    4 min read
    Steps
    5
    Topics covered
    Apple Numbers
    spreadsheet
    budget
    iPhone
    iPad
    Mac
    iWork
    1

    Open Numbers and choose a template

    ~32s
    On iPhone or iPad, find the Numbers app (a green icon with a white table on it) and tap it. Tap the "+" button to create a new document. You'll see a list of templates — pre-designed layouts you can customize. For a budget or expense tracker, look for "Personal Budget" or "Simple Budget." Tap it to open it. On Mac, open Numbers from your Applications folder and choose a template from the welcome screen.

    Quick Tip

    You can also start with a "Blank" template if you want to build something from scratch — it's just an empty grid.

    2

    Enter information into cells

    ~23s
    The spreadsheet is made up of a grid of boxes called cells. Each column has a letter at the top (A, B, C...) and each row has a number on the side (1, 2, 3...). To enter data, tap or click on a cell and start typing. Tap the next cell when you're done with one. To change something you already entered, double-tap or double-click the cell to edit it.
    3

    Add a column for your expenses

    ~25s
    Tap a cell in the first empty column and type a category name like "Groceries." Tap the cell below and type a number (like 85.50). Continue down the column, entering one expense per row. In the first column (column A), you can type dates or descriptions so you know what each number refers to.

    Quick Tip

    Don't type dollar signs into the cells — just the numbers. You can format the column to show "quot; automatically.

    4

    Add a formula to get a total

    ~36s
    Tap or click the empty cell at the bottom of your column of numbers — this is where the total will appear. Tap the "=" button on the keyboard (or on Mac, type the = key). Numbers may suggest SUM automatically. If it does, tap SUM. Then tap the first number in the column, hold, and drag to the last number to select all of them. Tap the green checkmark or press Return. Your total will appear automatically.

    Quick Tip

    The formula bar at the top will show something like =SUM(B2:B15) — that's just Numbers' way of saying "add up all the numbers from row 2 to row 15 in column B."

    5

    Save and access your spreadsheet from any Apple device

    ~25s
    Numbers saves your work automatically to iCloud if you're signed into iCloud. This means the spreadsheet will be available on your iPhone, iPad, and Mac without you having to do anything extra. To save a copy to your phone's storage or share it, tap the three dots (more options) in the top right corner and choose "Export" to save it as a Numbers file or an Excel file you can email.

    You Did It!

    You've finished reading: How to Use Apple Numbers for Simple Spreadsheets

    How well did this guide stick with you?

    Need more help? Book a TekSure tech

    A spreadsheet sounds technical, but at its heart it's just a table — rows and columns of information. Apple Numbers is Apple's free spreadsheet app, and it's available on iPhone, iPad, and Mac. It's designed to be much friendlier than a traditional spreadsheet program, with built-in templates and large, easy-to-read buttons.

    You don't need any spreadsheet experience to use Numbers for everyday tasks. The most common uses include: - Keeping a monthly expense log (track where your money goes) - A simple grocery or shopping list with prices that add up automatically - A basic household budget comparing income and expenses - Tracking medications, appointments, or health readings over time - Making a simple to-do list or checklist

    The key feature that makes spreadsheets powerful is the formula. A formula is a calculation the spreadsheet does for you automatically. For example, you can add up a whole column of numbers with a single instruction — no calculator needed. When you change a number, the total updates instantly.

    Apple Numbers is free and comes pre-installed on most iPhones, iPads, and Macs. If you don't have it, you can download it for free from the App Store. Files you create in Numbers can also be saved as Excel files (.xlsx) if you need to share them with someone who uses Windows.

    This guide will show you the basics using a simple expense tracker as an example.

    Rate this guide

    How helpful was this guide?

    Apple Numbers
    spreadsheet
    budget
    iPhone
    iPad
    Mac
    iWork

    Official Resources

    Sources used to create and verify this guide. View all sources →

    Still stuck? Let a pro handle it.

    A real person can walk you through this over the phone, anywhere in the US. If we can't fix it, you don't pay.