Google sheets will automatically take into account your whole spreadsheet, but you can also specify which cells you want it to cover. Select the New sheet option to set the pivot table on a ...