Copy and paste is the most ordinary process in Excel. And in this article, we will introduce 3 methods to paste multiple lines into one cell in your Excel.
When working with Excel worksheet, you will certainly copy external contents into Excel cells. And sometimes you need to copy multiple lines into one cell. For example, in the image below, we now want to paste the contents into a cell.
If you directly copy the contents and then press the shortcut keys “Ctrl + V” on the keyboard, you will find that the contents will be in two cells.
To solve this problem, now you can use the following 3 methods.
Method 1: Double Click the Cell
If you want to paste all the contents into one cell, you can use this method.
- Press the shortcut key “Ctrl + C” on the keyboard.
- And then switch to the Excel worksheet.
- Now double click the target cell in the worksheet.
- After that, press the shortcut key “Ctrl + V” on the keyboard. Now you can see that the contents are in one cell.
- Next you can press the button “Enter” on the keyboard or click another cell.
You can also adjust the cell height and width to make the interface better.
Method 2: Press F2
When you cannot edit in the cell directly, you can also use the button “F2” on the keyboard. You can check whether you can double click and edit cell directly or not.
- Click the tab “File” in the ribbon.
- And then click the button “Options”.
- After that, click the option “Advanced” in the window.
- In the “Editing options” area, you can see that the option “Allow editing directly in cells” is unchecked.
Therefore, you cannot edit in the cell directly. If you still want to double click a cell and then edit directly, here you can check the option. But if you need to keep the setting, you can go on and use “F2” in this method.
- Press the shortcut key “Ctrl + C” on the keyboard to copy the contents.
- And then move to the Excel worksheet.
- After that, click the target cell in the worksheet.
- Next press the button “F2” on the keyboard. At this moment, you will see that the formula bar will be in the editing condition.
- Now press the shortcut key “Ctrl + V” to paste those multiple lines.
- Next click other cell or press the button “Enter” on the keyboard. Thus, multiple lines will also be pasted into one cell.
Method 3: Use Formula Bar
Actually in the previous method, you have already used the formula bar. But here you can also directly use your mouse to click the formula bar.
- In this step, still press the shortcut key “Ctrl + C” on the keyboard to copy the contents.
- Next go to the target Excel worksheet.
- After that, click the target cell in the worksheet.
- And now, click the formula bar in the worksheet. Thus, the formula bar will be in the editing condition.
- Now repeat the step 5 and 6 in the previous part and paste the contents into the formula bar. And then you will also see the multiple lines in one cell.
When you have pasted the lines into cells, you can change the cell size to make it better.
All the methods are very easy to use. And you can use any one according to the actual need and your habit.
Identify Damaged Excel Files in Your Computer
When one Excel file corrupts, it will also affect other normal files. For example, the virus in this Excel file will quickly spread to other files. And this will cause severe damage to Excel. There are many methods you can do to save your precious files. Among them, the best choice is using an Excel recovery tool. This tool can figure out the reason of the corruption and then repair xlsx file damage as soon as possible. You can save a lot of time on repairing Excel by this tool.
Author Introduction:
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair doc data problem and outlook repair software products. For more information visit www.datanumen.com