Adding rows and columns in Microsoft Excel. Adding a Column in Microsoft Excel

19.02.2017

Sometimes a user, while creating a table, forgets to enter some data. When he begins to realize that he missed valuable information or forgot to add it, he tries to fit everything he needs into the finished table. However, in this way you can make a number of mistakes, as a result of which other data may disappear, or simply nothing will change.

This usually happens to beginners who know little about the functionality of the Excel spreadsheet and how to add rows of information to a finished table. You can try several effective methods that will help you add or remove rows in the sheet and in the table itself.

How to add a row to an Excel table

Excel spreadsheet processor is the most convenient and functional program for creating tables. It has special functions that help change the appearance of ready-made documents. Both professionals and beginners can easily add lines in absolutely every corner of the object.

Method 1: Flipping the table

Method 2: adding with the “Tab” key, selecting with the “Enter” key

This method is suitable if you need to lengthen rows or add columns and cells. Here you only need a keyboard.

Method 3: adding with the "Enter" key

This method is very similar to the previous one. The key will be used again here "Enter".

Method 4: Stretch the table

You can insert a line using the mouse without using the keyboard.

Method 5: Paste via context menu

There is another way to insert an additional row.

Method 6: Adding Multiple Lines

"Insert"

"Table rows above"

How to insert lines in different places

Many people are tormented by this very question, since they often have to add rows in different parts of the table. However, this task will become long and tedious if you insert one line at a time all the time. What if there are a hundred of them, and they are located in different parts of the table? Then this method will help us.

Now you know how to add rows to various parts of the finished Excel table. As you can see, there are many ways, especially since each of them is working and simple. Perhaps the information provided will be useful to you in the future and you will use it.

Instructions

First of all, you need to find the place in that you plan to separate with an empty line. Mentally divide the text into two parts. Place your mouse cursor at the end of the first part. Press Enter. After this, the second part will move to line below. This will create two new ones, separated by an empty line.

If you are working in Microsoft Excel, you should follow different steps because "paste line"there you need to add a new one line. To do this, simply click on the table where you want the row to appear, and it will immediately appear there.

There is another way. Select that one line, after which you plan to insert an empty one. From the top menu bar, open the middle Insert tab. A list will appear. Click on the “Strings” item. After these steps, Excel will insert an empty line.

Video on the topic

Please note

To cancel the insertion of a blank line, click the “Edit” - “Undo” section.

Useful advice

If paragraphs are not required, you can simply set the text to the required line spacing, corresponding in size to the empty line. To do this, open the “Format” tab in the menu bar, then “Paragraph” - “Spacing” - “Line Spacing”. Next, set the interval size.

Sources:

Insert a specified number of empty cells across a row

The procedure for adding a row to the created Excel application included in the Microsoft Office package may be useful to the user when performing some editing operations. To carry out the procedure for adding a line, standard system tools are used.

Instructions

Click the "Start" button to open the main menu of the system and go to "All Programs" to perform the operation of adding a row to a table in the Excel application included in the Microsoft Office package.

Launch the application and open the table you want to edit.

Select the last cell of the last row of the table and press the Tab softkey to perform the procedure of adding a new blank row to the end of the table.

Enter the desired value or text into the cell below the table you want to edit to add a row, or drag down the table size guide located at the bottom right of the selected table.

Select the row above which you want to insert an additional row, and expand the “Cells” menu in the top toolbar of the Microsoft Office Excel application window.

Select the "Insert" command and click on the arrow next to the command line.

Select the “Insert table rows at the top” item to carry out the procedure for adding a row, or use the “Insert table rows at the bottom” command to add the desired row below the last row of the table.

Call the context menu of the table row to be edited by right-clicking and specify the “Insert” command to perform an alternative method of adding a row.

Select the desired action in the drop-down list or call the context menu of the cell in the desired row by right-clicking and select the “Insert” command to use another way to add a row.

Specify Table Rows Above to perform the selected operation.

Select the created new row in the Excel office table and expand the “Cells” menu in the top toolbar of the program window.

Select the “Delete” command and select “Delete table rows” (if necessary).

An alternative method for deleting a created new row is to use the “Table Rows” item of the “Delete” command of the row’s context menu, called by right-clicking the mouse.

Sources:

Add or remove rows and columns in an Excel table
how to add a row to a table in excel

You have to work with data placed in tables in different programs, but most often it is either a spreadsheet editor or a word processor from the Microsoft office suite. The method for adding rows to the spreadsheet structure in each case depends both on the application tools available for this operation and on the specific changes made to the table structure.

Instructions

There is no need to insert blank rows at the end of a table in Microsoft Office Excel format - the program does this automatically after loading the document. And to place a new one line anywhere between already filled rows, first right-click the title of the row above which you need to insert an additional line. The row header is the cell to the left of the first column, which usually contains the serial number of the row of cells. Right-clicking on it brings up a context menu on the screen - select “Paste” from the list of its commands.

If you need to insert a non-empty line, and a duplicate of one of the existing ones, before the operation described above, place a copy of it on the clipboard - select it and press the key combination Ctrl + C or select “Copy” in the context menu. Otherwise, the procedure will be no different from adding a row of empty cells.

Insert empty line You can do it a little differently - right-click any cell in the row above which you need to add a new row. The context menu in this case will also contain line“Paste” - select it and a set of insert options will appear on the screen. In it, check the box next to “ line» and press the OK button.

To insert a new row into the middle of a table in the Microsoft Office Word word processor, it is not necessary to use the context menu of the cells of the exact row that is located below the one being added. Right-click on any cell located above or below the desired position, and in the menu that appears, expand the “Insert” section. Select the desired item in it - there is both a command “Insert rows at the top” and “Insert rows at the bottom”.

When adding a previously copied line to a new location, click any cell of the row located above the one being added and expand the “Paste” drop-down list on the “Home” tab of the word processor. In it, select the command “Merge” or “Insert new rows” - both options will give the desired result.

Video on the topic

A standard sheet in an Excel workbook looks like a table, each row and each column of which has its own name or serial number. If, when entering data, you accidentally missed line, there are several ways to correct the situation.

Instructions

Open the document for editing and place the cursor in the cell above which you want to insert a new one line. Make the Home tab active in the toolbar and find the Cells section. Click on the "Insert" button. A new line will be added.

You can also select several adjacent cells and click on the same “Insert” button. Please note the following: if multiple cells in a row are selected, one new row will be added. If you select multiple adjacent cells in multiple rows, the same number of rows that you selected will be added. But if there are more selected cells vertically than horizontally, columns, rather than rows, will be added.

To avoid mistakes or confusion when adding several empty rows, it is better to select the required number of cells vertically and click on the arrow button opposite the “Insert” button in the “Cells” section. A context menu will open. Select the “Insert rows into sheet” item.

Right-click on the selected fragment and select “Paste” from the context menu. Just don’t confuse it with the “Paste from Clipboard” command; there are no thumbnails next to the menu item you need.

After that, right-click in the selected row and select “Insert” and the “Table rows above” sub-item from the drop-down menu.

Adding rows to tables created in the Excel application, included in the Microsoft Office office suite, is a standard operation of the application and is performed using standard tools without the use of additional software.

Instructions

Click the “Start” button to open the main menu of OS Windows and go to “All Programs” to carry out the procedure for adding a row to the selected Excel table.

Expand Microsoft Office and launch Excel.

Open the document to be edited and press the Tab softkey in the last cell of the bottom row of the table in order to add a blank line to the end of the selected table.

Enter the required value in the cell immediately below the selected one table to add a row or drag the size indicator in the lower right corner of the table down to add line using the mouse.

Select the table rows you want to add one or more rows under the desired placement location and expand the “Cells” menu in the top toolbar of the Excel application window.

Go to the “Home” tab of the dialog box that opens and expand the “Insert” menu by clicking on the arrow of the selected field.

Specify the desired command: - “Insert table rows from above”; - “Insert table rows from below” or call the context menu of the row to be added by right-clicking to carry out an alternative editing procedure.

Sometimes seemingly simple actions in Excel are performed in a way that is not entirely clear. So, many users experience some difficulties when they need to add a new row to their table. Of course, it is worth noting that although this action can be performed in a few mouse clicks, it sometimes carries with it completely different consequences than were planned. Moreover, each goal has its own method.

How to insert a row in Excel

In total, you can consider three ways to insert new rows in the Excel spreadsheet editor. They all depend on the goals pursued by the user. Thus, the procedure for adding a row between rows is quite different from what you need to do to add a row at the end of the table. That is why it is necessary to consider each method separately, which is what we will do now.

Method 1: Insert Between Lines

First of all, let's figure out how to add rows between rows in Excel, since this is the action that users perform most often. And it is done quite simply:

Place the cursor in the cell above which you need to add a new line.
Click the right mouse button.
In the context menu that appears, select the “Insert...” option. Sometimes it happens that there will be two “Insert” lines in the menu; be sure to select the second one.
A new window will appear in which you need to indicate what exactly you want to insert. Accordingly, set the switch to the “String” position and click OK.

If you want to speed up the process of inserting a line between lines, you can resort to using hotkeys instead of the context menu. The fact is that the “Insert” window is called up by pressing the Ctrl + “+” keys. However, note that you need to press the plus key on the number pad, which is located on the right side of the keyboard. After pressing the hot keys, the same window will appear, in which you need to select the “Line” item and press the OK button.

Method 2: Insert at the end of the table

We have figured out how to add rows between rows in Excel, but if you try to do these steps to create a new row at the end of the table, the user will fail. The row will be added, but it will not carry over the formatting of the table and will be separated from it. In this case, you will have to resort to some tricks, which we will discuss now:

Holding down the left mouse button, select the lowest row of the table you created.
Hover your cursor over the square located in the lower right corner of the selection.
Hold down the left mouse button and drag this selection down the required number of lines.
Release the mouse button.

After this, the table will expand, but the user may not be happy with this state of affairs, since along with the formatting, the text from the last row was also transferred to new rows. To fix this, follow these steps:

Select new cells from which you want to remove information.
Right-click on the selection.
From the context menu, select "Clear Contents".

Immediately after this, all text from the cells will be removed, but the formatting will remain.

Method 3: Create a Smart Table

To make working with a table even easier, you need to group rows in Excel. In other words, create a “smart” table. This will allow you not to resort to all sorts of tricks that were described in the previous method. This is done simply:

Select the entire table.
Go to the main tab.
In the panel, select Format as Table.
Select the one you like from the list of templates.

Immediately after this, a smart table will be created. Now you can add new lines to it both at the end and in the middle. This was the third way to add rows in Excel, also the last one.

Conclusion

So we figured out how to add rows between rows and at the end of the table in Excel. I would especially like to highlight the last method, which involves creating a “smart” table. Ultimately, it will make working with the data in it several times easier, which is undoubtedly an advantage.

The Excel workspace consists of several lined sheets of paper, virtually laid on top of each other like book sheets (hence the name “Book” of the document). Often these blank sheets are called tables, although strictly speaking this is not the case. In the following presentation, tables will be used to refer to the filled sections of these sheets.

Most often there is a need to insert a row or several rows at the end of a finished Excel table. To do this, you need to follow several steps.

Inserting inside a table

Suppose you need to add 3 empty lines between lines 4 and 5. This insert is similar to the one just discussed. The difference is in the first step. First, instead of the last line, you need to select 3 lines below the fourth. (Note in parentheses that to insert one line between lines 4 and 5, only the fifth line should be selected.)

After repeating steps 2 and 3, the table will take the following form.

Obviously, when you select the second line, an empty new line will be added between it and the header. To add a row to the table above the header, it must be highlighted.

How to insert non-adjacent rows? Let's assume that we need to add one blank line after the fourth and seventh lines. As part of the first step, select lines 5 and 8 (while holding down the Ctrl key). After repeating steps 2 and 3, the table will look like this:

In column D of the table, the salary is calculated using the formula shown below.

As you can see, the insertion of three lines in the middle of the table did not in any way affect the correctness of the calculations and was carried out with the formulas preserved.

Alternative methods

Some users may find the alternative selection and paste methods described below more convenient.

Selecting a complete row of a worksheet

The implementation of all the options discussed above began with highlighting the corresponding row of the completed table. There is another option for the first step - select the entire row of the sheet, including the empty cells on the right. To do this, click on the line number (or numbers).

After the second step, an empty line will immediately appear between lines 4 and 5. The fact is that the program already knows about selecting the entire line of the sheet. There is no need for a context menu to appear asking you what exactly needs to be added (step 3).

Using the Home Tab

After selecting a line or lines, there is an alternative to calling up the context menu by right-clicking on it. On the “Home” tab, go to the “Cells” section, open the “Insert” list and select “Insert rows into sheet”.

Video: How to add a line in Excel?

Versions

We looked at how to insert rows into a sheet of the most commonly used version of Microsoft Excel 2010. In the new editions - 2013 and 2016, the sequence of actions is the same.

At the same time, and not just one at a time, read the instructions below. After all, this most popular table editor from Microsoft can do a lot.

Its functionality is simply amazing. Probably not even all developers know its capabilities from “A” to “Z”.

When dealing with a large amount of data, you may encounter a situation where you need to add several empty rows at a time. Everyone probably knows how to add one at a time and, you must admit, it is very tedious to do in large volumes.

Let's take a closer look. Before that, let us remind you that the algorithm for adding a single blank line in Excel is as follows.

Click on the line number where you plan to add a blank. It will take the image of a black arrow. Call the context menu by right-clicking and click on the “Insert” menu item.

HOW TO INSERT MULTIPLE ROWS IN EXCEL

The algorithm is almost the same, with the exception of one action. Click the mouse cursor on the number, hold down the left button and select as many of them as you plan to add. After clicking the “Insert” menu, you will get the desired result.

What to do if you need to add a very large number of lines. It's not difficult here either. Place the cursor in the cell of the line (for example, in the screenshot shown it is number 5) before which you want to insert. In the Name field on the toolbar, specify a range starting with the selected number in the format:

where “295” is the number of lines by which, as a result, the selected fifth will be shifted down and press the Enter key on the keyboard. Now right-click on the selected area and select the “Paste” option.

These are two simple ways to insert several empty rows at once in Excel. If you can add anything on the topic, please write in the comments to the instructions. You can also rate it on a 5-point scale using the corresponding tool below.

P.S. For several years we have been publishing various computer tips for you, maybe useful, maybe not so much. However, we recommend viewing their full list in ours!