Numbers User Guide for Mac
- Welcome
-
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
- Copyright
![](https://help.apple.com/assets/62967DE87EEB3169244F860C/62967DEA7EEB3169244F8636/en_AU/b41caff93c0da85fc0ca4a85751cc32d.png)
View the source data for a value in a pivot table in Numbers on Mac
You can create a table of the source data that corresponds with any populated cell in a pivot table. This is especially useful if you are analysing data in a pivot table and want to better understand how a particular value was calculated without having to look through a large source table. For example, if you have a pivot table tracking student performance and one student’s average grade seems lower than expected, you can create a table of source data for all their scores to see if one was entered incorrectly.
Select a populated cell in a pivot table.
Control-click, then choose Create Table for Source Data.
A new table is added on the same sheet as the selected cell. It displays the column headings and values in the original source table that are used to calculate the value in the cell you selected.