Home > Topics > excel > body text

What is the method to manually wrap lines in excel cells?

angryTom
Release: 2019-07-25 11:20:56
Original
23008 people have browsed it

What is the method to manually wrap lines in excel cells?

If you want to know more about the Excel table operation tutorial, you can click: Excel Tutorial

If you choose automatic line wrapping, if one line is not filled in some places and you want to change to the next line, you can only use spaces. However, if the cell is one long, you will have to wrap the line, and pressing Enter at the end of the line will not work. How should I be able to wrap the line where I want?

In fact, you only need touse the "alt" "enter" key to manually wrap lines in the cell. Let me introduce you to the detailed steps below.

1. Open the excel table and enter a piece of text "New Microsoft excel worksheet" in cell A1.

What is the method to manually wrap lines in excel cells?

#2. Place the mouse cursor at the location where the line break operation is required, and place it in front of the "excel" character as shown below.

What is the method to manually wrap lines in excel cells?

3. Press the "Alt" and "Enter" keys on the keyboard at the same time.

What is the method to manually wrap lines in excel cells?

4. After pressing, the string can be changed from the front of the "excel" character to the second line for display.

What is the method to manually wrap lines in excel cells?

5. Click on a blank space on the page to exit cell editing. The picture below shows the final display effect.

What is the method to manually wrap lines in excel cells?

The above is the detailed content of What is the method to manually wrap lines in excel cells?. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!