Home

Excel Formatting Width

Highlighted
Daniele Dale
Occasional Visitor

Does anyone know how to format merged cells without affecting the width of the other unmerged cells?

The document attached has the merged cells highlighted in grey - I need them to stay that width. However, the Table below needs to have different cell widths than what the merged cells do.

Can someone help me?

Thank you! :)

1 Reply

In Excel every column has one width value effecting all the cells within it. So you can not apply different widths to different cells in the same column. What you can do is:

 

1. Adjust the cell widths according to the below table. And re arrange the table on the top to fit as closely as their original width

2. you can use textboxes to create a similar effect for the upper table.

3. you can use form controls to create upper table.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies