The Excel program from Microsoft Office ispowerful tabular editor, allowing not only to store data in the form of rows and columns, but also to perform complex calculations, as well as to present the results in graphical format.
In this article we will discuss in detail how to managethe rows that are on the general sheet of the book and inside the specially created table, and at the same time we will learn to place the Excel column in a row. We take the 2007 Microsoft Office edition as a basis.
The set of available operations applicable to strings is rather limited (without regard to formatting and copying issues):
Let's see how to solve these problems in Excel 2007, and begin with how to select a row in Excel.
Very often, the users of the Excel program replace the concept of “select a row” with highlighting a specific range of cells they need.
In Excel 2007, a line is available consisting of16384 cells, and in order to select it entirely, just left-click on the numbered header, located vertically at the left edge of the sheet.
If you need to select only a fewrow cells, select by holding down the left mouse button. Or you can step onto any cell, press and hold Shift + Ctrl and, without releasing them, press the right or left arrow, depending on which direction the selection goes.
Внимание! Здесь есть нюансы.If all the cells of the selected row are empty or filled with data, then the row will be selected right up to the very end of the sheet, i.e., to the cell with the number 16,384. , the selection will end on a cell that “distinguished”, and it will also enter the selected range. Therefore, with the key combination "Shift + Ctrl + left / right arrow" you need to be careful.
Let's move on to how to add a row in Excel.
It is important to know! The rows in Excel are always added on top of the selected cell (s), the columns on the left.
Step one. Select one cell, or a range of cells, or the entire line, over which you plan to add a new line.
Step two. Use one of two operations to choose from:
Done!
As you can see, after the implementation of these recommendations, you get a completely new blank line over your data.
So, with how to add a line in Excel, we figured out.
Like inserting a new line, when deleting, just two actions are enough.
Step one. Select the line you want to delete, or just put the cursor in any cell of the line that you no longer need.
Very important!Regardless of whether you selected a single cell or range, the entire line of the entire book will be deleted - that is, in the case of Excel 2007, these are cells from the 1st to the 16384th. If you just want to clear your cells of the data, it is enough to use the Delete button on the keyboard after selection.
Step two. At choice:
By moving the line, again, most understand the movement of a particular small range of cells. But in this case, these options do not differ in the principle of action.
Select the entire row or its individual cells.Then move the cursor to the border of the selection, the cursor should change and take the form of multidirectional arrows. Hold down the left mouse button, “grab” your cells, move to the new desired location and release. If the place where the transfer is performed has already been filled with any data, you will automatically be asked to replace the contents of the final cells.
Many Excel users understand quickly,how to add a line to Excel, how to move or copy, but the 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 into a vertical one. Accordingly, transposing a column is the reverse process.
Options for how you can perform the conversion are two:
It is necessary to understand that the first option (withspecial insert) is preferable, since it does not use formulas. If you use the second option, and then delete the original line, you get one zeros in place of your values.
In addition to the standard sheet of rows and columns, there are also tables in Excel. Creating them is easy - just select the desired range of cells, and then on the "Insert" tab select the "Table" item.
It is clear that the selection of cells is the same.To insert or delete rows in the context menu, the items “Insert - Rows of the table above” and “Delete - Rows of the table” are available. In addition, you can add a new row by simply placing the cursor on the lowest right cell in the table and pressing the Tab key.
There are also slight differences in displacement, butthey only concern headlines. If you select one or several cells containing the table header and move them, you will see that the data you just copied, and the original headers remained in place. If you try to move the entire table, then there are no features, it will move without problems.
We hope that you have revealed all the secrets about how to add a line in Excel, how to delete, move and transpose lines.
