Formatting Issues

Use Different Column Widths in Excel Worksheet Sections

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

The user wants different apparent column widths in separate sections of an Excel worksheet.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet layout calls for a wider column in some rows without changing its width everywhere.
Observed behavior
Excel applies a column's width to the entire column and does not offer section breaks that change widths within a worksheet.
Before you start

Identify the rows that need a wider appearance and check the adjacent cells for data. Merging retains only the upper-left value in each merged range, so move any other values you need before merging.

Solution 1Recommended

Merge Adjacent Cells to Create a Wider Appearance

Use merged cells when you need a wider-looking area in selected rows without changing the worksheet's column widths.

This changes the appearance of selected cells, not the actual width of a column. Merged cells can complicate sorting and affect worksheet and print layouts.

1
Select the target range

In the worksheet, select adjacent cells across the rows you want to format, such as B100:C200.

2
Merge each row

On the Home tab, open the Merge & Center menu and select Merge Across. This merges the selected cells separately in each row.

3
Check the layout

Review the merged rows and use File > Print to preview the layout, including any repeated header rows.

Merging can remove values: Merge Across keeps only the leftmost value in each merged row. Move other values before merging, and check sorting and print headers afterward.
Create wider-looking cells

Create a Wider Cell Area in WPS Spreadsheets

Use WPS Spreadsheets to merge adjacent cells in selected rows, creating a wider-looking area while leaving the underlying column widths unchanged.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Check the cells: In the target row, move any values you need from the cells to the right of the first cell; merging retains only the upper-left value.
  3. 3. Merge adjacent cells: Select the adjacent cells in the row, such as B100:C100, then choose Merge & Center on the Home tab.
  4. 4. Repeat and review: Repeat for other rows as needed, then use File > Print to check the layout and repeated headers.
Create wider-looking areas in selected worksheet rowsOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting controls
microsoft office alternative - wps office

Frequently Asked Questions

Can an Excel column have two widths on the same worksheet?

No. Changing a column width applies it to the entire column. Merge adjacent cells in selected rows to create a wider-looking area instead.

Do page breaks let me change column widths?

No. Page breaks control where a worksheet splits when printed; they do not create sections with independent column widths.

What happens to existing data when I merge cells?

Excel retains the upper-left value in a merged range and removes the others. Move any needed values before using Home > Merge & Center.

Can merged cells affect repeated print headers?

Merged cells can affect the print layout, so check File > Print after merging. To configure repeated rows, use Page Layout > Print Titles and set Rows to repeat at top.