How do I quickly insert multiple columns in Excel? Method 1: Adding multiple columns in Excel using the ‘Insert’ function Step 2: Using the keyboard, press and hold the “CTRL” ("Command" if using a Mac), “SHIFT” and “+ ” keysĪ column will be inserted to the left of the column selected in step 1. Step 1: Select the column (to the left of which you wish to add a new column) Method 2: Adding a column in Excel using Keyboard Shortcuts
If you rename these two columns Price and Total Sales, you arrive at the same result as with Resize Table.Steps to follow while inserting columns in Excel using ‘Insert’ function. Then add one more column to the right in the same way. 
Right-click the Sales Amount column, then go to Insert, and click on Table Column to the Right.Īs a result, a new column (named Column1) is inserted to the right of the selected column ( Sales Amount). Insert ColumnĪnother way to extend a table is to simply insert a new column. Now you’ve resized the table and added the columns Price and Total Sales. To rename Column1, enter Price in cell F2 and to rename Column2, enter Total Sales in G2. As you can see, when you enter a new range, the dashed line shows the table size.Īs a result, the table has two new columns (F and G) named Column1 and Column2. Since you want to add two more columns to the right, expand the range for Columns F and G, and the new range is B2:G16. In the pop-up screen, change the range for the table and click OK. In the Properties group, click Resize Table. Then, in the Ribbon, go to the Table Design tab. First, select the table by clicking on any cell in it. If you want to add Price and Total Sales to the table, you’ll need to add two columns to the right. 
Say you have the data table shown below with columns for SKU, Product, Month, and Sales Amount. When working with tables in Excel, you can resize them by using Resize Table in the Table Design tab or by simply inserting a column.
This tutorial demonstrates how to extend a table by adding a column in Excel.
0 kommentar(er)
