The Excel program from Microsoft Office is a powerful spreadsheet editor that allows you to not only store data in the form of rows and columns, but also perform complex calculations, as well as present the results in a graphical format.
In this article, we will analyze in detail how to manage rows located on a common sheet of a book and inside a specially created plate, and at the same time we will learn how to place an Excel column in a row. Let's take the 2007 Microsoft Office edition as the basis.
Types of string operations in Excel
The set of available operations applicable to strings is quite limited (without touching on formatting and copying issues):
- selection;
- insert;
- removal;
- moving
- transpose.
Let's see how to solve these problems in Excel 2007, and start by highlighting a row in Excel.
Highlighting a line
Very often, users of the Excel program replace the concept of "highlight a row" by highlighting the specific range of cells they need.
In Excel 2007, a line consisting of 16384 cells is available, and to select it entirely, just left-click on the numbered heading located vertically at the left edge of the sheet.
If you need to select only a few cells in a row, select it by holding down the left mouse button. Or you can stand 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 here. If all cells of the selected row are empty or filled with data, then the row will be selected immediately to the very end of the sheet, that is, to cell number 16 384. If there was a ātemplate breakā (all cells were empty and a filled one was encountered, or vice versa) , then the selection will end on the cell that ādistinguished itselfā, and it will also go into 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.
Insert a new line
It's important to know! Rows in Excel are always added on top of the selected cell (s), columns on the left.
Step one. Select one cell, or a range of cells, or the entire row, above which you plan to add a new row.
Step Two Use one of two operations to choose from:
- By right-clicking the mouse, call up the context menu, by which go to the "Paste" item, and then use the switches to select "String". Click OK, and a new line will appear above your selected cell (s), completely empty.
- On the "Home" tab of the quick access ribbon, go to the "Cells" - "Paste" - "Paste rows on a sheet" group.
Done!
As you can see, after following these recommendations, you get a completely new clean line over your data.
So, with how to add a row in Excel, we figured out.
Delete row
Like inserting a new line, when deleting it is enough to perform only two actions.
Step one. Select the line you want to delete, or simply place 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 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 data, just select the Delete button on the keyboard after highlighting.
Step Two At choice:
- By right-clicking the mouse, bring up the context menu, by which go to the āDeleteā item, and then select āLineā using the switches. Click āOKā and the line ācollapsesā, as if it never existed at all.
- On the āHomeā tab of the quick access ribbon, go to the group āCellsā - āDeleteā - āDelete rows from the sheetā.
Line moving
By moving a row, the majority again understands moving a specific small range of cells. But in this case, these options do not differ by the principle of action.
Select the entire row or its individual cells. Then move the cursor to the selection border, while the cursor should change and take the form of multidirectional arrows. While holding down the left mouse button, āgrabā your cells, move to the new desired location and release. If the place where you are moving was already filled with some data, you will automatically be prompted to replace the contents of the destination cells.
Transpose a string
Many Excel users quickly figure out how to add a line in Excel, how to move or copy, but transposition remains a mystery to many, as well as the very existence of such a function in the program.
Transposing a row is the process of converting a horizontal set of cells to a vertical one. Accordingly, transposing a column is the reverse process.
There are two options for how to perform the conversion:
- Select the range of cells of 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 āPaste Specialā context menu, where select the āTransposeā checkbox. Done! The row turned into a column.
- In Excel 2007 there is a special function - "TRANSPORT". If you are going to convert a range of five cells, then outside this range also select exactly five cells, but already located in a column. Click the equal sign and write āTRANSPORTā. Open the parenthesis and select your range that you want to convert. Close the bracket and instead of a simple Enter, press Ctrl + Shift + Enter. Done!
You must 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 the place of their values.
Tables inside the book and their features
In addition to the standard sheet of rows and columns, there are also tables in Excel. Creating them is simple - just select the desired range of cells, and then select the "Table" item on the "Insert" tab.
Let us consider how the procedures for operating with rows in such a table differ from operating with ordinary lines in a book.
It is clear that the selection of cells is the same. To insert or delete rows in the context menu, the items "Insert - Table Rows Above" and "Delete - Table Rows" are available. Alternatively, you can add a new row by simply placing the cursor on the lowest right cell of the table and pressing the Tab key.
There are also slight differences in movement, but they only apply to headings. If you select one or more cells containing the table title and move them around, you will see that the data you just copied, and the original headers have remained in place. If you try to move the entire table, then there are no features, it will move without problems.
We hope to reveal all the secrets to you regarding how to add a row in Excel, how to delete, move and transpose rows.