??? ????????? ??? ???????? ??? Excel?

?????? ????????? ?????? ?????????
???? ???????: 843504 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??? ??????? ???????? ??????? ??????? ??????? ??????? ?? Microsoft Excel ????? ?? ???? ??? ?????? ??????? ??????????. ??? ???? ??????? ?? ???? ?????? ????? ???? ?????? ????? ?????? ??? ????? ?? ???? ???? ?? ???? ?????? ?????? ??? ??????. ?? ?? ???? ?????? ????? ???? ?????? ???? ?????? ?????? ?? ??? ????? ??????? ???? ?????? ?????? ?????? ??? ??????.

?????

???? ??? ??????? ??? ????????? ??? ????? ??????? Microsoft Excel.

??????? ????

??? ???? ??????? ?? ????? ??????

????? ?? ???? ??????? ?? ????? ?????? ?? ???? ???????? ???????? ??????? & ?? ?????? ?CONCATENATE? -- ??? ???? ??????? ??? ??? ?????? ???????? ??????? ?? ??????? ?? A1 ??? C2:

?? ??? ??????????? ??? ??????
A1: ????? ?????B1: ????? ??????C1: ????? ??????
A2: ????B2: ???????C2: ????

?????? ????? ??????? ?? ?????? D2? ???? ???? ???????? ?????????:
??$D$2: =CONCATENATE?(A2,?" ",B2," ",C2)?
?$D$2: =A1?&?" "?&?B2?&?" "&?C2?
?????? ??? ??????? ??????? (" ") ???????? ??? ??????? ?????? ????? ??? ???? ???????.

????? ????? ???????

????? ?? ??????? Microsoft Excel 97 ????? ????? Windows? ??? ????? ?? ???? ??????? ????? ????? ??????? ??? ??????? ???. ??? ????? ??? ?? ???? ??????? ????? ????? ???????? ????? ????? ????? ??????? ??? ??????? ??????. ???? ????? ?? ???? ??????? ????? ????? ??????? ??? ???? ????? ?????? ????? ????? ??? ????? ????? ??????? ?????? ????? ??????? ?????? ??? ?????? ?????? ??????.

?????? ?? ???? ??????? ????? ????? ??????? ?? Excel? ???? ??????? ???????:
  1. ?? ??????? ???? ??? ??? ????? ???????? ?? ???? ??? ?????.
  2. ???? ??? ????? ??????? ???????.
  3. ?? ??????? ???? ??? ???? ?? ?? ???????? ????? ??? ???? ?? ???? ??????? ????? ????? ???????.
  4. ???? ??? ????? ????? ???????? ?? ???? ????? ??? ??? ????? ??????? ????????.

??????? ??????? ??????? ?? ?????

?? ???? ????? ????? ????? ????? ??? ????? ?????? ????? ?????? ????? ?????? ?????? ????? ????? ?????? ??????? ?? Excel.

?????? ????? ???? ??????? ???????:
  1. ???? ???????? ??????? ???????? ?? ??????? ?? A1 ??? A10 ?? ???? ????:

    ?? ??? ??????????? ??? ??????
    A1: ???????
    A2: ??????
    A3: ?????
    A4: ???????
    A5: ?????
    A6: ???????
    A7: ??????
    A8: ??????
    A9: ???????
    A10: ??????
  2. ?? ??????? ??????? ??? ??? ?????? ?? ???? ??? ????? ??????.
  3. ?? ?????? ???? ??? ??? ???.
  4. ?? ???? ???? ???????? ???? ?$A$1:$A$10?.
  5. ???? ??? ??????? ??????? ???? ????? ?$B$1? ?? ???? ??? ???? ?? ???? ??? ?????.

    ???? ??????? ??????? ??????? ?? ?????? B:

    ?? ??? ??????????? ??? ??????
    B1: ???????
    B2: ??????
    B3: ?????
    B4: ???????
    B5: ???????
???? ?? ??? ??????? ???? ????? ??????? ????????. ????? ????? ???? ??? ??????? ????? ????? ?????? .

??? ????? ?????? ?? 1 ???????? ?? ?? ??? ?????

?? ??? ??????? ????? ???? ???????? ????? ?? ????? ????? ?? ???? ????? ??????? ?? ???? ????? ?????? ????? ????? ??? ????. ??? ??? ???????? ?? ?????? ??? ????? ??? ?????. ??? ??? ?????? ???? ?? ??? ??? ????? ?????? ?? 1.

?????? ????? ??????? ???? ??????? ???????:
  1. ???? ??? ???? ????? ?? ???? ?????? ????? ?? ?? ?????? ???? ????? ???? ?? ???? 1 ?? ??????.
  2. ???? ??? ??? ?? ??????? ????? ????? ????? ?????? ???????.
  3. ??? ?????? ???? ????? ??? ????? ??????? ??????? ??? ?????.
  4. ?? ??????? ?????? ???? ??? ??? ???.
  5. ?? ???????? ???? ??? ???? ?? ???? ??? ?????.
???? ??? ??????? ?????? ???? ??? ?????. ????? ????? ?? ??? ??? ?? ???? ?? ????? ????? ?????? ?? ???? ??? ?????? ???????. ?? ???? ??????? ??????? ????? ????? ?????? ????? ??? ??????? ???? ??? ??? ?? ????? ????? ????? ?????? ?????? ????? ?????? ??? ??????.

??????? ????? ??????? ???? ?????? ???? ??? ?????

?????? ????? ???? ??????? ???????:
  1. ??? ?????? ???? ????? ??? ????? ??????? ??????? ??? ?????.
  2. ?? ??????? ??????? ???? ??? ???? ??? ?????.
  3. ???? ??? ?????? ????? ???????? ??? ?????? 3 ?? ???????.
  4. ?? ???? ???????? ????? ?????? ??????? ???? ??? ???? ?? ???? ??? ?????.
???? ??? ??????? ?????? ???? ??? ?????. ????? ????? ?? ??? ??? ?? ???? ?? ????? ????? ?????? ?? ???? ??? ?????? ???????. ?? ???? ??????? ??????? ????? ????? ?????? ????? ??? ??????? ???? ??? ??? ?? ????? ????? ????? ?????? ?????? ????? ?????? ??? ??????.

??? ??????? ??????? ?? ??????? ?????? ????????

???? ??? ??? ?????? ??????? ?????? ???????? ?????? ?? ??????? ?? A1 ??? A6:

?? ??? ??????????? ??? ??????
A1: 1.1.0
A2: 1.10.0
A3: 1.2.0
A4: 1.20.0
A5: 1.21.1
A6: 1.3.0

??? ??? ??????? ?????? ????????? ???? ??????? ???? ???????. ????? ??????? ?????? ???????? ???? ??????? ???? ??? ?????? ??. ????? ??? ???? ??? ??????? ???????? ??? ???????? ???????? ?????? ????? ??????? ????. ?????? ????? ???? ??????? ???????:
  1. ??? ??????? ?? A1 ??? A6.
  2. ?? ??????? ??????? ???? ??? ???? ??? ?????.
  3. ?? ?????? ?????? ?? ????? ??????? ????? ???? ??? ???? ?? ???? ??? ??????.
  4. ?? ???? ???????? ????????? ???? ?????? ????? ?? ????? ???????? ?? ??? ???? ???????? ??? ???. ?? ???? ???????? ??? ???? ???? . (????)? ?? ???? ??? ??????.
  5. ?? ?????? ???????? ???? ?$B$1? ?? ???? ?????? ???? ?? ??? ??????? ??? ??????? ?????? ???????? ??????? ?? ???? ??? ?????.

    ???? ??????? ?? ??????? B ?C ?D.
  6. ??? ??????? ?? A1 ??? D6.
  7. ?? ??????? ??????? ???? ??? ???.
  8. ?? ??????? ??? ???? ???? ??? ?????? B.
  9. ?? ???? ?? ???? ???? ??? ?????? C.
  10. ?? ??????? ?? ???? ???? ??? ?????? D? ?? ???? ??? ?????.
???? ??????? ???? ?? ????? ?? ?????? A.

??????? ????? ?????? ?????? ????? ??? ?????

??? ????? ????? ??? ?????? ?????? ????? ?????? ??????? ??????. ??????? ???? ??? ???? ?????? ????????? ?? ???? ??? ????? ?? ??????? ??????.
?? ??? ??????????? ??? ??????
Public/EN-US/Office/Excel/843504A.gif

????? ??????? ?? ????? ??????

??? ???? ????? ??????? ?????? ?? ???? ???? ????? ???? ?CTRL+;? ?? ???? ????? ENTER. ??????? ????? ?????? ?? ???? ???? ????? ???? ?CTRL+:? ?? ???? ????? ENTER.

??? ???????? ?? ????

??? ????? ???? ?? ????? ???? ?CTRL+SHIFT+A? ???? ???????? ?? ????. ??? ????? ?=RATE?? ?? ????? ??? CTRL+SHIFT+A? ????? ??? ?? ???????? ?????? ???? ?????? -- ??? ???? ??????? ?=RATE?(nper,pmt,pv,fv,type,guess)?. ??? ???? ?????? ??? ???? ?? ????????? ???? ?=RATE?? ?? ???? CTRL+A ???? ????? ???????.

????? ??? ???? ?? ?????? ?? ???? ?????

??? ???? ????? ??? ???? ?? ??? ?????? ?? ???? ?? ??????? ???? ????? ???? ??????? ???????:
  1. ??? ???? ??????? ??????? ??????.
  2. ???? ???? ?? ?????? ???? ??? ?? ???? ????? ENTER. ????? ?? ???? ???? CTRL+ENTER.
???? ???????? ?? ?????? ???? ??? ???????.

??? ???? ?? ??????? ????

?????? ????? ???? ??????? ???????:
  1. ??? ???? ??????? ?????? ???? ??? ???? ?? ????? ??? ???? ?????? ?? ???? ?????? ?????? ???? ????.
  2. ?????? ??????? ??? ???? ??????? ???? ???? ???? ?????? ?? ???? ????? F2.
  3. ???? ???? ???????? -- ??? ???? ??????? ???? ?=A1?? ?? ???? ????? ENTER.
???? ???? ???? ??? ??????? ?? ?????? ???????? ?? ???? ???? -- ??? ???? ?????? A1. ????? ??? ???? ???? ??? ?? ???? ??? ?? ?????? ???? ?????.

??? ???? ????? ?????

????? ??? ???? ?? ??????? ?? ??? ?????? ??????? ?? ???? ???. ??? ?????? ????? ????? ???? ??????? ??????? ?? ?? ???? ??? ???? ????? ??????. ?????? ??????? ??? ??????? ?????? ????? ??? ??????? ?? ???? ?????. ??? ??? ??? ?????? ???????? ?????????? ???? ??? ??????? ??? ?? ?? ??????? ????????. ?????? ???? ??????? ???? ??????? ???????:
  1. ??? ???? ???????.
  2. ?? ??????? ?????? ???? ??? ???.
  3. ??? ?????? ???? ???? ?? ???? ???? ??????.
  4. ?? ??????? ?????? ???? ??? ??? ?????? ?????? ????? ????? ???????? ??? ????? SHIFT.
???? ???? ??? ??????? ???? ??? ????? ?? ??????? ?????? ?? ?? ???????.

??????? ????? ?????? ??????? ????????

?? ???? ????? ???? ????? ?? ???? ????? ??? ?? ???? ??? ??????? ????????? ???? ?????? ?????? ??? ?? ?????? ?? ???? ??????? ?? ???? ????? F9. ??? ?????? ????? ??? ????? ????? ?????? ?? ?????? ???.

??? ??? ??? ?????? ??? ????? ENTER? ????? ??? ????? ?? ??????. ????? ???? ?? ????? ??? ????? ESC ????? ?? ????? ENTER. ????? ??? ??? ?????? ??? ????? ENTER ?? ???? ?????? ???? CTRL+Z ??????? ?? ???????.

??? ????? ?????? ???? ???????

?????? ????? ??? ????? ??? Microsoft Excel 97 ????? ????? Windows ???.

????? ???? ?????? ?????? ?????/????? ????? ??? ??? 39 ??????? ?? ???? ???? ??? ??????? ???? ?? ???? ????? ???? ?? ?????? ????????? ?? ???? ?? ???????? ??????? ??? ??????. ??? ????? ??? ?????/????? ??? ???? ??????? ????? ?? ????? ?????? 40 ??????? ?? ????? ??? ????? ???????? ?????????? ???? ???? ?????? ??????? ??????????. ???? ?? ??? ?????? ??? ?????? ?? ????????? ?????? ?? Microsoft Excel.

????? ??????? ??????? ???????? ?? ???? ???????? ?? ???? ?????

??? ????? ??????? ??????? ?? ?????? A:
?? ??? ??????????? ??? ??????
Public/EN-US/Office/Excel/843,504B.gif
???? ??????? ???? ????? ???? ??????? ?? ??????? ???????. ?????? ????? ???? ??????? ???????:
  1. ??? ??????? ?? A1 ??? A10.
  2. ?? ??????? ?????? ???? ??? ???????? ???.
  3. ???? ??? ???? ????? ??? ????????? ?? ???? ??? ?????.
  4. ???? ?=a1?? ?? ???? CTRL+ENTER.

    ??? ???? ??? ?????? ??? ????? ??????? ?? ??????? ??????? ???? ??? ????????.
  5. ??? ??????? ?? A1 ??? A10.
  6. ?? ??????? ?????? ???? ??? ???.
  7. ?? ??????? ?????? ???? ??? ??? ???.
  8. ?? ?????? ???? ???? ??? ?????? ?? ???? ??? ?????.
??? ????? ??????? ?? ???????.

??????? ?? ???? ???? ??? ???? ????

????? ????? ??? ????? F4 ??????? ??? ????? ?????? ?????? ??????? ????? ????? ?????. ??? ????? ???? ?? ???? ??????? ?????? ???? ???? ?????? ????? ???? -- ??? ???? ??????? ?????? A1. ??? ????? ??????? ???? ????? F4 ??? ??? ????? ???? ?????? ???????? ??? ???? ???? ???? -- ??? ???? ??????? ?$A$1?. ????? ????? ????????? ?? ????? ??? ????? F4 ???? ????? ????? ????? ?????? ??????.

????? ?? ????????? ??? ???? ??????? ???? ??? ????? ??????? ??? ???????? ?? ??????? Microsoft Excel? ????? ???? ?????? ?? ???? ????? ??????? ??? ????? ????? ??? ??????? ??????? ????????.

??????? ???? OFFSET ?????? ?????? ??????? ???? ??? ???????

?? ???? ??????? ???????? ??????? ?? ??????? ?? A1 ??? A7 ?? ???? ??? ???? ?????? ?? ???? ????? ??????? ?? ??????:

?? ??? ??????????? ??? ??????
A1: 1
A2: 2
A3: 3
A4: 4
A5: 5
?A6:?
A7: ?=A5-A1?

????? ??? ???? ??????? ???? ??? ?????? ??? ??? ???? ????? ?? ???? ???? ????? ??? ?????? ??????? ??????? ???? ????? ??? ????????. ?? ???? ????? ?? ???? ?? ?????? ??????? (??? ???? 6 ?? ?????? ??????)? ???? ???? ???? ???? ?????? ???? ???????? ???????? ?? ?????? A1 ?? ???????? ???????? ?? ?????? A6 ????? ?? ????? ?? ???????? ???????? ?? ?????? A5.

???? ??? ?? ??? ??????? ?? ???? ?????? ?=A5-A1? ???? ???????? ???????? ?? ???? A6 ????? ???? ?????? ?? ????? ??? ?????? ?? A6.

?????? ????? ?????? ???? OFFSET ???? ?????? OFFSET ?????? ???? ??? ???? ????? ?? ??? ???? ?? ?????? ???????? ?? ???? ?? ???? ?? ???????. ?? ??? ??????? ?????? ?????? ???????:
?=OFFSET(A6,-1,0)-A1?
?? ??? ????? ?????? OFFSET ??? ???? ??????? ???? A6 ??? ????? ?????? ??? ????? ???? ?????.

??????? ??? "????? ??????"

?? ???? ????? ????? ?????? ?? Excel? ????? ????? ????? ????? ?? ????? ??? ???? ????? ?????? ????? ????? ?????? ??????? ?? Excel. ???????? ??? ?????? ??? ??? ????? ?? ??????? ??????? ?? ???? ??? ????? ??????? ?? ???? ????????? ???? ???? ??? ??????. ??? ?? ??? ??????? ?? ????????? ???? ?????? ??? Excel? ???? ??????? Microsoft Excel.

??????? ??????? ?????? ?????? ????????

???? ??? ??? ?????? ????? ?????? ?? ??????? ?? A1 ??? A10 ???? ???? ??? ?? ????? ?????? ?? 50 ???? ?? 200. ?????? ????? ?????? ???? ?????? ???????:
?=SUM?(IF?(A1:A10>=50,IF?(A1:A10<=200,A1:A10,0)?,0)?)?
?????? ???? ?? ????? ?????? ????? ?????? ??? CTRL+SHIFT+ENTER. ??? ?????? ????? ???? ????? ?????? {} ??? ??????. ?? ????? ????? ??????? ??????.

?????? ?????? ????? IF ????????? ??? ???? ?? ?????? ????? ?????? ?????? ?????? ??? ?? ???? ??????? ?????? ????????.

??????? ??????? ?????? ????? ????????

???? ??? ??? ?????? ????? ?????? ?? ??????? ?? A1 ??? A10 ????? ???? ?? ????? ?????? ?? 50 ???? ?? 200. ?????? ????? ?????? ???? ?????? ???????:
?=SUM?(IF?(A1:A10>=50,IF?(A1:A10<=200,1,0)?,0)?)?
?????? ???? ?? ????? ?????? ????? ?????? ??? CTRL+SHIFT+ENTER. ??? ?????? ????? ???? ????? ?????? {} ??? ??????. ?? ????? ????? ??????? ??????.

?????? ?????? ????? IF ????????? ??? ???? ?? ?????? ????? ?????? ????? ??? ???????? ?? ???? ??????? ?????? ????????.

??????? ????? INDEX ?MATCH ????? ?? ????????

???? ??? ??? ?????? ???? ????????? ?????? ?? ??????? ?? A1 ??? C5 ??? ??? ?????? ????? ??? ?????? ????? ?? ??????? ?? C1 ??? C5:
?? ??? ??????????? ??? ??????
Public/EN-US/Office/Excel/843504C.gif
????? ????? ??? ???? ????? ?? ??? ??? ??????? ???????? ??? ?????. ?????? ????? ?????? ??? ???????? INDEX ?MATCH ??? ?? ???? ?? ????? ?????? ???????:
?=?INDEX?($A$1:$C$5, MATCH?("Mona",$A$1:$A$5,)?,3)?
?????? ????? ??? ?????? ??????? ?? A1 ??? C5 ????????? ?????? ????? ?????? ?? ??? Mona ?? ?????? ??????. ???? ?????? ?????? ?????? 22.

??? ???? ??????? ?????? ????? ?? ???????

?? ???? ??? ???? ????? ??????? ????? ??? ??????? ??? ?????? ??? ??????? ?????? ???????? ?? ??? ???? ?? ??? ??????. ??? ???? ?????? ????? ??? ??? ?? ????? ?? ???? ????? ???? ???? ?? Excel ????? ?? ?????? ??? ????? ????? ????? ?? ?????. ??? ???? ??????? ??? ???? ?????? ????? ??? ?????? "?????"? ????? ????? ??????? ?????? ???????? ?? ???? ?? ?? ?????? ?????? "??????" ?"????" ?????. ????? ????? ????? ????? ????? ????? ???????? ???? ?????? ?????????? ??? ????? ???????? ?????? ???????.

????? ???????? ????????

????? ????? ??? ???? ????? ?????? ??????? ????? ??????? ?????? ??????? ?????? ??? ?????? ?? ?????? ???? ??? ?????? ??????? ?? ?????? ???????. ??? ???? ??????? ??? ??? ?????? ???????? ?? ??????? ?? A1 ??? A20? ?????? ???? ?? ?? ?? ?????? B1? ?????? ??? ????? ENTER? ?? ????? ??? ???? ??????? ????? ???????? ???? Excel ?????? ???????? ???? ???????? ???????? ?? ?????? ???? ?? ?????? B1 ??? ?????? B20.

??????? ???? VLOOKUP ?? ???????? ???? ?? ??? ?????

?? Excel 97 ????? ????? Windows ?????????? ??????? ???? ?????? VLOOKUP ??? ????????? ?? ???????? ???? ?? ??? ?????. ??? ????? ?? ???? ??? ????? ????? ?????? ??? ??????. ?? ??????? ?? ???? ???? ??????? Range_Lookup ?? TRUE ???? ??? ?? ??? ?????? ????. ???? ?? ??????? Range_Lookup ?? ??????? ???????. ???? ???? ?????? ??????? ?? ????????? ?????? ?? Excel.

???? ???? ?????? VLOOKUP ???? ???? ???? ?? ???????? ???? ?? ??? ?????? ?? ?????? ??????? Range_Lookup ??? ?????? FALSE. ????? ??? ????? ???? ????? ?? ??? Ibrahim ?? ???? ???????? ???? ?????? ?????? ?? ??? "??????? ????? INDEX ?MATCH ????? ?? ????????":
?=VLOOKUP?("Ibrahim",$A$2:$C$5,3,FALSE)?

????? ????? ??????

???? ??? ??? ?????? ???? ???????? ?????? ?? ??????? ?? A1 ??? A12? ????? ?????? ??? ?? ??? ???? ????? ?????? ?? ?????? ?? ??? ??????? ?? ?????? ???????:
?? ??? ??????????? ??? ??????
Public/EN-US/Office/Excel/843504D.gif
?????? ????? ?????? ???? ROW ???????? ??? ???? OFFSET -- ??? ???? ??????? ?????? ????? ?????? ???????:
?=OFFSET?($A$1,ROW?()?*3-1,0)?
????? ??? ?????? ??? ?? ?????? ???? ?? ???? ????? ??????. ?? ??? ??????? ???? ?????? ROW ?????? ??? ?? ?????? ???? ?? ???? ????? ??????. ??? ??? ??? ????? ?? 3. ???? ?????? OFFSET ???? ?????? ?????? ????? ?? ?????? A1 ?????? ??? ?????? ?????? ?????? ????? ??????.

??????? ??? ???? ??? ????

???? ??? ??? ?????? ????? ??????? ?? ??????? ?? A1 ??? A3 ??? ???? ???:

?? ??? ??????????? ??? ??????
A1: =1.23/2
A2: =1.21/2
A3: ?=SUM?(A1:A2)?

???? ??? ?????? Excel ?? ?????? ?????? ????? ????? ????? ??? ????? ???????? ???????? ????? ???????. ??? ????? ????? ???????:

?? ??? ??????????? ??? ??????
A1: $0.62
A2: $0.61
A3: $1.22

???? ???? ???????? ??????? ?? ?????? A3 ??? ??????. ???????? ?? ??? ??? ????? ?? ?? ????? ????? (??????) ???? ?????? ????? ????????? ?? ??? ????? ????? ???????? ??? ???? ??? ????. ???? ?? ??? ??????? ???????? ???? ROUND . ??? ???? ??????? ??? ????? ????? ??? ?? ???:

?? ??? ??????????? ??? ??????
A1: ?=ROUND?(1.23/2,2)?
A2: ?=ROUND?(1.21/2,2)?
A3: ?=ROUND?(SUM?(A1:A2)?,2)?

????? ??????? ??????? ?? ?????? ROUND ?? Excel ????? ???? ???? ??????. ??? ??? ??????? ???? ??????? ??????? Excel ???? ???????? ??? ???? ????.

????? ??????? Microsoft Excel ??????????

???? ??????? Microsoft Excel ??????? ????? ?? ??????? ??? ????? ??????? ???? ?? ????????? ?? ???? ????? ??????? ?? ????? ?? ?????? ?????? ????? ????? ?? ?????????. ????? ????? ??????? ??????? ???? ?????? (?????? ??? F1) ???? ????????? ???? ????? ???????.

??? ????? ????? ????????? ??? ????? ?????? ?????. ?? ???? ??? ????? ?????????? ?? ?????? ?????? ??????? ??? ????? ?? ???? ??? ?????/????? ?????? ???????.

?? ??? ???? ??? ????? ?? ????? ????? ??????

??? ??? ????? ???? Excel ?????? ????? ????? ?? ?????? ???? ??? ??? ??? ????? ??? ?????? ???? ?? ??? ?????? ???. ??? ??? ??? ??????? ??????? ??? ????? ?????. ???? Excel ????? ?????? ???? ?? ????? ??? ??????? ??? ??? ?????. ?? ???? ??? ???????? ??? ??? ???? ???? ?? ??? ??? ?? ??? ?? ??? ???? ????? ????? ????? ???? ????? ??? ????? ?????.

????? ???????? ????? ??? ????? ??? ????? ?????? ??? ?????????. ???? ????? ?????????? ?? ???? ????? ??? ????? ??????? ?? ????? ???? ??? ????? ?????.

????? ???? ??? ?? ????? ???? ?????? ??? ??????? ??? ?????

?????? ????? ???? ????? ??? ?????? ??????? ?? ???? ?????? F11. ?????? ???? ??? ?????? ???? SHIFT+F11.

????? ????? ????? ?????? ?? ??? ???? ?????

????? ????? ????? ????? ?????? ?? ??? ???? ????? ??? ??????? ?????. ?????? ????? ?????? ????? "??? ??? ?????" ?????? "????? ?????". ???? ?????? ?????? ??? ??? ???? ????? ?? ????? ????? ???? ????? ???? ??? ?????????. ????? ?? ?????????? ???? ??????? Microsoft Excel.

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
142529 XL: ????? ????? ??? ??? ?????? ?????? ????? ???????.

???????

???? ???????: 843504 - ????? ??? ??????: 28/?? ??????/1427 - ??????: 1.2
????? ???
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Office Excel 2003
????? ??????: 
kbfunctions kbhowto kbinfo KB843504

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com