٤٦
٩
.
ﺔﻗﺭﻭ
ﻞﻤﻋ
ﻚﻨﻜﻤﻳ
ﻦﻣ
ﻝﻼﺧ
Sheet
ﻦﻳﺰﺨﺗ
ﻚﺗﺎﻧﺎﻴﺑ
ﻲﻓ
ﻒﻠﻣ
ﻰﻋﺪُﻳ
ﺏﺎﺘﻛ
ﻞﻤﻋ
.
ﻱﻮﺘﺤﻳ
ﻞﻛ
ﺏﺎﺘﻛ
ﻞﻤﻋ
ﻰﻠﻋ
ﺔﻗﺭﻭ
ﻞﻤﻋ
ﺓﺪﺣﺍﻭ
ﻰﻠﻋ
ﻞﻗﻷﺍ
.
ﻱﻮﺘﺤﻳﻭ
ﺏﺎﺘﻛ
ﻞﻤﻌﻟﺍ
ﺎًﻀﻳﺃ
ﻰﻠﻋ
ﻡﻮﺳﺭ
،ﺔﻴﻄﻴﻄﺨﺗ
ﺔﻗﺭﻭﻭ
ﻂﻴﻄﺨﺘﻟﺍ
ﺓﺭﺎﺒﻋ
ﻦﻋ
ﺔﻗﺭﻭ
ﻱﻮﺘﺤﺗ
ﻰﻠﻋ
ﻢﺳﺭ
ﻲﻄﻴﻄﺨﺗ
ﺍًﺪﻤﺘﻌﻣ
ﻰﻠﻋ
ﺕﺎﻧﺎﻴﺑ
ﻦﻣ
ﺔﻗﺭﻭ
ﻞﻤﻌﻟﺍ
.
ﺐﻫﺫﺍ
ﻰﻟﺇ
Desk
→
Office
→
Sheet
.
ﺐﺘﻛ
ﻞﻤﻌﻟﺍ
ءﺎﺸﻧﻹ
ﺏﺎﺘﻛ
ﻞﻤﻋ
،ﺪﻳﺪﺟ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
File
→
New workbook
.
ﺢﺘﻔﻟ
ﺏﺎﺘﻛ
ﻞﻤﻋ
،ﺩﻮﺟﻮﻣ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
File
→
Open
.
ﻢﺛ
ﻢﻗ
ﺢﻔﺼﺘﻟﺎﺑ
ﻝﻮﺻﻮﻠﻟ
ﻰﻟﺇ
ﺔﻈﻓﺎﺤﻟﺍ
ﻲﺘﻟﺍ
ﻢﺗ
ﻆﻔﺣ
ﻒﻠﻤﻟﺍ
ﺎﻬﺑ
.
ﺢﻴﻤﻠﺗ
:
ﺢﺘﻔﻟ
ﺐﺘﻛ
ﻞﻤﻌﻟﺍ
ﻲﺘﻟﺍ
ﻢﺗ
ﺎﻬﻣﺍﺪﺨﺘﺳﺍ
،ﺎًﺜﻳﺪﺣ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
File
→
Recent workbooks
.
ﻞﻤﻌﻟﺍ
ﻦﻣ
ﻝﻼﺧ
ﻕﺍﺭﻭﺃ
ﻞﻤﻌﻟﺍ
ﻝﺎﺧﺩﻹ
ﺕﺎﻧﺎﻴﺑ
ﻞﺧﺍﺩ
،ﺎﻳﻼﺧ
ﻞﻘﺘﻧﺍ
ﻰﻟﺇ
ﺔﻴﻠﺨﻟﺍ
ﺔﻄﺳﺍﻮﺑ
ﺡﺎﺘﻔﻣ
ﻞﻘﻨﺘﻟﺍ
ﻢﺛ
ﻞﺧﺩﺃ
ﺕﺎﻣﻮﻠﻌﻤﻟﺍ
ﺎﻬﻠﺧﺍﺪﺑ
.
ﺪﻳﺪﺤﺘﻟ
ﻒﺻ
ﻪﻠﻤﻛﺄﺑ
ﻲﻓ
ﺔﻗﺭﻭ
،ﻞﻤﻋ
ﻢﻗ
ﻚﻳﺮﺤﺘﺑ
ﺮﺷﺆﻤﻟﺍ
ﻰﻟﺇ
ﻝﻭﺃ
ﺔﻴﻠﺧ
ﻦﻣ
ﻚﻟﺫ
،ﻒﺼﻟﺍ
ﻢﺛ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Shift
+
ﺡﺎﺘﻔﻣ
ﻞﻘﻨﺘﻟﺍ
ﺭﺎﺴﻴﻠﻟ
.
ﺪﻳﺪﺤﺘﻟ
ﺩﻮﻤﻋ
،ﻪﻠﻤﻛﺄﺑ
ﻢﻗ
ﻚﻳﺮﺤﺘﺑ
ﺮﺷﺆﻤﻟﺍ
ﻰﻟﺇ
ﻝﻭﺃ
ﺔﻴﻠﺧ
ﻦﻣ
،ﺩﻮﻤﻌﻟﺍ
ﻢﺛ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Shift
+
ﺡﺎﺘﻔﻣ
ﻞﻘﻨﺘﻟﺍ
ﻰﻠﻋﻷ
.
ﻖﻴﺴﻨﺘﻟ
ﻕﺍﺭﻭﺃ
،ﻞﻤﻌﻟﺍ
ﺩﺪﺣ
ﺔﻴﻠﺨﻟﺍ
ﻭﺃ
ﺎﻳﻼﺨﻟﺍ
ﻲﺘﻟﺍ
ﺪﻳﺮﺗ
،ﺎﻬﻘﻴﺴﻨﺗ
ﻂﻐﺿﺍﻭ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
Format
ﺭﺎﻴﺧﻭ
ﺔﻤﺋﺎﻘﻟﺍ
ﺐﺳﺎﻨﻤﻟﺍ
.
ﻚﻨﻜﻤﻳ
ﺮﻴﻴﻐﺗ
ﺕﺎﻘﻴﺴﻨﺘﻟﺍ
ﺔﺻﺎﺨﻟﺍ
ﻂﺨﺑ
ﺔﺑﺎﺘﻛ
ﺺﻨﻟﺍ
ﻡﺎﻗﺭﻷﺍﻭ
ﻂﺒﺿﻭ
ﺓﺍﺫﺎﺤﻤﻟﺍ
ﻉﺎﻔﺗﺭﺍﻭ
ﻒﺼﻟﺍ
ﺽﺮﻋﻭ
ﺩﻮﻤﻌﻟﺍ
.
ﻖﻴﺴﻨﺘﻟ
ﺩﻭﺪﺤﻟﺍ
ﻭﺃ
ﻥﻮﻟ
ﺔﻴﻔﻠﺧ
،ﺔﻴﻠﺨﻟﺍ
ﺩﺪﺣ
Format
→
Cell appearance
→
Borders
ﻭﺃ
Background colour
.
ﺔﻓﺎﺿﻹ
ﺔﻗﺭﻭ
ﻞﻤﻋ
ﺓﺪﻳﺪﺟ
ﻞﺧﺍﺩ
ﺏﺎﺘﻛ
،ﻞﻤﻋ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
Insert
→
New worksheet
.
ﻝﻮﺤﺘﻠﻟ
ﻰﻟﺇ
ﺔﻗﺭﻭ
ﻞﻤﻋ
،ﻯﺮﺧﺃ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
View
→
Worksheets
،
ﻭﺃ
Sheets/Charts
ﻲﻓ
ﺔﻟﺎﺣ
ءﺍﻮﺘﺣﺍ
ﺏﺎﺘﻛ
ﻞﻤﻌﻟﺍ
ﻰﻠﻋ
ﻢﺳﺭ
ﻲﻄﻴﻄﺨﺗ
ﺪﺣﺍﻭ
ﻰﻠﻋ
ﻞﻗﻷﺍ
.
ﻢﺛ
ﺩﺪﺣ
ﺔﻗﺭﻭ
،ﻞﻤﻌﻟﺍ
ﻂﻐﺿﺍﻭ
ﻰﻠﻋ
OK
.
ﻅﺎﻔﺤﻠﻟ
ﻰﻠﻋ
ﺔﻳﺅﺭ
ﻑﻮﻔﺼﻟﺍ
ءﺎﻨﺛﺃ
،ﺮﻳﺮﻤﺘﻟﺍ
ﺩﺪﺣ
ﻒﺼﻟﺍ
ﻞﻔﺳﺃ
ﺔﻘﻄﻨﻤﻟﺍ
ﻲﺘﻟﺍ
ﺪﻳﺮﺗ
ﻅﺎﻔﺤﻟﺍ
ﺎﻬﻴﻠﻋ
ﻲﻓ
ﻊﺿﻭ
ﺔﻳﺅﺮﻟﺍ
.
ﻅﺎﻔﺤﻠﻟﻭ
ﻰﻠﻋ
ﺔﻳﺅﺭ
،ﺓﺪﻤﻋﻷﺍ
ﺩﺪﺣ
ﺩﻮﻤﻌﻟﺍ
ﻰﻟﺇ
ﻦﻴﻤﻳ
ﺔﻘﻄﻨﻤﻟﺍ
ﻲﺘﻟﺍ
ﺪﻳﺮﺗ
ﻅﺎﻔﺤﻟﺍ
ﺎﻬﻴﻠﻋ
ﻲﻓ
ﻊﺿﻭ
ﺔﻳﺅﺮﻟﺍ
.
ﻢﺛ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
View
→
Freeze panes
.
ﺚﺤﺒﻠﻟ
ﻦﻋ
،ﺕﺎﻧﺎﻴﺒﻟﺍ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
Edit
→
Find
.
ﻢﺛ
ﻞﺧﺩﺃ
ﺺﻨﻟﺍ
ﻭﺃ
ﻡﺎﻗﺭﻷﺍ
ﻲﺘﻟﺍ
ﺐﻏﺮﺗ
ﻲﻓ
ﺚﺤﺒﻟﺍ
،ﺎﻬﻨﻋ
ﻂﻐﺿﺍﻭ
ﻰﻠﻋ
Find
.
ﺚﺤﺒﻠﻟ
ﻞﺧﺍﺩ
ﺔﻗﺭﻭ
ﻞﻤﻌﻟﺍ
ﺎًﻘﻓﻭ
ﺮﻴﻳﺎﻌﻤﻟ
،ﺓﺩﺪﺤﻣ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Options
.
ﺓﺩﺎﻋﻹ
ﺔﻴﻤﺴﺗ
ﺔﻗﺭﻭ
،ﻞﻤﻌﻟﺍ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
Format
→
Rename worksheet
.
ﻢﺛ
ﻞﺧﺩﺃ
ﻢﺳﻻﺍ
،ﺪﻳﺪﺠﻟﺍ
ﻂﻐﺿﺍﻭ
ﻰﻠﻋ
Done
.
ﻞﻤﻌﻟﺍ
ﻦﻣ
ﻝﻼﺧ
ﺎﻳﻼﺨﻟﺍ
ﻑﺬﺤﻟ
ﺕﺎﻳﻮﺘﺤﻤﻟﺍ
ﻭﺃ
ﻖﻴﺴﻨﺘﻟﺍ
ﻦﻣ
،ﺎﻳﻼﺨﻟﺍ
ﺩﺪﺣ
،ﺎﻳﻼﺨﻟﺍ
ﻢﺛ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Clear
.
ﻲﻓ
ﺔﻟﺎﺣ
ﻙﺪﻳﺪﺤﺗ
Formats
،
ﻢﺘﻴﻓ
ﻑﺬﺣ
ﻖﻴﺴﻨﺘﻟﺍ
ﺹﺎﺨﻟﺍ
ﺎﻳﻼﺨﻟﺎﺑ
ﺓﺩﺪﺤﻤﻟﺍ
ﻲﻓ
ﻦﻴﺣ
ﻞﻈﻳ
ﻯﻮﺘﺤﻤﻟﺍ
ﺎﻬﺑ
.
ﻢﺘﻳﻭ
ﻡﺍﺪﺨﺘﺳﺍ
ﻂﻤﻨﻟﺍ
ﻲﺿﺍﺮﺘﻓﻻﺍ
.
ﻲﻓ
ﺔﻟﺎﺣ
ﻙﺪﻳﺪﺤﺗ
Contents
،
ﻢﺘﻴﺴﻓ
ﻑﺬﺣ
ﻯﻮﺘﺤﻣ
ﺎﻳﻼﺨﻟﺍ
ﺓﺩﺪﺤﻤﻟﺍ
ﻲﻓ
ﻦﻴﺣ
ﻞﻈﻳ
ﻖﻴﺴﻨﺘﻟﺍ
ﺹﺎﺨﻟﺍ
ﺎﻬﺑ
.
ﻲﻓﻭ
ﺔﻟﺎﺣ
ﻂﻐﻀﻟﺍ
ﻰﻠﻋ
All
ﻢﺘﻴﻓ
ﻑﺬﺣ
ﻞﻛ
ﻦﻣ
ﻖﻴﺴﻨﺘﻟﺍ
ﺕﺎﻳﻮﺘﺤﻤﻟﺍﻭ
ﺎﻳﻼﺨﻠﻟ
ﺓﺩﺪﺤﻤﻟﺍ
.
ﺝﺍﺭﺩﻹ
،ﺎﻳﻼﺧ
ﺩﺪﺣ
ﺔﻘﻄﻨﻤﻟﺍ
ﻲﺘﻟﺍ
ﺪﻳﺮﺗ
ﺝﺍﺭﺩﺇ
ﺎﻳﻼﺧ
ﺓﺪﻳﺪﺟ
،ﺎﻬﺑ
ﻂﻐﺿﺍﻭ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﻢﺛ
ﺩﺪﺣ
Insert
→
Cells
.
ﻚﻨﻜﻤﻳ
ﺝﺍﺭﺩﺇ
ﺎﻳﻼﺧ
ﻰﻠﻋﺃ
)
Shift cells down
(
ﻭﺃ
ﻰﻟﺇ
ﺭﺎﺴﻴﻟﺍ
ﻦﻣ
)
Shift cells right
(
ﻕﺎﻄﻨﻠﻟ
ﺩﺪﺤﻤﻟﺍ
.
ﻲﻓﻭ
ﺔﻟﺎﺣ
ﻙﺪﻳﺪﺤﺗ
ﺔﻴﻠﺧ
ﺓﺪﺣﺍﻭ
،ﻂﻘﻓ
ﻢﺘﻴﺴﻓ
ﺝﺍﺭﺩﺇ
ﺔﻴﻠﺧ
ﺓﺪﺣﺍﻭ
،ﻂﻘﻓ
ﺎﻤﻛ
ﻪﻧﺃ
ﻲﻓ
ﺔﻟﺎﺣ
ﻙﺪﻳﺪﺤﺗ
ﺔﻋﻮﻤﺠﻣ
ﻦﻣ
،ﺎﻳﻼﺨﻟﺍ
ﻢﺘﻴﺴﻓ
ﺝﺍﺭﺩﺇ
ﺔﻋﻮﻤﺠﻣ
ﺎﻳﻼﺧ
ﺔﻏﺭﺎﻓ
ﺓﺮﻇﺎﻨﻣ
.
ﺝﺍﺭﺩﻹ
ﻒﺻ
ﻭﺃ
ﺩﻮﻤﻋ
،ﺪﻳﺪﺟ
ﺩﺪﺣ
Entire row
ﻭﺃ
Entire column
,
ﻢﺛ
ﻂﻐﺿﺍ
ﻰﻠﻋ
OK
.
ﺪﻳﺪﺤﺘﻟ
ﺔﻋﻮﻤﺠﻣ
،ﺎﻳﻼﺧ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﻢﺛ
ﺩﺪﺣ
Edit
→
Select
.
ﺪﻳﺪﺤﺘﻟ
ﺔﻗﺭﻭ
ﻞﻤﻌﻟﺍ
،ﺎﻬﻠﻤﻛﺄﺑ
ﺩﺪﺣ
Entire
worksheet
ﻲﻓ
ﻞﻘﺣ
Range
.
ﺢﻴﻤﻠﺗ
:
ﺪﻳﺪﺤﺘﻟ
ﺩﻮﻤﻋ
A
،
ﺩﺪﺣ
Reference
،
ﻞﻘﺘﻧﺍ
ﻰﻟﺇ
ﻞﻘﺣ
Reference
ﻢﻗﻭ
ﺔﺑﺎﺘﻜﺑ
A:A
.
ﺔﻘﻳﺮﻄﺑﻭ
،ﺔﻬﺑﺎﺸﻣ
ﺪﻳﺪﺤﺘﻟ
ﺓﺪﻤﻋﺃ
ﻦﻣ
A
ﻰﻟﺇ
C
،
ﻢﻗ
ﺔﺑﺎﺘﻜﺑ
A:C
.
ﺪﻳﺪﺤﺘﻟﻭ
ﻒﺼﻟﺍ
1
،
ﻢﻗ
ﺔﺑﺎﺘﻜﺑ
1:1
.
ﺎًﻀﻳﺃﻭ
ﺪﻳﺪﺤﺘﻟ
ﺓﺪﻤﻋﺃ
ﻦﻣ
A
ﻰﻟﺇ
C
ﻑﻮﻔﺻﻭ
2
ﻭ
3
،
ﻢﻗ
ﺔﺑﺎﺘﻜﺑ
A2: C3
.
ﺪﻳﺪﺤﺘﻟ
ﺎﻳﻼﺨﻟﺍ
ﻲﺘﻟﺍ
ﺖﻤﻗ
ﺎﻬﺘﻴﻤﺴﺘﺑ
ﻞﺧﺍﺩ
ﺔﻗﺭﻭ
،ﻞﻤﻌﻟﺍ
ﻂﻐﺿﺍ
ﻰﻠﻋ
Menu
)
ﺔﻤﺋﺎﻘﻟﺍ
(
،
ﺩﺪﺣﻭ
Edit
→
Select
.
ﻢﺛ
ﺩﺪﺣ
Named cells
ﻲﻓ
ﻞﻘﺣ
Range