View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim J.
 
Posts: n/a
Default Automatically Re-Size Row Height

When I use a formula to extract data from one worksheet to another, the
imported data often exceeds the size of the cell. The cells are set to €śwrap
text€ť. In order view all of the imported data within the cell, I need to
double-click on the line at the bottom of the affected row. This will
re-size the row to fit the text within the cell.
Is there a way to set the cell (or row??) so that this row sizing happens
automatically?