Microsoft Excel 2007 tutorial: insert columns on a worksheet


Insert columns on a worksheet

XIX. Insert columns on a worksheet

You can insert a column, multiple columns, and nonadjacent columns on a worksheet. When you add columns to the worksheet, Excel normally inserts the columns to the left of the selected columns. To insert a column, multiple columns, and nonadjacent columns, follow the procedure below.

XIX.1. Insert a column

- Select any column

- Right-click the selected column, and then click Insert on the shortcut menu.

Excel 2007 insert a column

Or

- Select the column

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Columns. You can also click Insert Cells to add a new column.

 Excel 2007 insert a column by using Insert tool

Excel adds a column to the left of the selected column immediately.

You can repeat the action of inserting a column quickly by selecting the location where you want to insert the column, and then press Ctrl +Y.

XIX.2. Insert multiple columns

- Select the number of columns

- Right-click the selected columns, and then click Insert.

Excel 2007 insert multiple columns

Or

- Select the columns

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Columns or Insert Cells.

Excel adds the columns to the left of the selected columns immediately.

For example, you have a worksheet as the figure:

Excel 2007 worksheet contains columns data

You want to add two columns to the left of the column A and column B. To do this task, follow the procedure below:

1. Select column A and column B

2. Right-click the selected columns

3. Click Insert on the shortcut menu.

Excel 2007 select two columns

or

1. Select the two columns (column A and column B)

2. On the the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Columns or Insert Cells.

Excel adds two columns to the worksheet on the left of column A and column B; so the column A and column B moves to column C and column D.

Excel 2007 add two columns

XVIII.3. Insert nonadjacent columns

- Select nonadjacent columns

- Right-click the nonadjacent columns

- Click Insert on the shortcut menu.

- Or after selecting the nonadjacent columns

- On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Columns or Insert Cells.

For example, you want to add nonadjacent columns to column A and column C of the worksheet below.

Excel 2007 worksheet example

To do this task, follow the procedure below:

1. Select column A and column C

2. Right-click the selected columns

3. Click Insert on the shortcut menu.

Excel 2007 select nonadjacent columns

or

1. Select the nonadjacent columns (column A and column C)

2. On the Home tab, in the Cells group, click Insert or click drop-down arrow next to Insert, and then click Insert Sheet Columns or Insert Cells.

Excel adds nonadjacent columns to the left of column A and column C; so column A moves to column B and column C moves to column E.

Excel 2007 add nonadjacent columns


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.