Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to create a table with one click
Uploaded time: August 26, 2021 Difficulty Beginner
How to create a table with one click
![](http://res-academy.cache.wpscdn.com/static/cover/big_xls.png)
How to create a table with one click
Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table.
Take the sales table in this article as an example.
1. Click the Table button in the Insert tab. (Notes: You can also use the shortcut key Ctrl+Lto directly open the edit box. )
2. Select a data range and check the option ofMy table has headers.
3. After creating the table, we can find that WPS Spreadsheet has provided a large number of built-in templates for the users in the Table Tools tab. Then you can click to choose a favorite style.
Suppose that we need to find out the top ten sold products efficiently.
1. Since the table feature comes with a filtering function, we only need to click the drop-down button on the right.
2. Click top ten to get the results.
When there is no need to use the sorting and filtering features, you can also click the Convert to Range button to convert it into a normal table with one click.
Also Read:
- 1. Insert a table into the text & convert between text and table
- 2. Convert PDF to image with one-click
- 3. Color schemes: change the theme color with just one click in WPS Presentation
- 4. Remove the picture background with one click
- 5. How to translate PDF files with one click
- 6. Use WPSArt to insert an organization chart with one click
Does this video help you?