Home  >  Article  >  Topics  >  How to wrap rows without formatting in excel

How to wrap rows without formatting in excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-03 11:14:3054490browse

How to wrap lines without formatting in excel: 1. Position the cursor at the position where you want to wrap the line, and press the "Alt Enter" key to force a line wrap. 2. Select the cells you want to wrap and click "Start" - "Automatically wrap" at the top of the page to realize the wrap alignment function.

How to wrap rows without formatting in excel

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2013 version, Dell G3 computer.

There are two ways to wrap rows without changing columns in Excel. The specific steps are as follows:

Method 1:

Position the cursor at The position where you want to wrap the line, and then press the Alt Enter key at the same time to force a line wrap. At this time, it is an automatic alignment effect.

How to wrap rows without formatting in excel

How to wrap rows without formatting in excel

Method 2:

Select the cells you want to wrap and click "Start" ”, select “Automatic line wrapping”, and the line wrapping alignment function can also be realized.

How to wrap rows without formatting in excel

You can see the text in the cell, automatically wrap and align.

How to wrap rows without formatting in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to wrap rows without formatting in excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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