How to Resize Excel Organization Chart Boxes and Print on 11x17 Paper in WPS Office
Question details
The user needs to make all boxes in an Excel organization chart a consistent size and set up the worksheet to print the chart on 11-by-17-inch tabloid paper on one page.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- User has an organization chart in a WPS Office Excel workbook and wants to format its boxes uniformly and print the chart on 11 by 17 paper.
- Observed behavior
- The organization chart boxes are not uniform, and the default page size does not print the full chart on 11-by-17-inch paper.
Open the workbook that contains the organization chart and confirm the chart boxes are selectable shapes or SmartArt. Switch to the worksheet with the chart before changing size and page settings.
Resize All Organization Chart Boxes to the Same Size
Use this when the org chart boxes are different sizes and you need a uniform, professional layout before printing.
This method works for organization charts created with shapes or SmartArt in WPS Office Spreadsheet. If your chart is an inserted image, convert or redraw it as shapes first.
Click the first box in the organization chart, press and hold Ctrl, and click every additional box to select all chart shapes.
Go to the Shape Format or Format tab, locate the Size group, and note the current height and width boxes.
In the Shape Height and Shape Width fields, type the desired values such as 1.2 in height and 2.0 in width, then press Enter. All selected boxes become uniform.
Click the connector lines and adjust them if needed so they still connect the resized boxes cleanly.
Set the Worksheet to 11 by 17 Paper and Fit the Chart on One Page
Use this after resizing the boxes when you need to print the full organization chart on tabloid paper without spilling onto multiple pages.
How to Resize an Excel Organization Chart and Print It on 11 x 17 Paper in WPS Office
Open your Excel organization chart in WPS Office Spreadsheet, set uniform shape sizes, then use Page Layout and Scale to Fit to print the chart on a single 11-by-17 tabloid page.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office and open the Excel file containing the organization chart.
- 2. Resize the chart boxes uniformly: Select all org chart boxes, open the Format tab, and enter identical height and width values.
- 3. Choose tabloid page size: Go to Page Layout > Size and set the paper size to 11 x 17 in or Tabloid.
- 4. Scale to one page and print: Set Scale to Fit Width and Height to 1 page, preview the chart, then click Print.

Frequently Asked Questions
How do I select all organization chart boxes at once in WPS Office?
Click one box, press and hold Ctrl, and click each remaining box. For a SmartArt organization chart, click the SmartArt border to select the entire graphic first, then use the Format tab.
What paper size should I choose for 11 by 17 printing?
In Page Layout > Size, choose Tabloid or 11 x 17 in. If the size is missing, open Page Setup > Paper and enter a custom width of 11 inches and height of 17 inches.
Why does my organization chart print on two pages after resizing?
Check the Scale to Fit settings in the Page Layout tab. Set Width and Height to 1 page, and reduce margins or change orientation if needed.
Can I resize only one box, or do I have to select all boxes?
You can resize one box by selecting it and entering Size values, but selecting all boxes first is the fastest way to create a consistent organization chart.
Does WPS Office support Excel SmartArt organization charts?
Yes, WPS Office Spreadsheet opens and edits Excel SmartArt organization charts, including resizing shapes and printing to custom paper sizes such as 11 x 17.




