WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add a table in excel cell (Full Guides)

July 21, 2022
8.5K Views

To create a structured Excel Table from a list of data, use the Table command. You may organise and view your data using the many functions that tables contain, such as sorting and filtering.

How to add a table in excel online, 2016 and 2019

1. Within your data collection, choose any cell.

2. Click the Table button or use the Ctrl + T keyboard shortcut on the Insert tab, in the Tables group.

3. All the data is automatically picked for you when the Create Table dialogue box loads, but you can change the range if necessary. Make sure the My table contains headers option is checked if you want the first row of data to serve as the table headers.

4. Click ok.

5. As a consequence, Excel creates a real table from your range of data using the following default style:

How to make a table with a selected style in excel

1. Any cell in your data collection can be chosen.

2. Click Format as Table under the Styles group on the Home menu.

3. Select the desired style by clicking it in the gallery.

4. If required, modify the range in the Create Table dialogue box, select the My table includes headers checkbox, and then click OK.

How to filter a table in excel

1. The column header's drop-down arrow should be clicked.

2. In the boxes next to the data you wish to exclude, uncheck them. You may also deselect all the data by checking the box next to Select All, then check the boxes next to the data you wish to display.

3. When appropriate, you can utilise the Filter by Color and Text Filters options.

4. Click ok.

By unchecking the Filter Button box on the Design tab's Table Style Options group, you can get rid of the arrows if you don't require the auto-filter capability. Alternately, you may use the shortcut Ctrl + Shift + L to turn on and off the filter buttons.

Additionally, you may add a slicer to your table to provide a visual filter for it. To do this, select Insert Slicer from the Tools group under the Table Design menu.

Note: This article was an attempt to make you understand how to add a table inn excel online, 2016 and 2019. You can apply the above stated method in WPS spreadsheet in both windows and mac.

To get the newest version of WPS Office, you must first access this operating interface.

You just need to have a little understanding of how and which way things work and you are good to go with your work. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.