View Menu Microsoft Excel XP

** View Menu **

1. Page Break Preview (c„óv ˆZix Kivi ci we¯v— wiZ †`Lv) t

_ cÖ‡g Worksheet Gi g‡a¨ †Kvb wKQy wj‡L †jLvi g‡a¨ Cursor ‡i‡L Normal Mode G _vKve¯’vq

_ View Click

_ Page Break Preview Click

_ Ok Click Ki‡jB ˆZixK…Z Page ¸‡jv fv½v Ae¯’vq †`Lv hv‡e| GLv‡b †h Ae¯’vq †`Lv hv‡e wVK †mB Ae¯’v‡ZB

Print (wcÖ›U) n‡e| GKB c„óvi Awa‡b KZ¸‡jv Row ev Column Print (wcÖ›U) n‡e Zv GB Page Break

Preview †Z Ae¯’vbKv‡j fvjfv‡e ‡`Lv hvq|

2. Normal (c„óv‡K ¯^vfvweK Ae¯’vq wb‡q Avmv) t

_ Excel Gi File/Book Page Break Preview ‡Z _vKve¯’vq

_ View Click

_ Normal Click Ki‡jB Worksheet Normal Mode G P‡j hv‡e|

3. Toolbars (wewfboe Uzjevi †Lvjv Ges eÜ Kiv) t

_ KvR Kivi mgq Menu bar ‡_‡K wewfboe Command bv w`‡q Toolbar Gi mvnv‡h¨ H GKB Command w`‡j

A‡bK `ª“Z KvR m¤úv`b Kiv hvq| Avgiv

_ View Click K‡i Mouse Pointer Toolbars Gi g‡a¨ wb‡q †M‡j Gi Awab¯’ wewfboe Toolbars List ‡`Lv hv‡e| GB

Ae¯’vq †h me Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨ Active (¯^w_q)

Ae¯’vq Av‡Q| Aciw`‡K †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv †bB a‡i wb‡Z n‡e †m¸‡jv Screen (¯OExb) Gi g‡a¨

Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z †h mKj Toolbars Gi ev‡g (_) wPý ‡`Iqv Av‡Q †m¸‡jvi g‡a¨ Mouse

Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j hv‡e Ges Inactive (wb®OExq) n‡q hv‡e Aciw`‡K †h mKj Toolbars Gi

ev‡g (_) wPý ‡`Iqv †bB †m¸‡jvi g‡a¨ Mouse Pointer Øviv c~bivq Click Ki‡j (_) wPý P‡j Avm‡e Ges Active

((¯^w_q) n‡q hv‡e| Gfv‡e Toolbars On/Off Kiv hvq|

4. Formula Bar (dg©~jvevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq †h †Kvb Cell Gi g‡a¨ wK Av‡Q Zv (Cell Contant)

‡`Lvi Rb¨ GB Formula Bar (dg©~jvevi) e¨envi Kiv nq|

_ View Click Kivi ci Formula Bar (dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z n‡e

Formula Bar (dg©~jvevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Formula Bar

(dg©~jvevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Formula Bar (dg©~jvevi) Screen

(¯OExb) Gi g‡a¨ Inactive (wb®OExq) Ae¯’vq Av‡Q| cieZ©x‡Z Formula Bar (dg©~jvevi) Gi g‡a¨ Click K‡i

Toolbars Gi g‡ZvB Formula Bar (dg©~jvevi) †K On/Off Kiv hvq|

5. Status Bar (‡÷Uvmevi †Lvjv Ges eÜ Kiv) t

_ Microsoft Excel Program Gi g‡a¨ KvR Kivi mgq ‡h †Kvb Program Gi †÷Uvm m¤ú‡K© avibv cvIqvi Rb¨

GB Status Bar (‡÷Uvmevi) e¨envi Kiv nq|

_ View Click Kivi ci Status Bar (‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv _v‡K Zvn‡j a‡i wb‡Z

n‡e Status Bar (‡÷Uvmevi) Screen (¯OExb) Gi g‡a¨ Active (¯^w_q) Ae¯’vq Av‡Q Aciw`‡K Status Bar

(‡÷Uvmevi) Gi evg cv‡ki N‡i hw` (_) wPý ‡`Iqv bv _v‡K Zvn‡j a‡i wb‡Z n‡e Status Bar (‡÷Uvmevi)

Screen (¯OExb) Gi g‡a¨ Inactive (wbw®OEq) Ae¯’vq Av‡Q| cieZ©x‡Z Status Bar (‡÷Uvmevi) Gi g‡a¨ Click

K‡i Toolbars Gi g‡ZvB Status Bar (‡÷Uvmevi) †K On/Off Kiv hvq|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

6. Header & Footer (c„óvi ‡nWvi I dzUvi †`Iqv) t

_ View Click

_ Header & Footer Click Ki‡j Page Setup Dialog Box Avm‡e (hvi gva¨‡g Avgiv c~‡e© File Menu ‡Z

Page & Margin Setup wk‡LwQjvg) Zvici

_ Header & Footer Tab Select Kiv bv _vK‡j Select K‡i

_ Custom Header Click Ki‡j Header Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Header Setting n‡q hvq| cieZ©x‡Z

_ Custom Footer Click Ki‡j Footer Box Avm‡e ZLb g‡bi B‡”QgZ Left Section, Center Section &

Right Section BZ¨vw`‡Z wjL‡Z cvwi, Toolbar Gi mnvqZvq †jLv wWRvBb, Page No, Date, Time, File

Name, Sheet Name BZ¨vw` Select Ki‡Z cvwi| Gme KvR wVKgZ Kivi ci

_ Ok Click Ki‡j Footer Setting n‡q hvq| Dc‡i D‡j−wLZ wbqgvbymv‡i Custom Header & Custom Footer

Setting Kiv †kl n‡j

_ Ok Click K‡i Print Preview Click Ki‡j Header & Footer h_v¯’v‡b cÖ`wk©Z n‡e|

7. Comments (gše— ¨ Kiv) t

NB t Spreadsheet Analysis Software (Microsoft Excel) Gi g‡a¨ KvR Kivi mgq A‡bK mgqB wewfboe

wel‡qi Dci ev wewfboe †jv‡Ki m¤ú‡K© gš—e¨ Kivi cÖ‡qvRb nq| Comments (gš—e¨ Kiv) Option wUi KvR Avgiv

View & Insert GB `yB Menu ‡_‡KB Ki‡Z cvwi| Z‡e View Menu ‡_‡KB Lye mn‡R KvRwU m¤úv`b Kiv hvq|

Avgiv †h †Kvb Cell Gi g‡a¨ Cursor ‡i‡LB Comments (gš—e¨ Kiv) Ki‡Z cvwi| A_©vr KvR Kivi Av‡M †h Cell

Gi g‡a¨ Cursor ivLv n‡e †mB Cell Gi g‡a¨B Comments (gš—e¨ Kiv) n‡e| Zvn‡j Avmyb Avgiv gš—e¨ Kiv wkwL

 

           View Click

           Comments Click Ki‡jB Reviewing Toolbar On n‡e (Avgiv View Menu Gi Aš—M©Z Toolbars

‡_‡KI Reviewing Toolbar On Ki‡Z cvwi)| cieZ©x‡Z †h Cell Gi g‡a¨ Comments (gš—e¨ Kiv) Ki‡Z PvB

†mB Cell Gi g‡a¨ Cursor ‡i‡L Reviewing Toolbar Gi Aaxb¯’

(K). cÖg Option (New Comment) Gi g‡a¨ Click Ki‡j Cursor ‡h Cell Gi g‡a¨ wQj †mB Cell wUi g‡a¨ GKwU Comment Box ‰Zix

n‡e| Avgiv GB Box Gi g‡a¨ gš—e¨ wjL‡Z cvwi| Gfv‡e †h †Kvb Cell Gi g‡a¨ Cursor ‡i‡L Reviewing Toolbar Gi Aaxb¯’ cÖg Option

(New Comment) Gi mvnv‡h¨ gš—e¨ Ki‡Z cvwi|

(L). wØZxq Option (Previous Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi c~e©eZ©x †hme Cell ¸‡jv‡Z Comments (gš—e¨

Kiv) Kiv Av‡Q †m¸‡jv G‡K G‡K †`Lv‡e|

(M). Z„Zxq Option (Next Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi cieZ©x †hme Cell ¸‡jv‡Z Comments (gš—e¨

Kiv) Kiv Av‡Q †m¸‡jv G‡K G‡K †`Lv‡e|

(N). PZz © Option (Hide Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi g‡a¨ gš—e¨ Kiv _vK‡j Zv jywK‡q hv‡e|

†jvKv‡bv Ae¯’vq H Cell Gi Dc‡ii Wvb †Kv‡b jvj wPý cÖ`wk©Z n‡e| cieZ©x‡Z Avevi wdwi‡q Avb‡Z n‡j H Cell Gi g‡a¨ Cursor †i‡L H GKB Option

(Show Comment) Gi g‡a¨ Click Ki‡j gš—e¨ cÖ`wk©Z n‡e| A_©vr PZz © Option wU †h †Kvb GKwU Cell Gi g‡a¨ ˆZix Kiv gš—e¨ cÖ`k©b Kiv Ges †jvKv‡bvi

Rb¨ e¨envi Kiv nq| gš—e¨ †jvKv‡bv _vK‡j Bnv Show Comment Ges cÖ`wk©Z _vK‡j Hide Comment Shaport K‡i|

(O). cÂg Option (Hide All Comment) Gi g‡a¨ Click Ki‡j Worksheet Gi g‡a¨ gš—e¨ Kiv _vK‡j me¸‡jv gš—e¨B jywK‡q hv‡e| †jvKv‡bv

Ae¯’vq ‡hme Cell Gi g‡a¨ gš—e¨ Kiv Av‡Q †mme Cell Gi Dc‡ii Wvb †Kv‡b jvj wPý cÖ`wk©Z n‡e| cieZ©x‡Z Avevi me¸‡jv gš—e¨ wdwi‡q Avb‡Z

n‡j ‡h †Kvb ¯’v‡b Cursor †i‡L H GKB Option (Show All Comment) Gi g‡a¨ Click Ki‡j me¸‡jv gš—e¨ cÖ`wk©Z n‡e| A_©vr cÂg Option

wU †h †Kvb Worksheet Gi g‡a¨ ˆZix Kiv GKvwaK gš—e¨ cÖ`k©b Kiv Ges †jvKv‡bvi Rb¨ e¨envi Kiv nq| gš—e¨ †jvKv‡bv _vK‡j Bnv Show All

Comment Ges cÖ`wk©Z _vK‡j Hide All Comment Shaport K‡i|

(P). 6ó Option (Delete Comment) Gi g‡a¨ Click Ki‡j Cursor eZ©gv‡b ‡h Cell Gi g‡a¨ Av‡Q †mB Cell Gi g‡a¨ gš—e¨ Kiv _vK‡j Zv

†gv‡Q hv‡e| GKvwaK gš—e¨ GKmv‡_ †gvQ‡Z n‡j †h¸‡jv ‡gvQ‡Z PvB †m¸‡jv Block/Select K‡i Delete Comment Click Ki‡Z n‡e|

NBt Reviewing Toolbar Gi Aaxb¯’ mßg, Aóg Ges beg Option ¸‡jv Internet (B›Uvi‡bU) Gi Kv‡R e¨envi Kiv nq|

Microsoft Excel XP

Created By: Kamrul Hassan Bappy Bappy Computer Education Centre

8. Custom View t

------ wb®cÖ‡qvRb| -----

9. Full Screen (cy‡iv ¯OExbRy‡i †`Lv) t

_ View Click

_ Full Screen Click Ki‡j ˆZixK…Z dvBjwU cy‡iv ¯OExbRy‡i †`Lv hv‡e| ceeZ©x‡Z Screen ¯^vfvweK Ki‡Z PvB‡j

Avevi

_ View Click

_ Full Screen Click Ki‡j A_ev Close Full Screen Click Ki‡j Screen wU ¯^vfvweK Ae¯’vq cÖ`wk©Z n‡e|

10. Zoom (¯OEx‡bi cÖ`k©b mvBR cwieZ©b Kiv) t

_ View Click

_ Zoom Click Ki‡j Zoom Dialog Box Avm‡e ZLb †h cvi‡m›U(%) G cÖ`k©b Ki‡Z PvB Zv Click c~e©K

Select K‡i

_ Ok Click Ki‡jB wbw`ªó cvi‡m›U(%) Abymv‡i ¯OEx‡bi AvKvi †QvU/eo n‡e|

NB t g‡b ivL‡Z n‡e Avgiv Standard Toolbar Gi mvnv‡h¨ Lye mn‡RB ¯OEx‡bi cÖ`k©b mvBR cwieZ©b Ki‡Z cvwi|

¯OEx‡bi ¯^vfvweK cÖ`k©b mvBR n‡”Q 100%|