How to divide a whole report into several small tables?

You can use the column function of Excel table to divide a cell into several small cells.

Divide the following "The weather is fine today" into three cells. The following is an Excel table of WPS, and so is Office Excel.

1. Select the cell to be divided A 1, and then find the Column button under Data;

2. In the wizard dialog box that pops up, select Fixed Width, and then click Next;

3. In the box under the data preview, click the mouse to create a column line, drag the column line to the specified location (double-click the column line to delete), and then click Next;

4. Select the column data type (general, text, date or not to import this column) on this page, select general here, and then click Finish to realize classification.

Extended data:

In many Excel skill sets, data sorting is always one of the most striking functions. You can split by separator, keyword, fixed length, from number to date, from number to text, from English date to Chinese date.