Microsoft Excel For Mac 2019 Pivot Table Filter.Microsoft Excel For Mac 2019 Pivot Tables.Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 更多. For additional sort options, click Options. On the Data tab, click Sort, and then click the sort order that you want. In the PivotTable, click any field in the column that contains the items that you want to sort. Sort row or column label data in a PivotTable. Tables are a great source of data for Pivot Tables because rows added to the “source” Table (later on) will be automatically included in the Pivot Table once you refresh it. Ideally, you can use an Excel table (select the grid data and use Format as Table in the HOME tab). Your data should be organized in a tabular format.
