How do I set up Excel auto wrapping?

Source: Internet
Author: User

Excel handles the data conveniently everybody knows, can in its cell wraps the line to be slightly inconvenient, I do not know whether you have also encountered this kind of problem? By groping, the following four methods can easily implement the cell within the automatic line wrapping.

1. Enter the data at any time to change line

The user will be able to change lines when entering data, as long as it is easily implemented by Alt+enter key combinations. This method also causes the cells that you have entered to wrap at the cursor.

2. Line wrapping within a range of cells

Converts a long line into a paragraph and wraps the line within the specified range. For example: A10 content is very long, want to show it in column A to C column, step is: Select the area a10:c12 (first select A10), select "edit → fill → content rearrange", A10 content will be distributed in the A10:C12 area. This method is particularly suitable for annotations in tables.

3. Adjust cell formatting for line wrapping

Select the cells, choose format → cells, click Align in the pop-up dialog box, select the Wrap check box, and then click the OK button.

4. Clever Use of text box

Click the View menu, and in the Toolbars command, select the Drawing toolbar, click Text Box on the toolbar, and, to ensure that the bounds of the text box coincide with the worksheet gridlines, hold down the ALT key while you insert the text box, and then you can enter the text box.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.