You choose what data to use in your pivot table and how to organize it in the Pivot Options tab of the Organize sidebar, shown below. You can create pivot tables to analyze data, quickly group and calculate values, and identify interesting patterns and trends.Īlmost any other table in your spreadsheet can provide the source data. Restore an earlier version of a spreadsheetĪ pivot table is a special type of table that organizes and summarizes data from another table (containing the source data).

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.

How to make pivot table in mac numbers