How to add a row to Excel: recommendations, examples

The Excel program from Microsoft Office is a powerful spreadsheet that not only stores data in the form of rows and columns, but also produces complex calculations, and also presents the results in a graphical format.

In this article, I'll discuss in detail how to manage the lines that are on the general sheet of the book and inside a specially created table, and at the same time learn how to place an Excel column in a row. As a basis, let's take the 2007 edition of Microsoft Office.

Types of operations with strings in Excel

The set of available operations that apply to strings is rather limited (without addressing the issues of formatting and copying):

• Allocation;
• insert;
• Removal;
• Moving;
• Transpose.

Let's see how to solve these tasks in Excel 2007, and start with how to select a line in Excel.

Select a row

Very often, the users of the Excel program substitute the notion of "highlighting a line" for selecting a particular range of cells that they need.

In Excel 2007 there is a line consisting of 16384 cells, and to select it entirely, it is enough to click on the numbered header located vertically at the left edge of the sheet with the left mouse button.

If you only need to select only a few cells in a row, select the selection by holding down the left mouse button. Or you can click on any cell, press and hold the Shift + Ctrl keys and, without releasing them, press the "right" or "left" arrow, depending on which direction the selection will go.

Attention! There are nuances. If all the cells of the selected row are empty or filled with data, the line will be highlighted immediately to the very end of the sheet, that is, to the cell with the number 16 384. If there was a "break of the template" (all cells were empty and met filled, or vice versa) , Then the selection will end on a cell that has "distinguished itself", and it will also enter the selected range. Therefore, with the keyboard shortcut "Shift + Ctrl + left arrow / right arrow" you have to be neat.

Let's move on to how to add a line to Excel.

Insert a new line

It is important to know! The rows in Excel are always added from above with respect to the selected cell (s), the columns to the left.

Step one. Select one cell, or a range of cells, or the entire line, above which you plan to add a new line.

Step two. Take advantage of one of two options:

• Right-click on the context menu, go to "Paste", and then use the radio buttons to select "Line". Click OK, and a new line appears above your selected cell (s), completely empty.
• On the Home tab of the Quick Access ribbon, go to the Cells group - Insert - Insert rows per sheet.

Done!

As you can see, after the implementation of these recommendations, you get an absolutely new blank line over your data.

So, with how to add a line to Excel, we sorted it out.

Delete row

Like inserting a new line, when deleting it is enough to perform only two actions.

Step one. Select the row you want to delete, or simply place the cursor in any cell in the row that you no longer need.

Very important! Regardless of whether you have selected a single cell or a range, the whole row of the entire book will be deleted - that is, in the case of Excel 2007, these are the cells from the 1st to the 16384th. If you just want to clear your cells of data, just use the Delete button on the keyboard.

Step two. The choice:

• Right-click on the context menu to go to the "Delete" item, and then use the switches to select "Line". Click "OK", and the line will "curl up", as if it never existed at all.
• On the Home tab of the Quick Access ribbon, go to the Cells group - Delete - Delete rows from the sheet.

Moving a row

When moving a line, most again understand the movement of a particular small range of cells. But in this case, these options do not differ according to the principle of action.

Select the entire line or its individual cells. Then move the cursor to the selection border, and the cursor should change and take the form of differently directed arrows. Hold down the left mouse button, "grab" your cells, move to a new location and release. If the place where the move is already filled is already filled with any data, you will automatically be prompted to replace the contents of the final cells.

Transpose a string

Many Excel users quickly understand how to add a line to Excel, how to move or copy, but transposition for many remains a mystery, as well as the very existence of such a function in the program.

Transposing a string is the process of converting a horizontal set of cells to a vertical one. Accordingly, transposing a column is the reverse process.

Option, how can you perform the conversion, two:

• Select the range of cells in one row and copy (by right-clicking or Ctrl + C). Next, go to the cell with which you would like your new data column to start, call the "Special Paste" context menu, where the "transpose" checkbox is selected. Done! The line has become a column.

• In Excel 2007 there is a special function - "TRANSP". If you are going to convert a range of five cells, then outside this range, select exactly five cells, but already located in the column. Click on the "equals" sign and write "TRANSP". Open the parenthesis and select your range that you want to convert. Close the parenthesis and press Ctrl + Shift + Enter instead of the simple Enter. Done!

It is necessary to understand that the first option (with a special insert) is preferable, since it does not use formulas. If you use the second option, and then delete the original string, you will get one zeros in place of your values.

Tables inside the book and their features

In addition to the standard sheet of rows and columns, there are also tables in Excel. To create them simply - just select the desired range of cells, and then on the "Insert" tab select the "Table" item. Let's consider, than procedures of operations by lines in such table from operation with usual lines in the book differ.

It is clear that the selection of cells is the same. To insert or delete lines in the context menu, the items "Paste - Rows of the table above" and "Delete - Rows of the table" are available. In addition, you can add a new line by simply positioning the cursor on the bottom right cell of the table and pressing the Tab key.

There are also small differences in the movement, but they only affect headings. If you select one or more cells containing a table header and move them, you will see that the data you just copied, and the original headers were left in place. If you try to move the entire table, then there are no features, it will move without problems.

We hope that we have revealed to you all the secrets regarding how to add a line to Excel, how to delete, move and transpose the lines.