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 same 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 which I don't want.

.
.

This seems to work ok here. Paste this macro into the Sheet level module:

Please Login or Register  to view this content.

Hello, thanks for the response here. I have used Excel to a certain extent unfortunately I’m not familiar with any of the coding. Spent the last few hours trying to run your module have not been successful. So if I am opening up a new 2010 Excel workbook do I need to format my column up for AutoFit Row Height? “Do I need to format to “wrap text “? After pressing Alt+F11 what do I do next? Also it seems I have to save as an xltm, is that correct? Thank you

Let's say you want this macro to work for Sheet1.

Right click on the tab down below that says Sheet1.

Then click on View Code

Now, on the left hand side, you should see a small window with:

Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook

Double click on Sheet1(Sheet1). This makes the large window on the right become the Sheet Level Module area where you will paste the code.

Please Login or Register  to view this content.

Make certain there is only one line at the top that says OPTION EXPLICIT

When you save the workbook, save it as Macro Enabled .xlsm

Now when you type anything into a cell on Sheet 1 it will automatically format itself for word wrap, auto-width/auto-height.

No need to format anything on the worksheet ... the code is doing that for you.


You can edit the RowHeight and ColumnWidth by changing the numbers in the macro code: 15.0______8.43