View Single Post
 
Old 05-09-2017, 06:21 AM
14spar15 14spar15 is offline Windows XP Office 2000
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Pasting numbered lines into a cell with autofit.

In Excel 2010 I have Autofit the row height for a complete column. This works as expected when I type data into a particular cell. When I get to the edge of the cell it spills over and the height of that cell increases to display the next line. When I take that data and copy and paste it into another cell it still works correctly with that cell expanding in height. The problem is what I need to do is paste several numbered lines of text into one cell and I am ending up each numbered line being its own Excel row.
Reply With Quote