![]() After that, click the target cell in the worksheet.Press the shortcut key “Ctrl + C” on the keyboard to copy the contents.But if you need to keep the setting, you can go on and use “F2” in this method. If you still want to double click a cell and then edit directly, here you can check the option. Therefore, you cannot edit in the cell directly. In the “Editing options” area, you can see that the option “Allow editing directly in cells” is unchecked.After that, click the option “Advanced” in the window.You can check whether you can double click and edit cell directly or not. When you cannot edit in the cell directly, you can also use the button “F2” on the keyboard. You can also adjust the cell height and width to make the interface better. Next you can press the button “Enter” on the keyboard or click another cell.Now you can see that the contents are in one cell. After that, press the shortcut key “Ctrl + V” on the keyboard.Now double click the target cell in the worksheet.And then switch to the Excel worksheet.Press the shortcut key “Ctrl + C” on the keyboard.If you want to paste all the contents into one cell, you can use this method. To solve this problem, now you can use the following 3 methods. 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. For example, in the image below, we now want to paste the contents into a cell. And sometimes you need to copy multiple lines into one cell. When working with Excel worksheet, you will certainly copy external contents into Excel cells. And in this article, we will introduce 3 methods to paste multiple lines into one cell in your Excel. Copy and paste is the most ordinary process in Excel. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |