How do I wrap an Excel table?

How do I wrap an Excel table? usually use Excel software, often encounter a very long text or other data in a cell display is not open, has been horizontal display, and sometimes to use this automatic line-wrapping function, can be in a cell length is not enough to automatically wrap. Here's how to wrap the line.

Excel Table Wrapping Step One

First Open the Excel software and enter a text in a single cell. For example, "Green Tea Software Park Article Tutorial Office application." You can see that the default cell is too small and the text is not displayed correctly, so you can set it to wrap.

Excel Table Wrapping Step Two

Click on a blank cell at any point. Then click the right mouse button, in the pop-up menu click to set cell format. As pictured.

Excel Table Wrap Step Three

Then, in the Settings page that pops up the Format cell, click the Alignment tab above.

Excel Table Wrap Step Four

In this Alignment tab, in the Text control column, select the Word wrap option, i.e. click on the previous check box. then click OK.

Excel Table Wrap Step Five

This set of cells can be wrapped automatically. Can be entered in the "Pacific Article Tutorial Office application" These words, you can see, when the width is not enough, the text automatically wrapped. This will add a lot of convenience to the operation.

Or you can use the way to drag line wrapping, the direct ALT key plus carriage return can be.

If you want the cell in this column or a row of cells to have the ability to wrap automatically, you can select the cells in batches for wrapping.