WPS Office

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.

Free download

Windows • MacOS • Linux • iOS • Android


How to add column to a table in excel

July 21, 2022

You can add more rows and columns even after a table has been built. New cells that you add will be automatically formatted to match the existing table style, whether they are added inside the current range or next to the table.

How to insert a row or column adjacent to a table in excel online, 2016 and 2019

1. In the empty cell adjacent to the table, click.

2. Put a value in the cell.

3. To enter the value, click anywhere outside the cell or press the Enter key.

4. The table's formatting is applied once the new row or column is introduced.

5. When a formula is typed into a column that is vacant in a table, the formula fills the remaining spaces in the column without the use of the AutoFill function. The formula also shows in new rows that are added to the column.

How to insert a row or column within a table in excel

1. Where you wish to add the row or column, choose a cell in the table's adjacent row or column.

If you choose a column header, no insert alternatives are shown.

2. On the Home tab, click the Insert list button.

3. Select a table insert choice:

  • Add Row Above Selected Cell in Table: Adds a new row above the selected cell.

  • To the left of the selected cell, a new column is added using the Insert Table Columns command.

Shortcut: To add data, just right-click a row or column and choose Insert from the menu. Then choose an insertion method.

How to delete columns and rows in an excel table

In WPS Excel, creating columns and rows is as easy as dragging them into place. There are several ways to accomplish this, as you have probably already realised. You'll just utilise the Delete function in this case.

There is also a Delete button nearby, as you may have observed while utilising the Insert function above. Therefore, to remove a column or row, utilise one of these methods.

1. Right-click on a selected column or row and select Delete.

2. Click Delete in the Cells area of the ribbon, choose a column or row, and then go to the Home tab. As an alternative, you may select Delete Sheet Columns or Delete Sheet Rows by clicking the arrow adjacent to the Delete button.

3. Choose the cell(s) in the desired row or column that you wish to delete. To remove a table column or row, right-click, choose Delete, then from the pop-up menu, choose rows or columns.

Note: This was an attempt to show you how to add column to a table in excel online, 2016 and 2019, 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 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.