Home>Article>Topics> Practical tips for excel tables

Practical tips for excel tables

王林
王林 Original
2019-12-23 14:26:56 7295browse

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

Practical tips for excel tables

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

Practical tips for excel tables

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

Practical tips for excel tables

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

Practical tips for excel tables

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

Practical tips for excel tables

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

Practical tips for excel tables

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!

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