Sunday, August 10, 2014

Edit Menu Microsoft Excel XP


** Edit Menu **
_ BLOCK Kiv t ‡h †jLv e−K Ki‡Z Pvb †mj c‡q›Uvi †m †jLvi ïi“‡Z wb‡q gvD‡mi evg ‡evZvg †P‡c a‡i Drag
Ki‡j ‡jLv e−K n‡e| A_ev Shift Kx †P‡c a‡i ‡i‡L †h ‡Kvb Arrow Kx Pvc w`‡j †h Arrow Kx Pvc w`‡eb †mB w`‡Ki
†jLv e−K n‡e| GLv‡b D‡j−L¨ †h, e−K Ki‡j Ab¨ †mj ¸‡jv Kvj †`Lv‡jI cÖg †h Cell wU e−K Kiv nq †mwU mv`v †`Lv hvq|
Z‡e a‡i wb‡Z n‡e H cÖg Cell wU Block Kiv n‡q ‡M‡Q|
_ BLOCK Zz‡j †`Iqv t Worksheet Gi †h ‡Kvb hvqMvq gvDm wK¬K Ki‡j A_ev †h ‡Kvb Arrow
Kx Pvc w`‡j Block (e−K) D‡V hv‡e|

1. Cut & Paste (‡jLv‡K ¯’vbvši— Kiv) t
‡h mg¯’ Cell Gi †jLv‡K ¯’vbvš—i Ki‡Z PvB †mB Cell ¸‡jv Block (e−K) K‡i
_ Edit Click
_ Cut Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq ¯’vbvš—i Ki‡Z PvB †mB
Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit Click
_ Paste Click Ki‡jB Block (e−K) Kiv †jLv¸‡jv ¯’vbvš—i n‡q Cursor ‡h RvqMvq ivLv n‡qwQj †mB RvqMvq
¯’vwcZ n‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K ¯’vbvš—‡ii KvR Ki‡Z cvwi| cÖgZ t Standard Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

2. Copy & Paste (GKB ‡jLv‡K GKvwaKevi ¯’vcb Kiv) t
_ ‡h mg¯’ Cell Gi †jLv‡K GKvwaKevi ¯’vcb Ki‡Z PvB †mB Cell ¸‡jv Block (e−K) K‡i
_ Edit Click
_ Copy Click Ki‡j H †jLv¸‡jvi Pvicv‡k GKiKg Lighting cª`wk©Z n‡e ZLb †h RvqMvq GKvwaKevi ¯’vcb
Ki‡Z PvB †mB Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit Click
_ Paste Click Ki‡jB Block (e−K) Kiv †jLv¸‡jv Cursor ‡h RvqMvq ivLv n‡qwQj †mB RvqMvq GKvwaKevi ¯’vwcZ
n‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z †jLv‡K GKvwaKevi ¯’vc‡bi KvR Ki‡Z cvwi| cÖgZ t Standard Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

3. Paste Special (Ab¨ †Kvb †cÖvMÖvg †_‡K G‡b G‡·‡j †c÷ Kiv) t
_ Spreadsheet Analysis Software Microsoft Excel Gi g‡a¨ KvR Kivi mgq A‡bKmgqB Microsoft
Word Or Microsoft Access ‡_‡K †jLv‡K ‡có Kiv hvq| †h WvqvjM e· Avm‡e Zv‡Z Ok Click Ki‡jB
wbw`ªó Mode G Paste n‡e|

4. Paste As Hyperlink (nvBcviwj¼ Gi g‡a¨ †c÷ Kiv) t
_ GB Option wU Internet (B›Uvi‡bU) Gi Rb¨ cÖ‡qvRb nq| Internet (B›Uvi‡bU) ms‡hvM bv _vK‡j GB Option
wUi KvR Kiv m¤¢e b‡n| mPivPi GB Option wUi cÖ‡qvRb nq bv|
Microsoft Excel XP
Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

5. Clear (†jLv ev Ae‡R± †gvQv) t
_ cÖ‡g †h †jLv ev Ae‡R±‡K †gvQ‡Z PvB †mwU Block/Select Kwi Zvici
_ Edit Click
_ Clear Gi g‡a¨ Mouse Pointer wb‡q
_ All Click Ki‡jB Block/Select Kiv †jLv ev Ae‡R±wU †gv‡Q hv‡e| GB ‡gvQvi KvRwU Avgiv Ab¨ c×wZ‡Z
Ki‡Z n‡j †jLv ev Ae‡R±‡K Block/Select Kivi ci KeyBoard Gi Delete Key Press Ki‡jB †jLv ev
Ae‡R±wU †gv‡Q hv‡e|

6. Undo (KgvÛ evwZj Kiv) t
_ GBgvÎ cÖ‡qvM Kiv †Kvb Command (KgvÛ) evwZj Ki‡Z n‡j Avgiv Undo Gi mvnvh¨ wb‡Z cvwi
_ Edit Click
_ Undo Click Ki‡j Clear/Delete Gi gva¨‡g †gv‡Q †djv †jLvwU wd‡i Avm‡e A_ev GB GKB Command
(KgvÛ) Gi gva¨‡g me©‡kl †`Iqv †h ‡Kvb Command (KgvÛ)B evwZj n‡q hv‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z KgvÛ evwZj Kivi KvR Ki‡Z cvwi| cÖgZ t Standard Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

7. Redo (evwZj Kiv KgvÛ †dir wb‡q Avmv) t
_ Undo Gi gva¨‡g †Kvb Command (KgvÛ) †K evwZj Kivi ci hw` GiKg g‡b nq †h Command (KgvÛ)wU
evwZj Kiv wVK nqwb ZLb
_ Edit Click
_ Redo Click Ki‡jB evwZj Kiv KgvÛwU †dir P‡j Avm‡e|
NB t Avgiv AviI A‡bK c×wZ‡Z evwZj Kiv KgvÛ †dir wb‡q Avm‡Z cvwi| cÖgZ t Standard Tool Bar Gi gva¨‡g
Ges wØZxqZ t Key Board e¨envi K‡i| cÖ‡qvRb g‡b Ki‡j c×wZ¸‡jv wk¶‡Ki wbKU †_‡K †R‡b wbb|

8. Delete …(CELL, ROW & COLUMN miv‡bv I ‡gvQv) t
_ wbw`©ó ‡mj gy‡Q Wv‡b cv‡ki †jLv ev‡g mviv‡bv t
_ ‡h Cell wU †gvQ‡Z PvB †mwU Select K‡i
_ Edit Click
_ Delete Click
_ Shift Cell Left Click
_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU †gv‡Q hv‡e Ges H Row Gi Aš—M©Z
Wvb w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|
_ wbw`©ó ‡mj gy‡Q wb‡Pi †jLv Dc‡i DVv‡bv t
_ ‡h Cell wU †gvQ‡Z PvB †mwU Select K‡i
_ Edit Click
_ Delete Click
_ Shift Cell Up Click
_ Ok Click Ki‡jB Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wU †gv‡Q hv‡e Ges H Column Gi
Aš—M©Z wb‡Pi w`‡Ki Ab¨vb¨ Cell ¸‡jv G‡m †gv‡Q hvIqv Cell wU c~ib Ki‡e|
_ wbw`©ó GKwU †iv †gvQv t
_ ‡h Row wU †gvQ‡Z PvB †mB Row Gi Aš—M©Z †h †Kvb GKwU Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit Click
_ Delete Click
_ Entire Row Click
_ Ok Click Ki‡jB Cursor ‡h Row Gi g‡a¨ wQj †mB Row wU †gv‡Q hv‡e Ges wb‡Pi w`K †_‡K
Row ¸‡jv G‡m †gv‡Q hvIqv Row wU c~ib Ki‡e|



_ wbw`©ó GKwU Kjvg †gvQv t
_ ‡h Column wU †gvQ‡Z PvB †mB Column Gi Aš—M©Z †h †Kvb GKwU Cell Gi g‡a¨ Cursor ‡i‡L
_ Edit Click
_ Delete Click
_ Entire Column Click
_ Ok Click Ki‡jB Cursor ‡h Column Gi g‡a¨ wQj †mB Column wU †gv‡Q hv‡e Ges Wvb w`K
†_‡K Column ¸‡jv G‡m †gv‡Q hvIqv Column wU c~ib Ki‡e|

9. Delete Sheet (IqvK©kxU †gvQv) t
_ Avgiv Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet _v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix
Ki‡Z cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bK wKQy Kiv hvq| Avgiv
GLb †gvQv wkLe Ges kx‡Ui Ab¨vb¨ KvR wkLe cieZ©x‡Z| Worksheet †gvQvi Rb¨ Avgiv †h Worksheet wU †gvQ‡Z PvB
†mwU Select K‡i Zvici
_ Edit Click
_ Delete Sheet Click
_ Ok Click Ki‡jB Select Kiv Worksheet wU †gv‡Q hv‡e| †gvQv Worksheet KLbI †dir Avbv hvq bv|

10. Move Or Copy Sheet (GKB kx‡Ui GKvwaK Kwc ˆZix Kiv) t
_ Avgiv Rvwb †h †Kvb GKwU Book/File Gi g‡a¨ mvavibZ wZbwU Worksheet _v‡K| cieZ©x‡Z Avgiv Bnv bZzb K‡i ˆZix Ki‡Z
cvwi, ‡gvQ‡Z cvwi Ges GKB kx‡Ui GKvwaK Kwc ˆZix Ki‡Z cvwi| GQvovI kx‡Ui AviI A‡bKwKQy Kiv hvq| Avgiv GLb GKB
kx‡Ui GKvwaK Kwc ˆZix Kiv wkLe Ges kx‡Ui Ab¨vb¨ KvR wkLe cieZ©x‡Z| GKB kx‡Ui GKvwaK Kwc ˆZix Kivi Rb¨ Avgiv †h
Worksheet Gi GKvwaK Kwc ˆZix Ki‡Z PvB †mwU Select K‡i Zvici
_ Edit Click
_ Move Or Copy Sheet Click Ki‡j Move Or Copy Dialog Box Avm‡e ZLb †h Book/File Gi g‡a¨
KvR Kiv n‡”Q †mwU Select K‡i Gi Aaxb¯’ †Kvb Sheet Copy Kie †mwU Select K‡i Zvici
_ Create A Copy Box G (_) wPý w`‡q
_ Ok Click Ki‡jB H kx‡Ui Abyiƒc Av‡iKwU Kwc ˆZix n‡e| Gi d‡j hw` GKwU Worksheet Delete n‡q hvq
Z‡e Kwc Kiv Ab¨ Worksheet wU w`‡q KvR Kiv hv‡e|

11. Find (kã †LuvRv) t
_ ‡jLv ev dvB‡ji ïi“‡Z Cursor ‡i‡L
_ Edit Click
_ Find Click Ki‡j Find Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU LyuR‡Z n‡e Zv wj‡L
_ Find Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H
Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z c~bivq
_ Find Next Click Ki‡j hw` H Word wU GKvwaKevi _v‡K Ges Luy‡R cvIqv hvq Zvn‡j Word wU †h †h Cell
Gi g‡a¨ Av‡Q Cursor H mKj Cell Gi g‡a¨ G‡K G‡K P‡j hv‡e| †LvRv †kl n‡j
_ Close Click Ki‡jB Find Dialog Box P‡j hv‡e|
[ NB t Find KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Find KgvÛ Gi Key Board Key n‡jv Ctrl + F ]

12. Replace (kã cÖwZ¯’vcb Kiv) t
_ ‡jLv ev dvB‡ji ïi“‡Z Cursor ‡i‡L
_ Edit Click
_ Replace Click Ki‡j Replace Dialog Box Avm‡e ZLb Find What Box Gi g‡a¨ †h Word wU cÖwZ¯’vcb
Ki‡Z n‡e Zv wj‡L Ges Replace With Box Gi g‡a¨ cÖwZ¯’vcb K‡i hv emv‡Z PvB Zv wj‡L
_ Find Next Click Ki‡j hw` H Word wU Luy‡R cvIqv hvq Zvn‡j Word wU †h Cell Gi g‡a¨ Av‡Q Cursor H
Cell Gi g‡a¨ P‡j hv‡e| cieZ©x‡Z
_ Replace Click Ki‡j †h Cell Gi g‡a¨ Cursor _vK‡e H Cell Gi †jLvwU cÖwZ¯’vwcZ n‡e| Ges Replace All
Click Ki‡j †h Cell Gi g‡a¨ Cursor _vK‡e H Cell Gi †jLvwU GKvwaKevi _vK‡j me¸‡jv GKmv‡_ cÖwZ¯’vwcZ
n‡e| g‡bi B‡”QgZ cÖwZ¯’vcb Kiv †kl n‡j
_ Close Click Ki‡jB Replace Dialog Box P‡j hv‡e|
NB t Replace KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Replace KgvÛ Gi Key Board Key n‡jv Ctrl + H
13. Go To (wbw`©ó †Kvb †m‡j hvIqv) t
_ Avgiv Rvwb Spreadsheet Analysis Software Microsoft Excel Gi g‡a¨ cÖ‡Z¨KwU Worksheet (IqvK©kxU)
G 256 wU Column (Kjvg) Ges 65536 wU Row (†iuv) _v‡K| KvR Kivi mgq Avgv‡`i Lye ZvovZvwo †h †Kvb
Cell (†mj) Gi g‡a¨ hvIqvi cÖ‡qvRb n‡e| GRb¨
_ Edit Click
_ Go To Click Ki‡j Go To Dialog Box Avm‡e ZLb Reference Box Gi g‡a¨ †h Cell G †h‡Z PvB †mB
Cell Address wj‡L
_ Ok Click Ki‡jB Cell Address Abymv‡i Cursor wbw`ªó Cell Gi g‡a¨ P‡j hv‡e|
[ NB t Go To KgvÛ Avgiv Key Board Gi gva¨‡g w`‡Z cvwi| Go To KgvÛ Gi Key Board Key n‡jv Ctrl + G. ]

No comments:

Post a Comment