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 to 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
«» « » .
« 2007» , 16384 , , , , .
, , . , Shift + Ctrl , , «» «», , .
! . , , . . 16 384. « » ( , , ), , «», . «Shift + Ctrl + /» .
, Excel.
! «» (), – .
. , , , .
. :
- , «», «». «», () , .
- «» «» - «» - « ».
!
, .
, , Excel, .
, .
. , , , .
! , , - « 2007» 1- 16384-. , Delete .
. :
- , «», «». «», «», .
- «» «» - «» - « ».
. .
. , . , «» , . , , - , .
«» , Excel, , , .
– . , – .
, , :
- ( Ctrl + C). , , , « », «». ! .
- Excel 2007 – «». , , . «» «». , . Enter Ctrl + Shift + Enter. !
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., . « – » « – ». , , Tab.
, . , , , , , . , , .
, , Excel, , .