Starting in 2007, spreadsheets in Microsoft Office Excel can have 18278 columns per sheet in a document. No special procedure for adding the next column to the right of the last column within this amount is not required, just move the cursor to the next empty column and start entering data. There are several ways to insert additional columns to the left of existing table columns.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
Start the table editor, open the sheet of the required document in it and right-click the column to the left of which a new column should be added.
Step 2
In the context menu, select the line "Insert", and Excel will show a small window in which you need to check the box next to the inscription "Column". This can be done either by clicking the mouse pointer or by pressing the "b" key. Click the OK button or the Enter key and the empty column is added to the table.
Step 3
This operation can be shortened by first selecting a column, rather than clicking on a separate cell in it. To do this, click on the column header first with the left and then with the right mouse button. The pop-up context menu will also have the "Insert" item, but its selection will not open an additional window - Excel will add an empty column to the table without additional questions.
Step 4
If you need to insert not one, but two, three or more empty columns following one after another, select the required number of existing table columns. This can be done by flipping their titles with the left mouse button while holding down the Ctrl key. Then repeat the operation described in the previous step. A group of new columns will be added in front of the left column of the column range you selected.
Step 5
In the same way, you can simultaneously add several non-consecutive columns - select the columns, to the left of which new columns should appear, and repeat the operation from the third step. In this case, you can also select two or more columns, but this number must be the same for each selected group. That is, if you select, for example, one column, and after three columns there are two more columns, then Excel will display an error message when inserting.
