I am a long time user of Excel however there is one thing I have never done and thus know not how

Miyeon.S - MSFT, have you given up?

Miyeon.S, please understand, using the term "LINE FEED" is totally foreign to me. I have never heard of this in all my years with Excel, further, I cannot find it in my ribbon and so I went to search and used it and that resulted in "find and replace". Where did you pull "Line Feed" from? Is this a person term as it certainly, in my system, does not appear in Excel. Here is what I did: I copied a paragraph from Wikipedia and then pasted it into Excel.

Rather than spend hours reformatting all of this I though I would use "Word Wrap" as when I pasted the material into Excel, it produced a line that is 45 columns long vs the nine columns I want to use.

Therefore, I highlighted my 9 columns and clicked on "Word Wrap". That produced the material all appearing into one column that measure 409 plus instead of my standard 18.75. So then I next highlighted my all nine of the columns I want the text to appear in and clicked on "Merge and Center.

However, that then left me with the paragraph spread across all nine of the columns I want but still in a row that measure 409 plus instead of the 18.75 I want.

At this point, I thought "Well, no big deal and clicked on the bottom of the line thinking Excel would adjust the row height to the 18.75 I wanted like all the rest of the workbook. Nope, that collapsed the material to the 18.75 but dumped all the text except the first nine columns of text and the rest did not show so then I had to drag the bottom line up to the point where all the text material was displayed correctly at nine columns across and the correct row height for that specific paragraph that allowed 100% of the text to be shown completely and the row to be spaced to also show all of the text for that paragraph.

There has to be a much fast method for doing all of this BUT, it cannot be done with all of the rows the same height as in some cases it will be too high and in some other cases it will be insufficient to show all the text.

Lastly, that which frustrates me the most is that once this is done in my nine column area, all the rest of the columns to the right of the nine are then governed by the settings in the first nine columns and cannot be changed from that. Surely the programmers at Microsoft can make a change in Excel so that, as in my case, after I wish to move to the right of my area that is already set, I can set the next adjacent area differently that the nine column width and whatever height is in the area to the left so in other words, the first nine columns are perfect for the material in it but nothing to the right can be any different. Is this clear, as mud?

I do hope this better explain what I am trying to do and how I am doing it while asking for a better, much faster way of doing it.

Dear TemporaryUser0101,

It is a pleasure to receive your reply. I greatly appreciate your spirit of continuous learning and I want to learn from you.

I understand that you copied a quote from Wikipedia and pasted it into Excel, and when you clicked on Auto Line Feed, the height and width of this cell changed, and then you wanted a shortcut to be able to adjust the height and width of the cell, right? Please let me know if my understanding is wrong.

What I'm trying to tell you is that the Auto Line Feed feature is to display extra long text in multiple lines so that the user can see all the text. What kind of effect are you trying to achieve by using the auto line feed feature?

If it's convenient for you, could you share a screenshot of what you're experiencing with me? This will help us understand your problem better.

You can check out the information about the auto line break feature in this support article:

Wrap text in a cell - Microsoft Support

In the following two support articles, there are many ways to adjust the row height and column width, which I hope will be helpful to you.

Change the column width and row height - Microsoft Support

Change the column width or row height in Excel - Microsoft Support

Looking forward to your reply.

Miyeon.S - MSFT |Microsoft Community Support Specialist

Wow, you lost me immediately when you used the term "Line Feed" which in all of my years I have never heard of which is no big deal. I use features that benefit me the most, the rest I ignore.

Here is exactly what I am doing:

I copy a paragraph from a paper I saved from Wikipedia. Then I copy a paragraph and paste it into my Excel workbook I am currently using. After doing that, I wish for it to appear like a normal paragraph is a document and therefore not knowing short cuts that will work, I first highlight the paragraph and then click on "Wrap Text" after highlighting nine columns. Then I have to manually adjust the height of the grouping of columns.

I did try first to double click the bottom line of that group of cells thinking it would adjust the height properly but it does not. Instead, it goes to either a group of cells far too high or to a single row and only showing that portion and not the rest.

So, what I want is to dump the copied paragraph into Excel, use a short cut to either adjust the width and then another to adjust the height.

Line Wrap must be from Mars. lol! I was using the first computers to hit the public which were Macs which became Apple and then Windows was introduced as compared to another software package (SMART) that better did what Windows did or does. (Seriously, SMART was much better, much more efficient however, as well know the tricks and tactics of Microsoft won out and beat SMART out of the market which ultimately is what caused the charges against Microsoft but their super smart attorneys beat the FEC OR FCC or whoever it was that attacked and lost.

Give me some time to read over what all you said, how to do it and etc. and then I will come back unless, of course, my explanation added fuel to help you help me. lol (again) Thank you so much.

Dear TemporaryUser0101,

Thanks for visiting Microsoft Community.  I am happy to help you.

I understand that you are creating a document and intend to use Line Feed and Merge and Center, but you want a way to quickly adjust the horizontal and vertical spacing.

Thank you for your longtime support of Microsoft products, but I don't quite understand what you're trying to do, and I need to ask you some questions:

1. The "Line Feed Text" feature allows the text in a cell to be automatically line-folded, so the text is displayed on multiple lines, so I think that's what makes the vertical space larger. What kind of effect are you trying to achieve? Can you take a screenshot and tell me?
2. If you want to adjust the row height and column width, you can follow the method below.

This is how it works in Excel:

For more information you can view this article:Wrap text in a cell - Microsoft Support

3. If you are not comfortable doing this, you can send me the file via private message so that we can do further testing.

Please feel free to contact me if you need further assistance.

Best regards

Miyeon.S - MSFT |Microsoft Community Support Specialist