**
Format Menu **
1.
Cell (‡mj msSvš— wewfboe
†mwUs) t
Spreadsheet Analysis Software
(Microsoft Excel) Gi g‡a¨ KvR Kivi mgq
wewfboe †mj‡K g‡bi B‡”QgZ
†mwUs Ki‡Z nq| †h †Kvb GKwU Kv‡Ri di‡gU
ˆZix Kivi Rb¨ Format Menu Gi Aaxb¯’ Cell Gi mvnvh¨ wb‡Z
cvwi| Gi gva¨‡g Avgiv Number Setting, Alignment, Font, Border, Pattern, Protection BZ¨vw` KvR Ki‡Z
cvwi| g‡b ivL‡Z n‡e †h †h KqwU Cell ‡K wb‡q †mwUs Ki‡Z PvB
†mB Cell ¸‡jv‡K Block/Select Ki‡Z n‡e|
_ Format
Click
_ Cells
Click Ki‡j Format
Cells Dialog Box Avm‡e ZLb GB Dialog Box Gi g‡a¨ Avjv`v
Avjv`v fv‡e QqwU U¨ve cÖ`wk©Z n‡e| GB
QqwU U¨v‡ei mvnv‡h¨ Qq cÖKv‡ii Cell Setting
Kiv hvq| Avmyb Avgiv Gevi
†`wL GB QqwU U¨v‡ei †KbwUi mvnv‡h¨ wK
KvR Kiv hvq|
(A) To Use Number Tab (bv¤^vi U¨v‡ei e¨envi) t Gi mvnv‡h¨ Avgiv bv¤^vi †mwUs Ki‡Z cvwi|
bv¤^v‡ii †¶‡Î
`kwg‡Ki ci KZ¸‡jv ïb¨ (0) n‡e, msL¨v‡Z Currency wPý †`Iqv, msL¨v‡Z Purcentage wPý †`Iqv,
msL¨v‡K Neumaric ‡_‡K Text G cwieZ©b Kiv, msL¨v‡K Customize Kiv BZ¨vw` KvR Ki‡Z cvwi|
msL¨v‡K
c~e©ve¯’vq wdwi‡q Avbvi Rb¨ Block/Select _vKve¯’vq GB Tab (U¨ve) Gi Aaxb¯’ General Click K‡i Ok
Click Ki‡Z n‡e|
(B) To Use Alignment Tab (G¨vjvBb‡g›U U¨v‡ei e¨envi) t †h †Kvb Text
Or Number ‡K Block/Select
K‡i GB U¨v‡ei mvnv‡h¨ wewfboe G¨v‡½‡j
mvRv‡bv hvq| Text Or Number ‡K c~e©ve¯’vq wdwi‡q †bIqvi Rb¨
Block/Select _vKve¯’vq GB Tab (U¨ve) Gi Aaxb¯’ 0 (ïb¨) Degrees Select K‡i Ok Click Ki‡Z n‡e|
(C) To Use Font Tab (d›U U¨v‡ei e¨envi) t Format
Menu Gi Aš—M©Z Font
Gi mvnv‡h¨ †jLv‡K wewfboe iKg
wWRvBb Kivi KvR Avgiv Microsoft Word G wk‡LwQ | GLv‡bI
wVK GKB c×wZ‡Z Block/Select _vKve¯’vq
Font Tab Select Kivi ci †jLv‡K wewfboe iKg wWRvBb K‡i g‡bi B‡”QgZ Format ‰Zix Kiv hvq| c~e©ve¯’vq
wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab (U¨ve) Gi Aaxb¯’ Normal Font Gi evg w`‡K wVK
wPý w`‡q Ok Click Ki‡Z n‡e|
(D) To Use Border Tab (eW©vi U¨v‡ei e¨envi) t Format
Menu Gi Aš—M©Z Border
& Shading Gi
mvnv‡h¨ †jLv‡K wewfboe iKg Border †`Iqvi KvR Avgiv Microsoft Word G wk‡LwQ | GLv‡bI
wVK GKB
c×wZ‡Z Block/Select
_vKve¯’vq Border
Tab Select Kivi ci †jLv‡K wewfboe iKg wWRvBb K‡i
g‡bi
B‡”QgZ Border
†`Iqvi KvR Kiv hvq| c~e©ve¯’vq wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab
(U¨ve) Gi Aaxb¯’ None Click K‡i Ok Click Ki‡Z n‡e|
(E) To Use Pattern Tab (c¨vUvb© U¨v‡ei e¨envi) t Format
Menu Gi Aš—M©Z Border
& Shading Gi
Shading Tab Gi mvnv‡h¨ †jLvi Background Gi g‡a¨ wewfboe iKg Color (is) Kivi KvR Avgiv
Microsoft Word G wk‡LwQ | GLv‡bI wVK GKB c×wZ‡Z Block/Select
_vKve¯’vq Pattern
Tab Select
Kivi ci †jLvi Background Gi g‡a¨ wewfboe iKg Color (is) K‡i g‡bi B‡”QgZ Format ‰Zix Kiv hvq|
c~e©ve¯’vq wd‡i Avmvi Rb¨ Block/Select _vKve¯’vq GB GB Tab (U¨ve) Gi Aaxb¯’ No Color Click K‡i
Ok Click Ki‡Z n‡e|
(F) To Use Protection Tab (‡cÖv‡UKkb U¨v‡ei e¨envi) t cÖ‡qvRb †bB|
2.
Row (†iv msSvš— wewfboe KvR)
t
(K) To
Change Row Height (†iv Gi D”PZv cwieZ©b
Kiv) t
_ ‡h
Row ¸‡jvi
D”PZv cwieZ©b Ki‡Z PvB †m¸‡jv Block/Select
K‡i
_ Format
Click, Row Select K‡i
_ Height
Click K‡i cÖ‡qvRbgZ D”PZv wj‡L w`‡q
_ Ok
Click Ki‡j Block/Select
K…Z Row
¸‡jvi D”PZv cwieZ©b n‡e|
NB t g‡b ivL‡Z n‡e †h, cÖwZwU Row
Gi ¯^vfvweK D”PZv 12.75|
Microsoft Excel XP
Created By: Kamrul Hassan
Bappy Bappy Computer Education Centre
(L). To
Normal Row Height (†iv Gi D”PZv ¯^vfvweK
Kiv) t
_ ‡h
Row (†iv)
¸‡jvi D”PZv ¯^vfvweK Ki‡Z PvB †mB Row
(†iv) ¸‡jvi D”PZv A¯^vfvweK _vKve¯’vq
Block/Select K‡i
_ Format
Click
_ Row
Select K‡i
_ Auto
Fit Click Ki‡jB Block/Select
K…Z Row
¸‡jvi D”PZv ¯^vfvweK n‡e| A_ev c~bivq Height Box
Open K‡i 12.75 wj‡L Ok Click Ki‡j Block/Select K…Z Row ¸‡jvi D”PZv ¯^vfvweK n‡e|
(M). To
Hide Row (†iv jywK‡q ivLv) t
_ ‡h
Row (†iv)
¸‡jv jywK‡q ivL‡Z PvB †m¸‡jv Block/Select
K‡i
_ Format
Click
_ Row
Select K‡i
_ Hide
Click Ki‡j Block/Select
K…Z Row
¸‡jv jywK‡q hv‡e|
(N). To
Unhide Row (jywK‡q ivLv †iv wdwi‡q Avbv) t
_ ‡h
Row (†iv)
¸‡jv wdwi‡q Avb‡Z PvB †m¸‡jvi c~e©eZ©x I cieZ©x Row
(†iv) `ywU Block/Select
K‡i
_ Format
Click
_ Row
Select K‡i
_ Unhide
Click Ki‡j Aš—eZ©x jywK‡q ivLv Row (†iv) ¸‡jv wd‡i Avm‡e Ges
`„k¨gvb n‡e|
3.
Column (Kjvg msSvš— wewfboe KvR)
t
(K) To
Change Column Hidth (Kjvg Gi cÖ¯’ cwieZ©b
Kiv) t
_ ‡h
Column (Kjvg)
¸‡jvi cÖ¯’ cwieZ©b Ki‡Z PvB †m¸‡jv Block/Select
K‡i
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ Height
Click K‡i cÖ‡qvRbgZ cÖ¯’ wj‡L w`‡q
_ Ok
Click Ki‡j Block/Select
K…Z Column
(Kjvg) ¸‡jvi cÖ¯’ cwieZ©b n‡e|
NB t g‡b ivL‡Z n‡e †h cÖwZwU Column
(Kjvg) Gi ¯^vfvweK cÖ¯’ 8.43|
(L). To
Normal Column Hidth (Kjvg Gi cÖ¯’ ¯^vfvweK
Kiv) t
_ ‡h
Column (Kjvg)
¸‡jvi cÖ¯’ ¯^vfvweK Ki‡Z PvB †mB Column
(Kjvg) ¸‡jvi cÖ¯’ A¯^vfvweK _vKve¯’vq
Block/Select K‡i
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ Height
Click K‡i 8.43 wj‡L Ok
Click Ki‡j Block/Select
K…Z Column
(Kjvg) ¸‡jvi cÖ¯’ ¯^vfvweK n‡e|
Aciw`‡K Column (Kjvg) ¸‡jvi cÖ¯’
A¯^vfvweK _vKve¯’vq Block/Select K‡i
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ AutoFit
Selection Click Ki‡j Column (Kjvg) ¸‡jvi g‡a¨ ‡jLvi
Dci wfwË K‡i Column (Kjvg) Gi cÖ¯’
wba©vwiZ n‡e|
(M). To
Hide Column (Kjvg jywK‡q ivLv) t
_ ‡h
Column (Kjvg)
¸‡jv jywK‡q ivL‡Z PvB †m¸‡jv Block/Select
K‡i
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ Hide
Click Ki‡j Block/Select
K…Z Column
(Kjvg) ¸‡jv jywK‡q hv‡e|
(N). To
Unhide Column (jywK‡q ivLv Kjvg wdwi‡q Avbv) t
_ ‡h
Column (Kjvg)
¸‡jv wdwi‡q Avb‡Z PvB †m¸‡jvi c~e©eZ©x I cieZ©x Column
(Kjvg) `ywU Block/Select
K‡i
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ Unhide
Click Ki‡j Aš—eZ©x jywK‡q ivLv Column (Kjvg) ¸‡jv wd‡i Avm‡e
Ges `„k¨gvb n‡e|
(O). To
See Column Standard width (Kjv‡gi ¯^vfvweK
cÖ¯’ †`Lv) t
_ KvR
Ki‡Z A‡bK mgq Avgv‡`i Column (Kjvg) Gi ¯^vfvweK cÖ¯’ KZ Zv g‡b bvI _vK‡Z cv‡i| GB Ae¯’vq
Column (Kjvg) Gi ¯^vfvweK cÖ¯’ †`Lvi Rb¨
_ Format
Click
_ Column
(Kjvg) Select
K‡i
_ Standard
width Click Ki‡jB Standard
width Dialog Box Avm‡e Ges GB Ae¯’vq Avgiv
Column
(Kjvg) Gi ¯^vfvweK cÖ¯’ †`L‡Z cvwi|
4.
Sheet (IqvK©kxU msSvš— wewfboe
KvR) t
_ ‡h
Worksheet Gi
bvg cwieZ©b Ki‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L
_ Format
Click
_ Sheet
Select K‡i
_ Rename
Click K‡i cwieZ©xZ bvgwU wj‡L Worksheet Gi †h †Kvb RvqMvq Click Ki‡jB Worksheet Gi bvg
cwieZ©xZ n‡e|
(L). To
Hide Worksheet (IqvK©kxU‡K jywK‡q ivLv)
t
_ ‡h
Worksheet wU
jywK‡q ivL‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L
_ Format
Click
_ Sheet
Select K‡i
_ Hide
Click Ki‡j Worksheet
wU jywK‡q hv‡e| g‡b ivL‡Z n‡e †h, me©‡kl Worksheet wU jywK‡q ivLv hv‡e bv|
(M). To
Unhide Worksheet (jywK‡q ivLv IqvK©kxU‡K
wdwi‡q Avbv) t
_ Worksheet
jyKv‡bv Av‡Q GiKg GKwU Book/File G _vKve¯’vq
_ Format
Click
_ Sheet
Select K‡i
_ Unhide
Click Ki‡jB Unhide
Dialog Box Avm‡e ZLb ‡h bv‡gi Worksheet wU wdwi‡q Avb‡Z PvB †mB
bv‡gi Dci Click (wK¬K) K‡i
_ Ok
Click Ki‡jB jywK‡q ivLv IqvK©kxUwU wd‡i Avm‡e|
(N). To
Create Worksheet Background (IqvK©kx‡Ui
e¨vKMÖvDÛ †`Iqv) t
_ ‡h
Worksheet wUi
e¨vKMÖvDÛ w`‡Z PvB †mB Worksheet Gi g‡a¨ Cell Pointer ‡i‡L
_ Format
Click
_ Sheet
Select K‡i
_ Background
Click Ki‡j Sheet
Background Dialog Box Avm‡e ZLb From File ‡_‡K †h †Kvb GKwU
Qwe cQ›`gZ Select K‡i
_ Insert
Click Ki‡j m¤ú~b© Worksheet
Gi Background
Gi g‡a¨ Select
K…Z QwewU P‡j hv‡e| Z‡e H QwewU
ïaygvÎ Normal
Mode G cÖ`wk©Z n‡e| A_©vr H QwewU Print Preview Mode G
cÖ`wk©Z n‡e bv| cieZ©x‡Z
_ Format
Click
_ Sheet
Select K‡i
_ Delete
Background Click Ki‡j Worksheet wU c~e©ve¯’vq P‡j hv‡e|
A_©vr Background Gi
QwewU gy‡Q
hv‡e|
Microsoft Excel XP
Created By: Kamrul Hassan
Bappy Bappy Computer Education Centre
5.
AutoFormat (†Uwej‡K wewfboe iKg
wWRvBb Kiv) t
(K). To
Create AutoFormat (wWRvBb ˆZix Kiv) t
_ ‡h
KqwU Cell ‡K wb‡q AutoFormat (wWRvBb) Ki‡Z PvB
†mB Cell ¸‡jv‡K Block/Select K‡i
_ Format
Click
_ AutoFormat
Click Ki‡j AutoFormat
Dialog Box Avm‡e ZLb Table Format List ‡_‡K
cQ›`gZ
Style Select K‡i
_ Ok
Click Ki‡j Block/Select
K…Z Cell
¸‡jv cQ›`gZ AutoFormat
n‡q hv‡e|
(L). To
Delete AutoFormat (wWRvBb ev` †`Iqv) t
_ c~‡e©
AutoFormat Kiv
_vK‡Z n‡e| Zvici
_ ‡h
KqwU Cell Gi AutoFormat (wWRvBb) ev` w`‡Z
PvB †mB Cell ¸‡jv‡K Block/Select K‡i
_ Format
Click
_ AutoFormat
Click Ki‡j AutoFormat
Dialog Box Avm‡e ZLb Table Format List ‡_‡K None
Select K‡i
_ Ok
Click Ki‡j Block/Select
K…Z Cell
¸‡jv †_‡K AutoFormat
ev` n‡q hv‡e|
6.
Style (wbR¯^ di‡gwUs wWRvBb
ˆZix Kiv) t
(K). To
Create Style (óvBj ˆZix Kiv) t
_ Format
Click
_ Style
Click Ki‡j Style
Dialog Box Avm‡e ZLb †h †Kvb GKwU bvg wj‡L
_ Modify
Click Ki‡j Cells
Dialog Box Avm‡e ZLb GB Box Gi mnvqZvq †h mKj KvR
c~‡e© wk‡LwQ meB
Kiv hv‡e| g‡bi B‡”QgZ me¸‡jv Style Setting K‡i `yBevi Ok Click Ki‡jB óvBj ˆZix n‡q hv‡e|
cÖ‡qvRb n‡j
ˆZixK…Z Style (wWRvBb) wU c~bivq Modify (ms‡kvab) Ki‡Z cvwi|
(L). To
Apply The Style (wWRvB‡bi e¨envi Kiv) t
_ ‡h
Cell ¸‡jvi
g‡a¨ Style (wWRvBb)
Gi e¨envi Ki‡Z PvB †mB Cell ¸‡jv‡K Block/Select K‡i Zvici
_ Format
Click
_ Style
Click Ki‡j Style
Dialog Box Avm‡e ZLb †h bv‡gi Style (wWRvBb) Gi e¨envi Ki‡Z
PvB †mB bvgwU
Select K‡i Zvici
_ Ok
Click Ki‡Z n‡e| d‡j ˆZixK…Z Style (wWRvBb) Gi e¨envi n‡e|
(M). To
Delete Style (wWRvBb †gvQv) t
_ c~‡e©
Style (wWRvBb)
ˆZix Kiv _vK‡Z n‡e Zvici
_ Format
Click
_ Style
Click Ki‡j Style
Dialog Box Avm‡e ZLb Style Name List ‡_‡K †h bv‡gi Style (wWRvBb) wU
†gvQ‡Z PvB †mB bvgwU Select K‡i Zvici
_ Delete
Click
_ Ok
Click Ki‡jB ˆZixK…Z Style
(wWRvBb) wU †gv‡Q hv‡e|
No comments:
Post a Comment