![]() This is so much quicker than manually investigating and adjusting each row as Microsoft describes on their website. Just select the cells and then use the following tool: Either of these actions should heighten the row to fit the text in the merged cells. When a group of cells in a row are merged and the text wraps to two or more lines, double-clicking the row border just to the left of column A (or Format>Row>Autofit) auto-heights the row to one line of text. ![]() It is quite time consuming to manually adjust every row. Is there a way to copy row heights or another way I can automatically adjust? I have over 200 rows I must adjust as each week as a new tab is created with some of the same plus added criteria. Each row, according to the data entered, is of various sizes. ![]() The AutoFit Row Height does not apply and if you double click the row it defaults to 15.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |