Hello there everyone, i recently came upon something that im not able to figure out and haven't had any luck after searching a bunch for my particular issue..
my dilemma is that ive created a table so that you can re order based on certain columns and data, etc. and within this table i have wrap text on to allow multiple lines within a cell to show up. and everything works fine when i have excel autofit row height, but then when i re order the table, the autofit row height stays in the row and doesnt move with the data so a row that once had been autofit for 3 lines is now back to 1 line and would have to autofit the whole page again to show everything...
so my question is, is there a way to have excel dynamically autofit all rows to show all data? so i don't have to keep manually clicking autofit row height, and id prefer not to use a keyboard shortcut either if possible, thanks!
my dilemma is that ive created a table so that you can re order based on certain columns and data, etc. and within this table i have wrap text on to allow multiple lines within a cell to show up. and everything works fine when i have excel autofit row height, but then when i re order the table, the autofit row height stays in the row and doesnt move with the data so a row that once had been autofit for 3 lines is now back to 1 line and would have to autofit the whole page again to show everything...
so my question is, is there a way to have excel dynamically autofit all rows to show all data? so i don't have to keep manually clicking autofit row height, and id prefer not to use a keyboard shortcut either if possible, thanks!