Can Excel PivotTables Have Independent Rows and Columns?
Question details
Explains whether Excel or WPS Spreadsheets PivotTables can have independent row heights and column widths in the same worksheet, and how to arrange PivotTables that require different layouts.

- Product
- WPS Spreadsheets and Microsoft Excel
- Device & OS
- not provided
- Scenario
- User is comparing behavior with Apple Numbers and wants multiple PivotTables to have separate row heights and column widths in one worksheet.
- Observed behavior
- Excel and WPS Spreadsheets share a single worksheet grid, so row heights and column widths apply to the entire sheet; completely independent PivotTable layouts are not supported in one sheet.
Open the workbook containing your PivotTables and identify which PivotTables need different row heights or column widths. Note that Excel and WPS Spreadsheets apply row height and column width to the entire worksheet, not to individual PivotTables.
Put Each PivotTable on a Separate Worksheet
Use this method when you need completely independent row heights and column widths for each PivotTable.
Excel and WPS Spreadsheets apply row height and column width to the entire worksheet, so separating PivotTables onto their own sheets is the only way to get fully independent sizing.
Open your workbook in WPS Spreadsheets or Microsoft Excel and select the sheet that contains the PivotTable.
Right-click the sheet tab, choose Move or Copy Sheet, and create a copy in a new worksheet. If you prefer, insert a new sheet with the plus icon and then copy the PivotTable to it.
On the new worksheet, adjust row heights and column widths independently for that PivotTable without affecting other sheets.

Place PivotTables Side by Side on the Existing Grid
Use this option when you need visual comparison in one view and can accept shared column widths.
Present Results in a Separate Report Table
Use this if you only need presentation-friendly output rather than editable PivotTable layout changes.
Use WPS Spreadsheets as a Free Alternative for PivotTable Layouts
When Excel’s one-sheet grid limits independent PivotTable layouts, WPS Office Spreadsheets provides a free, lightweight environment with familiar PivotTable tools and full .xlsx compatibility. Open your existing workbook, apply the separate-sheet workaround, and keep working without buying Microsoft Office.
- 1. Download WPS Office: Download WPS Office from the official WPS website and install it on your device.
- 2. Open your Excel workbook: Launch WPS Spreadsheets and open the .xlsx file containing your PivotTables.
- 3. Apply the separate sheet workaround: Right-click the sheet tab and use Move or Copy Sheet to place layout-critical PivotTables on separate sheets.

Frequently Asked Questions
Can I make one PivotTable column wider without changing the whole worksheet in Excel?
No. Excel uses a single worksheet grid, so column width changes apply to the entire worksheet. Use a separate worksheet for that PivotTable if it needs different column widths.
Does WPS Spreadsheets allow independent PivotTable row heights and column widths?
No. WPS Spreadsheets follows the same worksheet grid model as Excel. The reliable workaround is to place each layout-critical PivotTable on its own sheet.
How do I move a PivotTable to a separate sheet in WPS Office?
Right-click the sheet tab, choose Move or Copy Sheet, create a copy in a new worksheet, then adjust the rows and columns on that sheet independently.
Can I place two PivotTables side by side with different widths?
They can be side by side, but they will share the same column grid. Leave a blank column between them and use Wrap Text or row height settings to improve readability.
What is the best way to print PivotTables with different layouts?
Put each PivotTable on its own worksheet, or build a separate report table that references PivotTable cells and format that report sheet independently.




