Excel has this functionality and it is invaluable for managing the display of data in sheets.
Just because I have a lot of narrative information in a cell does not mean I want to have it all visible all the time when in the sheet. Often it is more valuable to see more rows than to see all the information in a cell at the expense of different rows. (Turning off text wrapping, and widening or hiding the column are not sufficient answers.)