Formatting Issues

How to Set Different Column Widths for Excel Tables on One Worksheet

Algirdas Jasaitis Sep 28, 2026 872 views

Question details

The user is asking whether it is possible to set different column widths for separate tables located on the same Excel worksheet.

How to Set Different Column Widths for Excel Tables on One Worksheet

Product: Excel
Device & OS: not provided
Scenario: Organizing multiple tables with different formatting and layout requirements on a single spreadsheet.
Observed behavior: Excel column widths apply uniformly to the entire worksheet column, preventing two tables stacked vertically in the same columns from having independent widths.

Before you start

Determine whether your tables need to be printed on a single physical page or just viewed together on screen, as this will dictate which layout workaround works best for you.

Solution 1Recommended

Place the Tables Side by Side

Since column width applies to the entire column vertically, placing your tables horizontally next to each other allows each table to occupy its own set of columns with independent widths.

This is the simplest and most common workaround. By moving your second table to a completely different set of columns on the right side of the first table, you avoid any overlapping column dependencies.

Select the second table

Highlight the entire second table that you want to adjust independently.

Move the table

Cut the table using Ctrl+X. Click on an empty cell in a new column to the right of your first table and paste it using Ctrl+V.

Adjust column widths independently

Click and drag the boundaries between the column headers (e.g., between letters D and E) for the new table to change its width without affecting the first table.

Formatting Tip: If you need both tables to appear in the same view without scrolling, you can hide the empty columns between them to create a cleaner layout.

Solution 2

Use Separate Worksheets

If horizontal placement makes your spreadsheet difficult to navigate or print, placing each table on its own worksheet provides complete layout independence.

Solution 3

Use the Linked Picture Tool

This advanced method allows you to display tables with different column widths vertically by converting one into a dynamic image linked to its source data.

Efficient Spreadsheet Layout Management

Easily Manage Complex Tables with WPS Spreadsheet

WPS Office Spreadsheet provides a highly compatible and intuitive workspace for managing complex data. You can easily organize multiple tables side-by-side or across multiple sheets to achieve the perfect layout.

1. Open WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet or create a new blank workbook.
2. Organize your layout: Select the tables you need to adjust and use Ctrl+X and Ctrl+V to paste them into adjacent columns side-by-side.
3. Adjust widths seamlessly: Hover over the column headers and drag the boundaries to resize the columns for each table independently.
4. Save as Excel format: Go to Menu > Save As, and choose the .xlsx format so your perfectly formatted tables can be shared with Microsoft Excel users.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) ensuring flawless data sharing.Intuitive drag-and-drop interface for precise column width and row height adjustments.Free, lightweight, and fast-loading alternative to traditional spreadsheet software.Seamless multi-tab management for organizing different table layouts effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I change the column width for just one cell or table?

Spreadsheet software relies on a strict grid structure where a single column must maintain a consistent width from the very top row to the bottom row of the worksheet. Changing the width for one cell or table automatically forces the entire column to match that width.

Can I merge cells to simulate different column widths vertically?

Yes, you can merge multiple smaller cells together above or below your main table to create the appearance of different column widths. However, this is generally discouraged because merged cells often cause errors when sorting data, applying filters, or writing formulas.

Is there a way to print tables from different sheets onto the same page?

While you cannot natively print separate sheets onto one continuous page layout directly, you can use the 'Linked Picture' feature. Copy the table from the second sheet, paste it as a linked picture onto the first sheet, and print that combined view.

Document & File Issues