How To Add A Column

Table of contents:

How To Add A Column
How To Add A Column

Video: How To Add A Column

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

Mastering office applications is not complete without learning the principles of working with tables, be it tables in Microsoft Excel or Microsoft Word. Let's look at a few simple techniques for adding columns (columns) to a table.

How to add a column
How to add a column

Instructions

Step 1

Start Microsoft Excel. Create a new document (Book) or open an existing one. A Microsoft Excel workbook is a ready-made table that you can design (format) at your own will.

Step 2

Select a table column by left-clicking on the column header. Note that the newly created column will be added to the left of the selected column. Right-click there. In the menu that opens, select "Insert" (second in the list). Column added.

Step 3

The same can be done using the "Insert" top menu item on the "Home" tab.

Step 4

If you want to add not an empty column, but copy (for example, from another table) and paste it, then you need to first select the copied column and copy it. The copied cells (in our case, the column) are now outlined with a dashed line.

Step 5

Now select the column to the right of the intended insertion point. Call the context menu by right-clicking on the header of the selected column and select the "Paste copied cells" line. Ready!

Step 6

Consider another case with a spreadsheet in Microsoft Excel. Let's add a column to the table without adding a column to the sheet. To do this, select the column to the right of the intended insertion point and call the context menu. Select "Insert …".

Step 7

In the appeared window "Add cells" select "Cells, with a shift to the right" and click "OK".

Step 8

As a result, the selected cells will move to the right, and empty cells will be added in their place, forming a new column in the table.

Step 9

Let's move on to Microsoft Word. Create a table. To do this, in the top menu, on the "Insert" tab, select "Table" and having indicated the number of rows and columns on the template, we get a table. It is more convenient for someone to select the sub-item (ibid.) "Insert table …" and in the window that opens, enter the number of rows and columns. The result will be the same.

Step 10

If you move the mouse cursor from above to any of the columns, then it will change its shape to a small black arrow directed downwards, which means that if you click at this moment with the left mouse button, the column under the cursor will be selected.

Go to the top menu on the "Layout" tab and choose how to add the column: "Insert Right" or "Insert Left".

Step 11

If you clicked on the selected column with the right mouse button, then in the context menu you would see the line "Insert" (second from the top). Hover the cursor over it and in the menu that opens, you will see the already familiar items "Insert columns on the right" and "Insert columns on the left". By using them, you will add a column to the right or left, respectively.

Recommended: