Cell height increases when merging

Question

The cell height increases slightly when merging how can I stop this

Answer 1

Hi,

I'm Sneha and I'd be happy to help you out with your question. Sorry for the inconvenience caused.

When you select cells in a column and then click "Merge Cells" in Microsoft Word, the cells in the next column increase in height. To prevent this from happening, you can adjust the row height manually after merging the cells.

Please follow these steps to adjust the row height manually:

1. Select the merged cell(s) whose row height you want to adjust.
2. Right-click on the selected cell(s) and choose "Table Properties" from the context menu.
3. In the Table Properties dialog box, go to the "Row" tab.
4. Uncheck the "Specify height" checkbox if it is checked.
5. Click on the "Options" button.
6. In the Row Height Is dialog box, select "Exactly" and enter a value for the row height that you want to set.
7. Click OK to close all dialog boxes.

Alternatively, you can also try adjusting column width or text wrapping options to fit your content within a single cell instead of merging cells.

Note :- if you have multiple rows with merged cells, you will need to repeat these steps for each row individually

For more Information, Please refer to following resources :-

1. Make changes to cells in a table - https://support.microsoft.com/office/make-changes-to-cells-in-a-table-20e8714a-d39a-4d76-8cfe-1a3d03f08d5a
2. Cell height increases when merging - https://answers.microsoft.com/en-us/msoffice/forum/all/cell-height-increases-when-merging/3090d557-5cba-4471-a6e6-44695c761155
3. You cannot use the AutoFit feature for rows or columns - https://support.microsoft.com/topic/you-cannot-use-the-autofit-feature-for-rows-or-columns-that-contain-merged-cells-in-excel-34b54dd7-9bfc-6c8f-5ee3-2715d7db4353

If you have any other questions or need assistance with anything, please don't hesitate to let me know. It will be my pleasure to Assist you.

Best Regards, Sneha

Answer 2

I cannot replicate the issue.

If you send me a copy of the document, referencing this thread in the covering email message, I will investigate the issue.

Answer 3

When I merge 1" and 1" cells they become more than 2" I can tell because the cells adjacent to them increase in height.

Answer 4

What sort of merging are you talking about?

Answer 5

Hello Am_619,

I’m Gunasekar and I will be happy to help you with your question, I am a Microsoft consumer like you.

Other than by safeguarding the worksheet, there is no straightforward mechanism to prevent changes to the width and height of cells. For instance, if two cells with heights of 10 and 20 pixels are combined, the final merged cell will have a height of 30 pixels. This is so because the merged cell inherits the tallest cell's height.

You could password-protect the excel sheet and check the outcome.

https://support.microsoft.com/help/cb7835f6-9c37-4161-bb53-d1c410acaf21

To Auto row height with merge cell and wrap text, use the VBA Code displayed on the below discussion thread.

https://answers.microsoft.com/thread/a9508cd8-d7b3-4a3f-b66b-d02ddbd48579

I hope this information helps. If you have any questions, please let me know and I’ll be glad to assist you further.

Best regards,

Gunasekar N