How to Add Columns to a Data Table
Use Microsoft Excel or Word to add columns to an existing data table. Adding columns allows you to include more data in a table.
Other People Are Reading
Things You'll Need
- Computer
- Microsoft Excel or Word
- Existing data table in an Excel or Word document
Instructions
-
-
1
Open the Microsoft Excel or Word file that contains the data table you wish to add columns to.
-
2
Click on the letter (e.g. A, B, C) at the top of the column in the Excel data table where you would like to insert additional columns. While that column is selected, click "Insert" and select "Columns."
In Word, highlight the column in the data table where you would like to insert additional columns. While that column is selected, click "Table," select "Insert" and then select either "Columns to the Left" or "Columns to the Right," depending on where you want the columns to be placed.
-
-
3
Select more than one column (in both Excel and Word) before proceeding to insert columns to add more than one column, or repeat Step 2 as often as necessary.
-
1
Tips & Warnings
Use your mouse to more quickly insert columns. After selecting the column where you want to insert additional columns, right-click with your mouse (for PC users) or click while pressing "Command" (for Mac Users) and select "Insert" from the menu.
