Practical tips for excel tables

Open the Excel cell, enter the basic data, then we perform a one-second sum, select all the data, hold down "alt =" for one second to find all the sums

Select all cell data and hold down "alt f1" to create a chart in one second

Select the table data, and hold down "ctrl shift 1" at the same time, you can delete the decimal point in the data in one second

Enter splittable long text in the cell, first change the first Row data is split.

Select the data that needs to be split in the first column, and hold down "ctrl E" to split the same text as the first row

The same applies to the other two columns. After selecting the column, press and hold "ctrl e" to split it

Recommended related article tutorials:excel tutorial

The above is the detailed content of Practical tips for excel tables. For more information, please follow other related articles on the PHP Chinese website!