A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
If this is an Excel table, there are two easy ways to extend it with another column:
- Click anywhere in the table.
- Go to Table Design.
- Select Resize Table.
- Select the new range so it includes the extra column.
- Click OK.
Another option is to type a new heading in the column immediately to the right of the table. Excel can automatically extend the table to include that new column.
If the issue is that new adjacent cells are not being added into the table automatically, turn that option back on:
- Go to File > Options.
- Select Proofing.
- Click AutoCorrect Options...
- Open the AutoFormat As You Type tab.
- Select Include new rows and columns in table.
- Click OK, then OK.
If the table lines or borders do not look right after adding the column, resize the table range first so the new column is part of the table, then adjust the column width as needed.
References: