মাইক্রোসফট অফিস এক্সেল এ টুল্‌স মেন্যু এর কাজ

6 Tools menu Gi KvR

6.1 Spelling and grammar - evbvb  ï× Kiv

wbw`©ó †m‡j Kvm©i †i‡L A_ev cÖ‡qvRbxq †mj e­K K‡i Tools menu †_‡K Spelling and grammar KgvÛ w`‡q WvqvjM e‡·i wbqgvbyhvqx wb‡b¥i KgvÛ w`b

6.1a Ignore D‡c¶v Kiv

6.1b Ignore All me kã D‡c¶v Kiv

6.1c Add wWKkbvix‡Z kã ms‡hvRb Kiv

6.1d Change cwieZ©b Kiv

6.1e Change All me kã cwieZ©b Kiv

6.2  Auto correct ‡jLvi mv‡_ mv‡_ ï× Kiv

wbw`©ó ¯’v‡b Kvm©i †i‡L Tools menu †_‡K Auto correct KgvÛ w`‡q WvqvjM e‡·i Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

Read More

Format Menu

5. Format manu -Gi KvR

5.1 Cells

Number bv¤^vi †U·‡K wewfbœ di‡gU Kiv

cÖ_‡g cÖ‡qvRbxq †mj e­K K‡i Format menu ‡_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Number Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.1a Alignment -‡m‡ji †U·‡Ui gvwR©b wba©vib Kiv

wba©vwiZ †mj e­K K‡i format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Alignment Gwiqvi wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.1b Font -†U·U wWRvBb

cÖ_‡g cÖ‡qvRbxq †U·U e­K K‡i Format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Font Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.1c Border -‡m‡ji PZzw`©‡K `vM †`Iqv

cÖ_‡g cÖ‡qvRbxq ‡mj e­K K‡i Format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Border Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.1d Patterns -‡m‡ji wcQ‡b Shade †`Iqv

cÖ_‡g cÖ‡qvRbxq ‡mj e­K K‡i Format menu †_‡K Cells KgvÛ w`‡q WvqvjM e‡·i Patterns Gwiqv †_‡K wbw`©ó Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

5.2 Row

5.2a Height- †ivÕi D”PZv wba©vib Kiv

cÖ_‡g cÖ‡qvRbxq ‡mj e­K K‡i Format menu †_‡K Row-height KgvÛ w`‡q WvqvjM e‡·i Row-height N‡i wbw`©ó cwigvb UvBc K‡i Ok evU‡b Pvcyb|

5.2b Auto Fit ¯^qswµqfv‡e †ivÕi D”PZv wba©vib Kiv

wbw`©ó ‡iv e­K K‡i Format menu †_‡K Row- Auto Fit KgvÛ w`b|

5.2c Hide ‡iv †jvKv‡bv

wbw`©ó ‡iv e­K K‡i Format menu †_‡K Row- Hide KgvÛ w`b|

5.2d Unhide ‡jvKv‡bv †iv cÖ`k©b

‡jvKv‡bv ‡iv mn cÖ‡qv‡rRbxq †iv e­K K‡i Format Row Unhide KgvÛ w`b|

5.3 Column

5.3a Weiht Kjv‡gi cÖm¯’Zv wba©vib Kiv

cÖ‡qvRbxq Kjvg e­K K‡i Format menu †_‡K Column- Width KgvÛ w`‡q WvqvjM e‡·i Column- Width N‡i wbw`©ó cwigvb UvBc K‡i Ok evU‡b Pvcyb|

5.3b Auto Fit Selection mqswµqfv‡e Kjv‡gi cÖm¯—Zv wba©vib Kiv

cÖ‡qvRbxq Kjvg e­K K‡i Format menu †_‡K Column- Auto Fit Selection KgvÛ w`b|

5.3c Hide Kjvg †jvKv‡bv

cÖ‡qvRbxq Kjvg e­K K‡i Format menu †_‡K Column Hide KgvÛ w`b|

Unhide ‡jvKv‡bv Kjvg cÖ`k©b

‡jvKv‡bv Kjvg mn cÖ‡qv‡rRbxq Kjvg e­K K‡i Format Column Unhide KgvÛ w`b|

5.4. Sheet

5.4a Rename-mx‡Ui bZzb bvgKib Kiv

cÖ‡qvRbxq mxU Active K‡i Format menu †_‡K Sheet Rename KgvÛ w`‡q bZzb bvg UvBc K‡i Ab¨ †h †Kvb †m‡j gvDm Pvcyb|

5.4b Hide mxU †jvKv‡bv

cÖ‡qvRbxq mxU Active K‡i Format menu †_‡K Sheet Hide KgvÛ w`b|

5.4c Unhide ‡jvKv‡bv mxU cÖ`k©b

Format Sheet Unhide KgvÛ w`‡q WvqvjM e· †_‡K wbw`©ó bv‡g dvBj wm‡j± K‡i Ok evU‡b Pvcyb|

5.4d Auto Format ¯^qswµq fv‡e †mj di‡gU Kiv

cÖ‡qvRbxq †mj e­K K‡i Format menu †_‡K Auto Format KgvÛ w`‡q WvqvjM e‡·i wbw`©ó wWRvBb wm‡j± K‡i Ok evU‡b Pvcyb|

5.5 Conditional Formatting kZ© †gvZv‡eK cÖ‡qvRbxq †mj di‡gU

cÖ‡qvRbxq †mj e­K K‡i Format menu †_‡K Conditional Formatting KgvÛ w`‡q WvqvjM e‡·i cÖ‡qvRbxq Ackb (kZ© †gvZv‡eK) wm‡j± K‡i Ok evU‡b Pvcyb|

5.6 Style m¤ú~b© mxU  di‡gU Kib

cÖ‡qvRbxq mxU Active K‡i Format Style KgvÛ w`‡q WvqvjM e‡·i cÖ‡qvRbxq Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

Read More

Insert Menu

4 Insert menu -Gi KvR

Cells bZzb ms‡hK Kiv

wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †mj e­K K‡i  Insert manu †_‡K Cells KgvÛ w`‡j Insert WvqvjM e· Avm‡e| WvqvjM e‡·i cÖ‡qvRbxq Ackb wb‡j± K‡i  Ok evU‡b Pvcyb|

4.1 Rows -evov‡bv

wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †iv e­K K‡i  Insert manu †_‡K Rows KgvÛ w`b|

4.2 Columns- evov‡bv

wbw`©ó ¯’v‡b Kvm©i †i‡L ev cÖ‡qvRbxq †iv e­K K‡i  Insert manu †_‡K Columns KgvÛ w`b|

4.3 Worksheet -IqvK© mxU evov‡bv

Insert manu †_‡K Worksheet KgvÛ w`b|

4.4 Chart- ev MÖvd ˆZix Kiv

wbw`©ó ‡mj e­K K‡i  Insert manu †_‡K Chart KgvÛ w`‡j Chart Wizard WvqvjM e· Avm‡e| WvqvjM e‡·i cÖ‡qvRbxq  Next  evU‡b †P‡c cÖwZwU WvqvjM e‡·i cÖ‡qvRbxq  Ackb wb‡j± K‡i ke© †k‡l 

Finish evU‡b Pvcyb|

4.5 Page Break -c„ôv wba©vib Kiv

wbw`©ó ¯’v‡b Kvm©i †i‡L  Insert manu †_‡K Page Break KgvÛ w`b Ges c~e©ve¯’vq wd‡i Avmvi Rb¨ Insert manu †_‡K Remove Page Break KgvÛ w`b|

4.6 Function- wewfbœ m~‡Îi e¨envi

wbw`©ó ¯’v‡b Kvm©i †i‡L  Insert Function KgvÛ w`‡q WvqvjM e‡·i  Wvb w`‡Ki wbw`©leU  Ackb wm‡j± K‡i gvD‡mi evg †evZvg †P‡c a‡i cÖ‡qvRbxq †iÄ †`wL‡q Ok  evU‡b Pvcyb|

4.7 Comment †m‡ji gš—e¨ wjLv

wbw`©ó †m‡j Kvm©i †i‡L Insert-Comment KgvÛ w`‡q cÖ‡qvRbxq gš—e¨ UvBc K‡i Ab¨ †W †Kvb †m‡j gvDm Pvcyb|

4.8 Picture - Qwe ms‡hvRb

Insert Picture Clipart KgvÛ w`‡q clipart WvqvjM e· †_‡K wbw`©ó Qwe wm‡j± K‡i Ok  evU‡b Pvc‡Z n‡e|

4.9 WordArt -wWRvBb K‡i wjLv

Insert Picture-Word Art KgvÛ w`‡q wbw`©ó wWRvBb wm‡jKvU K‡i Ok  evU‡b †P‡c Your text here †jLv gy‡Q cÖ‡qvRbxq wjLv wj‡L Ok evU‡b Pvc‡Z n‡e|

4.10 Map -gvbwPÎ ms‡hvRb Kiv

Insert Map  KgvÛ w`‡q gvD‡mi evg †evZvg †P‡c a‡i cÖ‡qvRbxq e· ˆZix Ki“b Ges WvqvjM e· †_‡K wbw`©ó †`‡ki bvg/Ackb wm‡j± K‡i Ok evU‡b Pvcyb Ges †k‡l Ab¨ †h †Kvb dvKv †m‡j gvDm Pvcyb|

4.11 Equation exRMwY‡Zi m~Î †jLv

wbw`©ó ¯’v‡b Kvm©i †i‡L Insert menu †_‡K Object KgvÛ w`‡q WvqvjM e‡·i Microsoft Equation  3.0 Ackb wm‡j± K‡i  Ok evU‡b †P‡c  Template Toolbar  †_‡K cÖ‡qvRbxq m~Î ‰Zix Ki“b|

Read More

View-Menu

3 View- †gbyi KvR

Normal- mvavib c„ôv †`Lv‡e|

View †gbyi Number KgvÛ w`b|

3.1 Page Break Preview-c„ôv AvKv‡i †`Lv

View ‡gby †_‡K Page Break Preview-KgvÛ w`‡j c„ôvi bgybv †`Lv‡e|

3.2 Toolbar -Avbv †bIqv

View ‡gby †_‡K Toolbar G Kvm©i wb‡q wbw`©ó Uzjev‡i gvDm w`‡q KgvÛ w`‡j UzjeviwU Pwj hv‡e (hw` D³ UzjeviwU gwbU‡i Active _v‡K) Ges View-Toolbar G gvDm wb‡q D³ Uzjev‡i Pvc w`‡j Zv wd‡i Avm‡e|

3.3 Formula Bar -Avbv †bIqv

View ‡gby †_‡K Formula Bar KgvÛ w`‡j Formula Bar  P†j hv‡e | Ges View- Formula Bar KgvÛ w`‡j  wd‡i Avm‡e|

3.4 Status Bar -Avbv †bIqv

View ‡gby †_‡K Status Bar KgvÛ w`‡j Status Bar  P†j hv‡e | Ges View- Formula Bar KgvÛ w`‡j  wd‡i Avm‡e|

3.5 Header and Footer †jLv

View †gby †_‡K Header and Footer KgvÛ w`‡q Header e‡· cÖ‡qvRbxq  Header wjLyb Ges Footer wjLvi Rb¨ Page setup WvqvjM e‡·i Header and Footer evUb †P‡c cÖ‡qvRbxq  Header and Footer wj‡L Ok evU‡b Pvcyb|

H/F gyQvi Rb¨ View Header and Footer KgvÛ w`‡q wbw`©ó H/F gy‡Q  Close evU‡b Pvcyb|

3.6 Full Screen- †jLv m¤ú~b© c„ôve¨vcx †`Lv

View †gby †_‡K Full Screen KgvÛ w`b Ges Full Screen eÜ Kivi Rb¨ Close Full Screen A_ev Keyboart †_‡K ESC  evU‡b Pvcyb|

3.7 Zoom-‡jLv †QvU eo K‡i †`Lv

View †gby †_‡K Zoom KgvÛ w`‡q Zoom e‡·i cÖ‡qvRbxq Ackb wm‡j± K‡i  Ok  evU‡b Pvcyb|

Read More

Edit Menu

2 Edit menu  Gi KvR

Undo Kgv‡Ûi Kvh©KvixZv evwZj Kiv

cÖ_‡g †Kvb KgvÛ w`‡Z n‡e| Gevi Edit menu  †_‡K Undo KgvÛ  w`‡Z n‡e|

Redo evwZjK…Z KgvÛ cybt¯’vcb Kiv|

cÖ_‡g Undo KgvÛ w`‡Z n‡e| Edit menu  †_‡K Redo KgvÛ w`b|

2.1 Cut – Text †jLv gyQv/¯’vbvš—i Kiv

cÖ_‡g cÖ‡qvRbxq Text  ¸‡jv e­K K‡i wbb| Gevi   Edit menu †_‡K  Cut KgvÛ w`‡j †jLv gy‡Q hv‡e wKš‘ †jLv ¸‡jv Avcbvi wK¬c †ev‡W© Rgv _vK‡e hv Avcwb †`L‡Z cv‡eb bv| GLb †hLv‡b †jLv  ¸‡jv ¯’vbvš—i Kiv `iKvi †mLv‡b Kvm©i †i‡L  Edit menu ‡_‡K Paste KgvÛ w`b|

Keyboard short cut command è Block text àCtrl+x àCtrl+v

2.2 Copy- Abyiƒc †U·U ˆZix Kiv

cÖ_‡g †jLv¸‡jv e­K K‡i Edit menu †_‡K Copy  KgvÛ w`b Ges cÖ‡qvRbxq ¯’v‡b Kvm©i †i‡L  menu ‡_‡K Paste KgvÛ w`b|

Keyboard short cut command è Block text àCtrl+c àCtrl+v

2.3 Fill -GKB †jLv Øviv †mj c~Y© Kiv

wbw`©ó †jLv hy³  †mjmn cÖ‡qvRbxq †mj e­K K‡i Edit menu †_‡K Fill-Down/ Up/ Left/Right KgvÛ w`b (Aek¨ e­‡Ki wb‡`©k gZ)

2.4 Clear -†U·U gyQv

cÖ‡qvRbxq Text  ¸‡jv e­K K‡i wbb| Gevi   Edit menu †_‡K  Clear KgvÛ w`‡j| m¤ú~b© †jLv gyQvi Rb¨ Editàclear all

2.5 Delete ‡mj gyQv

cÖ‡qvRbxq †mj e­K K‡i wb‡q Edit menu †_‡K Delete KgvÛ w`‡q WvqvjM e‡·i cÖ‡qvRbxq Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

2.6 Delete Sheet -mxU gyQv

cÖ‡qvRbxq mxU Pvjy K‡i wb‡q Edit menu †_‡K Delete Sheet KgvÛ w`‡q g¨v‡mR e‡·i Ok evU‡b Pvcyb| (Z‡e g‡b ivL‡Z n‡e mxU ¯’vqxfv‡e gy‡Q hvq, ZvB mxU GKevi gy‡Q †dj‡j Zv Avi wd‡i Avbv hvq bv|)

2.7 Move or Copy Sheet -mxU Kwc Kiv

cÖ‡qvRbxq Sheet Active K‡i wb‡q  Edit menu †_‡K Move or Copy Sheet KgvÛ w`‡q WvqvjM e‡·i cÖ‡qvRbxq Ackb (Create a Copy) wba©vib K‡i  Ok evU‡b Pvcyb|

2.8 Find -kã LuyRv

Kvm©i †jLvi cÖ_‡g ‡i‡L Edit menu †_‡K Find  KgvÛ w`‡q WvqvjM e‡·i Find what N‡i cÖ‡qvRbxq kã wj‡L Find next evU‡b Pvcyb|

2.9 Replace - kã cÖwZ¯’vcb Kiv

Kvm©i †jLvi cÖ_‡g ‡i‡L Edit menu †_‡K Replace KgvÛ w`‡q Find and Replace WvqvjM e‡·i Find what N‡i c~ivZb kã (A_©vr †h k‡ãi Dci †jLv n‡e) Ges Replace what N‡i bZzb kã (A_©vr †h kã Øviv cÖwZ¯’vwcZ n‡e) wj‡L  Replace all evU‡b Pvcyb|

2.10 Go to wbw`©ó Page/Line G hvIqv

Edit menu †_‡K Go to KgvÛ w`‡q Reference e‡·i Gwiqv †_‡K cÖ‡qvRbxq Cell name UvBc K‡i Ok evU‡b Pvcyb|

Read More

File Menu

1. File Menu  Gi KvR

New-bZzb dvBj ˆZix Kivt

File menu †_‡K  New KgvÛ w`‡j New WvqjM e· Avm‡e | WvqjM e‡·i General ‡_‡K Blank workbook  wm‡j± K‡i Ok evU‡b Pvc w`b| or File à New à blank Document

Keyboard short cut command è Ctrl+N

1.1 Open -dvBj †Lvjv

File menu †_‡K Open KgvÛ w`‡j  File WvqvjM e· Avm‡e| WvqvjM e‡·i List Area ‡_‡K wbw`©ó dvBj wm‡j± K‡i Open evU‡b Pvc w`b|

Keyboard short cut command è Ctrl+O àSelect Your file à Open

1.2 Close -dvBj eÜ Kiv

File menu ‡_‡K Close evU‡b Pvc w`b| A_ev Title bar Gi wb‡Pi [X] (Close) AvBK‡b Pvc w`b|

1.3 Save - dvBj msi¶b Kiv

File menu ‡_‡K Save KgvÛ w`b|

N: B: WKz‡g‡›Ui bZzb †Kvb ‡jLv msi¶b Kivi Rb¨ KgvÛ w`‡j Save As WvqvjM e· Avm‡e| WvqvjM e‡·i File menu e‡· wbw`©ó bvg wj‡L Save KgvÛ w`b| wKš‘ cyivZb dvB‡j Save KgvÛ w`‡j bZyb bvg PvB‡e bv | Zv H bv‡gB Save n‡e|

Keyboard short cut command è Ctrl+Sàtype file name àenter

1.4 Save As Abyiƒc dvBj ˆZwi Kiv

File menu ‡_‡K Save As KgvÛ w`‡j Save As WvqvjM e· Avm‡e| WvqvjM e‡·i File menu e‡· bZyb bvg wj‡L Save evU‡b Pvc w`‡Z n‡e|

1.5 Save As - dvB‡ji †MvcbxqZv i¶v Kiv

File Save As KgvÛ w`‡j Save As WvqvjM e· Avm‡e| WvqvjM K‡·i options or tools àsecurity options evU‡bPvc w`‡j Save WvqvjM e· †`Lv hv‡e| Save WvqvjM e‡·i Password to open e‡·i cÖ‡qvRbxq Password wj‡L Ok evU‡b Pvc w`‡j Confirm Password WvqvjM e· Avm‡e| WvqvjM e‡·i Return Password to open e‡· cybivq Password wj‡L Ok evU‡b Pvc‡Z n‡e| me©‡kl Save evU‡b Pvc‡j Massage box Avm‡e| Massage box Gi Yes evU‡b Pvcyb|

Keyboard short cut command è Ctrl+Sàtools àsecurity optionsàtype passwordàenteràretype passwordàenteràenter

1.6 Password gyQv

File Save As KgvÛ w`‡j Save As WvqvjM e· Avm‡e| WvqvjM K‡·i options or tools àsecurity options evU‡bPvc w`‡j Save WvqvjM e· †`Lv hv‡e| Save WvqvjM e‡·i Password to open e‡·i Password wU gy‡Q Ok evU‡b Pvc w`b| me©‡k‡l save a click.

Keyboard short cut command è Ctrl+Sàtools àsecurity optionsàremove passwordàenter àenter

1.7 Page setup -c„ôv wba©vib Kiv

File menu ‡_‡K Page setup KgvÛ w`‡j Page setup WvqvjM e· Avm‡e| c„ôvi gvwR©b wba©vib Kivi Rb¨ Page setup   WvqjM e‡·i Margins evUb †P‡c (Top/Bottom/Left/Right) cÖ‡qRbxq Ackb wba©vib K‡i Ges c„ôvi AvKvi wba©vib eivi Rb¨ Page setup WvqvjM e‡·i Page size evUb †P‡c Page size e· †_‡K wbw`©ó gv‡ci c„óv wm‡j± K‡i A_ev Weight (PIiv) Ges Height (j¤^v) Arrow key †P‡c Kwg‡q/evwo‡q Ges Orientation area †_‡K Portrait (j¤^vjw¤^) A_ev Landscape (AvovAvwo) †h †Kvb GKwU Ackb Header and Footer evU‡b †P‡c wbw`©ó Header and Footer ˆZix Ki“b Ges Page Setup WvqvjM e‡·i Sheet hftcb cycr  cÖ‡qvRb gZ Ackb  wm‡j± K‡i Ok evU‡b Pvcyb|

1.8 Print preview - Qvcvi cÖwZ”Qwe

File menu ‡_‡K Print preview KgvÛ w`b Ges Print preview evwni nevi Rb¨ Uzjev‡ii Closw AvBK‡b Pvcyb|

1.9 File Print-‡jLv Qvcv‡bv

FileàPrint KgvÛ w`‡q Print WvqjM e· †_‡K Print name e‡·i wbw`©ó bv‡gi Printer wm‡j± K‡i Ges Print range area †_‡K cÖ‡qvRbxq Ackb wm‡j± K‡i Ges Copies area †_‡K cÖ‡qvRbxq Ackb wm‡j± K‡i Ok evU‡b Pvcyb|

Z‡e Aek¨B wcÖ›U Ok Kivi c~‡e© wcÖ›Uvi Pvjy Ges wcÖ›Uv‡i KvMR w`‡Z n‡e|

Keyboard short cut command è Ctrl+pàEnter

Read More