Use Different Column Widths in Excel Worksheet Sections
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.
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.
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.
In the worksheet, select adjacent cells across the rows you want to format, such as B100:C200.
On the Home tab, open the Merge & Center menu and select Merge Across. This merges the selected cells separately in each row.
Review the merged rows and use File > Print to preview the layout, including any repeated header rows.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 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. Merge adjacent cells: Select the adjacent cells in the row, such as B100:C100, then choose Merge & Center on the Home tab.
- 4. Repeat and review: Repeat for other rows as needed, then use File > Print to check the layout and repeated headers.

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.




