Pointers for creating Pivot Tables: Format as a table: For the most flexibility, format your source data as an Excel table (Ctrl + T). This ensures your Pivot Table automatically includes any new rows ...