Tech Tip of the Week

Automatic row height for merged cells with text wrap

These steps assume you are merging the cells in columns A and B, and that your data table only includes columns A through K. Merge the cells in columns A and B as desired. 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. 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.)Make the width of column Z slightly narrower than the combined width of columns A and B. The row height is based upon the contents of column Z, which matches the contents of the merged cell in columns A and B. This, of course, allows all the text in the merged cell to be visible.