Wednesday, December 9, 2020

Excel - Auto fit row height does not work

  • Autofit Row heights will not work properly if
    • Merge cells are used
    • Bullets are used within cells
    • Data is in a table 
  • Resolution
    • Select Cells>Clear format
    • Reformat your document to allow the autofit to work properly
    • Format your document to use word wrap cells
    • No merge cells
    • No Tables

No comments:

Post a Comment