Excel Friends,
Th procedure Automatic Row Height for Merged Cells below works for me, but partially. It changes to the Row Height but not all the times. No evident reason. Most of the times I modify the length of the text, hit Enter and nothing happens. So, after hitting Enter I go back up to the merge cells, hit F2 and Enter again and only now the Row Height is adjusted. I am using MS Excel 2016 (365). Does somebody have a clue why it does not work as intended? Can the Go back up, F2 and Enter key sequence be done with a macro? Thanks for any help!
“You can fool Excel into setting the row height properly. You do this by using a separate column that is created for the express purpose of setting row height. The process is described in the following general steps. (These steps assume you are merging the cells in columns A and B, and that your data table only includes columns A through K.)
1. Merge the cells in columns A and B as desired.
2. In column Z (or some other column outside of your data table range, but not immediately adjacent), put a simple formula reference to column A, as in =A1.
3. Ensure the text formatting of column Z is exactly the same as in the merged cell, with the exception of merging. (Column Z should not be merged with anything, nor should it be marked as merged.)
4. Make the width of column Z slightly narrower than the combined width of columns A and B.”
Source: https://excelribbon.tips.net/T010563_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap
Th procedure Automatic Row Height for Merged Cells below works for me, but partially. It changes to the Row Height but not all the times. No evident reason. Most of the times I modify the length of the text, hit Enter and nothing happens. So, after hitting Enter I go back up to the merge cells, hit F2 and Enter again and only now the Row Height is adjusted. I am using MS Excel 2016 (365). Does somebody have a clue why it does not work as intended? Can the Go back up, F2 and Enter key sequence be done with a macro? Thanks for any help!
“You can fool Excel into setting the row height properly. You do this by using a separate column that is created for the express purpose of setting row height. The process is described in the following general steps. (These steps assume you are merging the cells in columns A and B, and that your data table only includes columns A through K.)
1. Merge the cells in columns A and B as desired.
2. In column Z (or some other column outside of your data table range, but not immediately adjacent), put a simple formula reference to column A, as in =A1.
3. Ensure the text formatting of column Z is exactly the same as in the merged cell, with the exception of merging. (Column Z should not be merged with anything, nor should it be marked as merged.)
4. Make the width of column Z slightly narrower than the combined width of columns A and B.”
Source: https://excelribbon.tips.net/T010563_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap
