When the money is out for that category, the idea is that you must stop all spending in that category for the month. To learn how, see Create new spreadsheets from a specific template.This Google Sheet is built around the philosophy of envelope budgeting, where you set aside a certain amount of money for each budgeting category.

You can also set Numbers to open new spreadsheets from a template instead of from the template chooser. Numbers automatically saves your changes, so you won’t lose any of your work. To close the spreadsheet when you’re finished working, click the red close button in the top-left corner of the window. You can change the name of the spreadsheet or change its location at any time.

If iCloud Drive is set up on your Mac, Numbers saves the spreadsheet there by default. To name and save your spreadsheet, choose File > Save, enter a name, choose a location, then click Save. To create a new spreadsheet from scratch, double-click the Blank template.Īdd your own headers and data to a table: Select a table cell, then type.Īdd other tables, text boxes, shapes, and images: Click object buttons in the toolbar.Īrrange elements on the sheet: Drag tables and objects to where you want them. In the template chooser, browse templates by category or click All Templates, then double-click a template to open it. See Format a spreadsheet for another language. Note: If you’d like the ability to format table and chart data using the conventions of another language, choose the language in the bottom-left corner before choosing a template. Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.See the latest activity in a shared spreadsheet.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Change the look of chart text and labels.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average, and more.View the source data for a pivot table value.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.

Add checkboxes and other controls to cells.

Use VoiceOver to create formulas and autofill cells.

Intro to images, charts, and other objects.

Personal budget template for mac