Pivot Table Issues

Can Excel PivotTables Have Independent Rows and Columns?

Anum MushtaqAnum Mushtaq Nov 13, 2026 868 views

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.

Can Excel PivotTables Have Independent Rows and Columns?
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook

Open your workbook in WPS Spreadsheets or Microsoft Excel and select the sheet that contains the PivotTable.

2
Copy or move 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.

3
Resize rows and columns

On the new worksheet, adjust row heights and column widths independently for that PivotTable without affecting other sheets.

Put Each PivotTable on a Separate Worksheet
Works in WPS and Excel: Keep each layout-critical PivotTable on its own sheet for full column and row control.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download WPS Office from the official WPS website and install it on your device.
  2. 2. Open your Excel workbook: Launch WPS Spreadsheets and open the .xlsx file containing your PivotTables.
  3. 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.
Works with existing Excel .xlsx PivotTable workbooksFamiliar ribbon interface for a seamless switchFree, lightweight download for Windows, macOS, Android, and iOSSupports the same separate-worksheet layout workaround for independent row and column sizesNo Microsoft 365 subscription required
microsoft office alternative - wps office

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.