How To Insert A Column

Table of contents:

How To Insert A Column
How To Insert A Column

Video: How To Insert A Column

Video: How To Insert A Column
Video: How to Insert Column in Excel 2024, November
Anonim

Surely, many computer users in the course of work or study had to deal with Microsoft Office Excel spreadsheets. It would seem that there is nothing complicated in them, but due to the variety of built-in functions and capabilities, sometimes difficulties arise even with how to insert an ordinary graph correctly.

How to insert a column
How to insert a column

Instructions

Step 1

Typically, in Microsoft Office Excel spreadsheets, a column is a column. In Microsoft Office Excel 2003, columns can be added in the following ways.

Step 2

Method One Activate the column in front of which you plan to insert a new, empty column. To do this, left-click on the column heading, as a result of which it will be colored dark gray. Then click on the selected column with the right mouse button and select "Add" or "Add cells" from the list that appears, after which the new column will automatically appear in the specified place.

Step 3

The second method You can add a new column not only by selecting the entire column, but also its separate cell, for which it is enough to place a marker (cursor) in it, for example, by clicking on it with the left mouse button. Then click on the selected cell with the right mouse button and select "Add cells" from the list that appears, then in the "Add cells" window that appears, select the "Column" sub-item and press the "OK" button.

Step 4

Method Three Select the column in front of which you plan to insert a new, empty column. Then in the "Insert" menu, which is in the "Menu Bar" item right below the "Title Bar", select the "Columns" item, and it will automatically appear in the table.

Step 5

The fourth method Activate the entire column or its individual cell and immediately press the combination of keys "Ctrl" and "+" on the numeric keypad.

Step 6

All of the above methods considered adding only one new column to the table. To insert multiple columns, you need to select at least one cell in each of the columns where you want to add new columns.

Step 7

In Microsoft Office Excel 2007, columns are added as follows. Method One Select the entire column to the left of the column to which you want to add the column. Then, in the "Cells" command group located in the "Home" tab of the ribbon, click on the "Insert Cells" command.

Step 8

Method Two Select the entire column located to the left of the column to which you want to add the column, and execute the "Insert" command (the second group of shortcut menu commands). In order to insert several graphs, it is necessary to select several columns at the same time. How many columns have been selected, as many new, empty columns will be added to the table.

Step 9

In Microsoft Office Excel 2010, graphs are added in much the same way. Activate the column before which you plan to insert the new column. In the "Insert" menu, select "Main Tab", after which a new column will appear on the sheet.

Recommended: