Excel line feed

1. line feed of input data at any time

To wrap a line when entering data, you can simply use the Alt + enter key combination. This method can also wrap the input cells at the position of the cursor.

2. line feed in the cell area

Converts a long line into a paragraph and wrap it in a specified area. For example, A10 has a long content. to display it in column A to column C, follow these steps: A10: C12 (select A10 first) in the selected region ), select "Edit> Fill> content re-arrangement". The A10 content will be distributed in the A10: C12 area. This method is particularly suitable for Table comments.

3. Adjust the cell format to wrap the line

Select a cell, select "format> cell", click "alignment" in the displayed dialog box, select the "Wrap" check box, and click the [OK] button.

4. Clever Use of text boxes

Click the "View" menu, select the "Drawing" toolbar in the "toolbar" command, and click "text box" in the toolbar. To ensure that the border of the text box overlaps with the grid lines of the worksheet, press the Alt key and insert the text box. Then, you can enter any content in the text box.