Excel

     M. S. EXCEL  (,Dly)  

Home  

©       Cut :- bl dek.M dh lgk;rk ls ges select fd, x, matter  dsk dkV dj dgha vkSj yxk ldrs gSaA

©       Copy :- bl dek.M dh lgk;rk ls ge select fd, x, matter dks MqIyhdsV dkWih cuk ldrs gSaA

©       Paste :- bl dek.M dh lgk;rk ls ge dkWih ;k dV fd, x, matter  dsk dgha Hkh isLV dj ldrs gSA

©       Paste special :- bl dekaM dh lgk;rk ls ge dkWih fd, x, matter  esa ls dsoy QksjesV dsk] dsoy dUVsaV] dsoy desaV dks] dsoy QkeqZyk] dsoy osyhMs'ku] vkfn dks isLV djok ldrs gSA ,oa bldh lgk;rk ls ge dkWih fd, x, matter  dsk QkbZy esa fLFkr nwljs matter  esa ,M] lcLVªsd] eYVhIykbZ ,oa fMokbZM dj ldrs gSA

©       Paste spacial :- Paste spacial ls x.kuk djuk %& Excel ds vUrZxr tks³us] ?kVkus] xq.kk djus vkSj Hkkx nsus] tSls dk;Z Paste spacial dekUM es fn;s gq, fodYiks ls dj ldrs gSaaA mnkgj.k & c vkSj d  dkWye esa la[;k, gSa budks vkil esa tks³uk gSaA

ü lcls igys c dkWye dks copy djsaA

ü dkWye D dks lysDV djsA

ü key bord ds }kjk shift ds lkFk F10  QaDlu key dks nck;s ;k ekml dk jkbZV cVu Dyhd djs] ;k Home ehuw esa Paste spacial dekUM ij Dyhd djsaA

ü Paste spacial uke dk ckWDl LØhu ij [kqydj lkeus vk tk;sxkA ’ Mk;ykWx ckWDl esa operation uked Hkkx esa Add jsfM;ks cVu ij Dyhd djs] ’ ok cVu ij Dyhd djus ls dkWye c es fy[kh gqbZ la[;k] dkWye D esa fy[kh gqbZ la[;kvks ls tq³ tk;sxhA

ü la[;kvks dks vkil esa xq.kk djus ds fy;s operation uked Hkkx esa multiply  jsfM;ks cVu ij Dyhd djs] ’ ok cVu ij Dyhd djus ls xq.kk gks tk;sxkA

ü la[;kvks dks vkil esa ?kVkus ds fy;s operation uked Hkkx esa subtract jsfM;ks cVu ij Dyhd djs] ’ ok cVu ij Dyhd djus vkil esa la[;k ?kV tk;sxhA

ü la[;kvks dks vkil esa Hkkx nsus ds fy;s operation uked Hkkx esa Divide jsfM;ks cVu ij Dyhd djs] ’ ok cVu ij Dyhd djus ls Hkkx gks tk;sxkA

©    Paste As Hyperlink :- bl dek.M dh lgk;rk ls ge ftl matter dks copy  fd;k gS mldks isLV djus ds lkFk gh mldk link, copy matter ls dj ldrs gSa A blls ;g irk yxk ldrs gSa fd paste esa fd, x;s matter  dsk dgak ls copy  fd;k x;k gSA

©       Format painter :- 1.Excel dh odZ'khV ds cell es dyj nsus ds ckn] ogh(tks dyj fn;k gSa) dyj nqljs txg cell ds vUnj dyj nsuk gks rks] igys cell es dyj fn;k x;k ml ij dlZj ls Dyhd dj→  Format painter ij Dyhd dj → ftl cell es dyj nsuk gSa ml cell es Dyhd djus ls] mlh cell dk ogh dyj Add (save)gks tk,xkA

©       Format painter :- 2. Excel dh odZ'khV ds cell es fofHkUu Type font size esa ,d lEeku djus ds fy, Format painter dk ;wt gksrk gSaA Ž'kCnks dh Formating change djuh gks rks] okD; ij Dyhd dj Format painter ij Dyhd dj → ftl cell es Formating change djuh gks change djuh gks ml cell es Dyhd djus ls] mlh cell dh Formating change gks tk,xkA

©       wrap Text:- ,d gh dkWye es fy[ks eSVj dks mlh dkWye es j[kuk] ckgj ugh tkus dk rjhdk%& Excel ds dkWye es fy[ks x;s eSVj dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ij format cells vksilu vksiu gksxkA format cells ij Dyhd djus ij pkVZ vksiu gksxkA pkVZ es Alignment ij Dyhd djus ij wrap Text vksilu vksiu gksxkA wrap Text ij Dyhd djus ls eSVj dkWye es gh jgsxk] ckgj ugh tk,xk

©       wrap Text:- M.s Excel  ¼,Dly½ es ,d dkWye es 'kCn yEcs gks tkrs gSaA mlh dkWye es 'kCnks ds fups 'kCn ykus ds fy, rjhdk %& ,Dly ds dkWye es fy[krs le; dkWye ds ckgj tk jgs gksA mlh dkWye es 'kCnks ds fups 'kCn ykus ds fy, & fy[ks x;s 'kCnks dks lysDV djus ds ckn mlh ykbZu ij ekml dk jkbZV cVu Dyhd djus ls vksilu format cells dk pkVZ vksiu gksxkA mles Alignment ij Dyhd djus ds ckn fups vksilu wrap text ij Dyhd djus ls lgh dk fu’kku gksxkA ckn ok djus ls dkWye es 'kCnks ds fups 'kCn vk tk,xsaA 2 nqljk rjhdk %& Home ij Dyhd djus ls gkse es vksilu format  vksiu gksxkA format ij Dyhd djus ls format cells  vksilu vk,xkA format cells ij Dyhd djus ls format cells uke dk pkVZ vksiu gksxkA mles Alignment ij dyhd djus ds ckn fups vksilu wrap text ij Dyhd djus ds ckn ok dks lysDV djus ls dkWye es 'kCnks ds fups 'kCn vk tk,xsaA

©       merge cells:-M.S  Excel dh 'khV es dkWyeks dks gVkus ds fy, rjhdk %& igys dkWye dks lysDV djus ds ckn &  Home ij Dyhd djus ls gkse es Alignment okys dkWye ds Åij merge & center ds ikl rhj dk fu’kku ij dlZj ls Dyhd djus ls merge & center, merge cells, Unmerge, Merge Across vksilu vksiu gksxsaA

©       Merge cells :-  Excel 'khV es dkWye¼'kSy½ lysDV djus ds ckn Merge cells ij Dyhd djus ls dkWye ¼'kSy½ gV dj ,d cM+k ;k yEck cu tk,xkA o Unmerge  ij Dyhd djus ls dkWye¼'kSy½ okil cu tk,xsaA

©        Excel (Home) es  merge & center ij Dyhd djus ls excel 'khV es lysDV fd;s x;s dkWye ¼'kSy½ gV tk,xs o ,d cM+k ;k yEck dkWye cu tk,xkA nqckjk  merge & center ij Dyhd djus ls 'kSy ¼dkWye½ okil cu tk,xsaA dkWye ¼'kSy½ gVkdj mles %& tSls dk;kZy; Fkkukf/kdkjh iqfyl Fkkuk lnj ikyh ¼jkt½ fy[k ldrs gksA

©       Merge Across :- excel 'khV es lysDV fd;s x;s dkWye¼'kSy½ merge across ij Dyhd djus ls [kM+h ykbZuks gV dj lHkh yEck dkWye cu tk,xkA Excel ds dkWye es fy[ks x;s eSVj dks 45 fMxzh] 90 fMxzh ij ¼frjNk djuk½ ykus dk rjhdk%& Excel ds dkWye es fy[ks x;s eSVj dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ij format cells vksilu vksiu gksxkA format cells ij Dyhd djus ij pkVZ vksiu gksxkA pkVZ es Alignment ij Dyhd djus ls orientalion vksilu vksiu gksxkA Text es ftruh fMxzh ij j[kuk pkgrs gks ml fMxzh ¼45 ;k 90 fMxzh½ij Dyhd djus ds ckn ok djus ls dkWyeks es fy[ks x;s eSVj frjNs gks tk,xsa

©       Excel es  dkWyek ¼cell½ dk vyx&vyx dyj djus ¼cnyus½ dk rjhdk ¼Homees½%&Excel es dkWye dks lysDV djus ds ckn Home es cell styles ds vkxs rhj ds fu'kku ij Dyhd djus ij Good, Bad and Neutral uke dk pkVZ vksiu gksxkA pkVZ es vko';drkuwlkj ij dyj ij Dyhd djus ls cells dk dyj cny tk,xkA o Normal ij Dyhd djus ls  Excel 'khV dk dyj gV tk,xkA

©       insert (Home es):- nksuks lkbZM es dkWye c<kus ds fy, %& igys Left ;k Right dkWye dks lysDV djus ds ckn Homeª insertª ;k ekml dk jkbZV cVu Dyhd djus ls ehuw es insert ij Dyhd djus ls vksilu insert columns to the Left  ;k  Right ij Dyhd djus ls ys¶V ;k jkbZV dkWye c< tk,xs

©       insert cell :- bl dekaM dh lgk;rk ls ge QkbZy esa lsy bUlVZ djok ldrs gSaA u;k lsy bUlVZ djokus ij igys okys lsy ;k jkbZV esa ;k uhps dh rjQ f[kld tkrs gSaA

©       Row :- bl dekaM dh lgk;rk ls ge QkbZy esa ubZ Row Insert  djok ldrs gSA

©       u;k Row tks³uk %& Select Row " Right click" Insert " insert Row Above/ Below

©       Row dks gVkuk %& Select Row " Right click" Delete Column

©       Columns :- bl dekaM dh lgk;rk ls ge QkbZy esa u;k dkWye bUlVZ djok ldrs gSaA

©       u;k Column tks³uk %& Select Column " Right click" Insert " insert Column Left / Right

©       Column dks gVkuk %& Select Column " Right click" Delete Column

©       Worksheet :- bl dekaM dh lgk;rk ls ge QkbZy esa ubZ odZ 'khV bUlVZ djok ldrs gSaA

©       Insert sheet—bl vksilu ij Dyhd djus ls ,d u;h sheet cu tk,xhA

©       Worksheet :- Worksheet dks bUlVZ djus ds fy, 'kksVZdV rjhdk %& shift+F11 ;k Alt+shitt+F1 nckus ls ubZ Worksheet bUlVZ gks tk,xhA

©       Worksheet ¼odZ'khV½ dks fMysV djuk %& ftl odZ'khV dks fMysV djuk gks mlds odZ'khV VSc ¼fpUg½ ij ekml dk jkbV cVu Dyhd ij delete fodYi ij Dyhd djus ls odZ'khV delete gks tk,xhA blds vfrfjDr Edit ehuw es delete sheet ij Dyhd djus ls odZ'khV delete gks tk,xhA

©    Fill :- bl dekaM dh lgk;rk ls ge lysDV fd xbZ lsy ds vUnj QLVZ lsy esa fLFkr la[;k dks ysQ~V jkbZV] vi] Mkmu esa fQy dj ldrs gSA rFkk bl dekUM dh lgk;rk ls lysDV fd xbZ lsy esa ykbZuj ] xq.kksrj ,oa MsV okbZt fljht cuk ldrs gSA

©    Clear :- bl dekaM dh lgk;rk ls ge lysDV fd, x, lsy ds vanj fLFkr esVj esa ls dsoy QksjesV] dsoy desUV] dsoy dUVsaV ,ao lHkh dks ,d lkFk gVk ldrs gSaA

©    Delete :- bl deakM dh lgk;rk ls ge lsy dks fMyhV dj ldrs gSaA

©    Delete  Sheet :- bl dekaM dh lgk;rk ls ge QkbZy dh ,DVho odZ 'khV dks fMyhV dj ldrs gSA

©    Move or Copy  Sheet :- bl dekaM dh lgk;rk ls ge ,DVho odZ 'khV dh MqIyhdsV dkWih cuk ldrs gSa ,oa ,fDVo 'khV dks viuh bPNkuqlkj fdlh Hkh 'khV ds vkxs ;k ihNs ewo djk ldrs gSaA

©    Find :- bl dek.M fd lgk;rk ls ge QkbZy esa dskbZ Hkh 'kCn ;k v{kj dks search  djok ldrs gSA

©    Replace :- bl dek.M fd lgk;rk ls ge QkbZy esa dskbZ Hkh 'kCn ;k v{kj dks ifjofrZr  djok ldrs gSA

©    Go to :- bl dek.M dh lgk;rk ls ge QkbZy ds fdlh Hkh lsy] ykbZu] cqdekdZ] ,uksVs'ku] vkfn ij Mk;jsDV tk ldrs gSA

©   Format:- Excel dh sheet es column dks pkSM+k djus dk rjhdk%& Excel dh sheet es column dks pkSM+k djus ds fy, A,B,C,D,E,F, G,H okys column es dlZj ykbZu ij ys tkus ls pkSdM+h dk fu'kku open gksxkA ogka dlZj nckdj [khpdj column dks NksVk&cM+k dj ldrs gSaA

©   Cell :- bl dekaM dh lgk;rk ls ge QkbZy ds vanj fLFkr lsy dh QksesZfVax dj ldrs gSA

©   Column :- bl dekaM dh lgk;rk ls ge dkWye dh QksesaZfVax dj ldrs gSa A bl deakM dh lgk;rk ls ge dkWye dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM ls ge dkWye dks gkbZM o vugkbZM Hkh dj ldrs gSaA

©      Column width :- Excel es [kM+s column dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ij column width vksilu vksiu gksxkA column width ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es column width ds vkxs Dyhd djus ij lgh dk fu'kku vkus ds ckn  dkWye es de la[;k vafdr dj ok djus ls [kM+s column ds fcp dk xsi ¼Qklyk½ de gks tk,xkA o T;knk la[;k vafdr dj ok djus ls fcp dk xsi ¼Qklyk½ T;knk gks tk,xkA

©      Row :- bl dekaM dh lgk;rk ls ge row dh QksesaZfVax dj ldrs gSa A bl deakM dh lgk;rk ls ge row dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM ls ge row dks gkbZM o vugkbZM Hkh dj ldrs gSaA

©      Row Height :- Excel es Row dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ij Row Height vksilu vksiu gksxkA   Row Height ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es Row Height ds vkxs Dyhd djus ij lgh dk fu'kku vkus ds ckn dkWye es de la[;k vafdr dj ok djus ls  row ¼vkMk½ ds fcp dk xsi ¼Qklyk½ de gks tk,xkA o T;knk la[;k vafdr dj ok djus ls row ¼nksuks ykbZuks ds fcp½ ds fcp dk xsi T;knk gks tk,xsA

©      Worksheet :- bl deakM dh lgk;rk ls ge worksheet  fd QksjesfVax dj ldrs gSaA bl dekaM dh lgk;rk ls ge dkWye dh pkSMkbZ Hkh c<k ldrs gSA bl dekaM dh lgk;rk ls odZ'khV dk uke Hkh psat dj ldrs gSaA bl dekaM dh lgk;rk ls odZ'khV dks gkbZM o vugkbZM Hkh dj ldrs gSaA bl dekaM dh lgk;rk ls odZ'khV dk cSdxzkmaM Hkh lsV dj ldrs gSaA

©      Auto Format :- MS-Excel  ds vanj dqN cus cuk;s QksjesV gSaA ;fn geus MS-Exceld esa vanj dqN dke fd;k gS] rks ge bl dke dks mu cus cuk;s QksjesV esa ifjofrZr dj ldrs gSaA

©      Excel es uke oxSjk <+q<+uk gks rks iqjh 'khV dks lysDV djus ds ckn find ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es find what ds vkxs dkWye es tks uke <+q<+uk pkgrs gks oks uke fy[kdj Reading High light ij Dyhd djus ls uke gkbZykbZV gks tk,xkA

©      insert (Home es) :-  Excel es %& Excel dh ’khV es u;k Row insert  djus ds fy,] row dks lysDV djus ds ckn insert ij Dyhd djus ls ,d u;k row cu tk,xkA

©      Excel dh iqjh ’khV es u;k column ([kM+k) cukus dk rjhdk%&  tgk¡ column cukuk gSa ogk¡ dlZj ls Dyhd djus ds ckn ekml dk jkbZV cVu Dyhd djus ij insert vksiu gksxk insert ij Dyhd djus ls insert  uke dk pkVZ vksiu gksxkA pkVZ es Entire column vksilu ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok djus ij iqjh ’khV es ,d u;k column([kM+k) cu tk,xkA

©       Excel dh ’khV es ’kq: ls eSVj fy[k fn;k gSa mlds Åij txg ugh gSaA vkSj ,d u;k row (vkMk dkWye)  cukuk gSa%& Åij ds row dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ls insert uke dk vksilu vksiu gksxkA insert ij Dyhd djus ls ,d u;k Row (vkMk dkWye) Åcu tk,xkA ;k Åij ds row es dlZj ls Dyhd djus ds ckn ekml dk jkbZV cVu Dyhd djus ij insert vksiu gksxk insert ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es Entire row vksilu ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok djus ij ,d u;k row (vkMk dkWye) cu tk,xkA

©      ,d gh column es fups dh rjQ ,d u;k cells cukus rjhdk%& column es ,d u;k  cell cukuk gSa ogk¡ dlZj ls Dyhd djus ds ckn ekml dk jkbZV cVu Dyhd djus ij insert vksiu gksxk insert ij Dyhd djus ls insert  uke dk pkVZ vksiu gksxkA pkVZ es shift cells down vksilu ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok djus ij ,d gh column es fups dh rjQ ,d u;k cells cu tk,xkA

©      ,d gh row es lkbZM dh rjQ ,d u;k cells cukus rjhdk%& row es lkbZM dh rjQ ,d u;k  cell cukuk gSa ogk¡ dlZj ls Dyhd djus ds ckn ekml dk jkbZV cVu Dyhd djus ij insert vksiu gksxk insert ij Dyhd djus ls insert  uke dk pkVZ vksiu gksxkA pkVZ es shift cells right vksilu ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok djus ij ,d gh row es lkbZM dh rjQ ,d u;k cells cu tk,xkA

©      ,e ,l ,Dly dh QkbZy es ubZ lhV cukus dk rjhdk   %  ,Dly dh     QkbZy es cuh gqbZ 'khV ij ekml dk jkbV cVu Dyhd djus ls vksilu vksiu gksxsaA vksilu es bUlVZ ij Dyhd djus ls ,d ubZ 'khV cu tk,xhA 2 nqljk rjhdk % & 'kksVZdV & shift+f11 nckus ls ubZ 'khV [kqy tk,xh A 3 rhljk rjhdk %&  'khV ds fups 1sheet, 2sheet, 3sheet ds vkxs ,d fu’kku insert  worksheet  ij Dyhd djus ls ubZ 'khV cu tk,xh A

©       ;fn Excel dh sheet es table cuh gqbZ gS vkSj ml tabte es ls special No. tSls 40 ls T;knk ;k 40 ls de ds la[;k NkaVuh gS rks ge home menu ds style option es tkdj conditional formeting ij click djsa mlesa highlight cell rules es tkdj vxj de ls T;knk ns[kuh gS rks greater than(>) djuk gS ;fn T;knk ls de ns[kuh gS rks less than(<) ij click djuk gS vkSj eu pkgs uEcj NkV dj colour full gks tk;sxs

©       ;fn sheet ij ls ml colour dks gVkuk gS rks ml fy[ks gq, matter dks select djds ogh home menu ds style option es conditional formeting ij click djs rFkk lcls uhps clear rule ij click djds mles clear rule select cell ij click djs colour gV tk;sxk

©       bldk odZ ,jh;k odZ’khV dgykrk gSaA

©       Row ¼iafDr½ o column ¼LrEHk½ dks feykdj odZ’khV curh gSaaA ‘’khV dk  ,d ckWDl dks cell dgykrk gSaA blesa 1048576 iafDr gksrh gSaA o 16384 column gSaA

©    ,d cell ls nwljs cell esa tkus ds fy, tab key dks nck;sxs rFkk ,d cell ls uhps okys cell es tkus ds fy, Enter key dks nck;sxsaA ;k ,jks key dk iz;ksx fd;k tkrk gsaA

©    Excel dh cell esa uEcj ges’kk jkbZV lkbZM esa vkrs gSaA v{kj ges’kk ck;s rjQ vkrs gSaA

©    Excel dh cell esa uEcj vkSVks uEcjhUx yxkus ds fy, cell esa la[;k 1 fy[kdj Enter key dks nck;s] nwljs cell esa la[;k 2 VkbZi djsaa] 'khV es [kkyh txg ij Dyhd djus ds ckn la[;k 1 o 2 dks lysDV djs] lysDV nksuks cell ds jkbZV lkbZM esa uhps  okys dksus ij ekml IaokUVj ys tkus ij + iYl dk fpUg 'kks djus ij ekml dk Left cVu nckdj uhps [khapdj Nks³us ij vksVks uEcj yx tk;sxsaA

©      Excel es & Insert  :- Table, column to the Left, column to the Right, Row Above, Rows Below, cells.

©      Delete es :- Table, column, Rows, cells.

©      Select es :-  Table, column, Rows, cells.

©      convert es :- Text to Table, Table to Text.

©      Insert es %& insert ij Dyhd djus ls 1. Insert cells — sheet es tgka dlZj gSa ogka ,d u;k cell cu tk,xkA 2. Insert sheet Rows — bl vksilu ij Dyhd djus ls ,d u;k Row tqM+ ¼cu½tk,xkA 3. Insert sheet columns — bl vksilu ij dyhd djus ls sheet es ,d u;k column tqM+¼cu½ tk,xkA

©      Subscript :- EXCEL es H2 dks H₂ Subscript djuk gks rks la[;k 2 dks lysDV djus ds ckn Font ds pkVZ es tkdj Subscript ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok ij Dyhd djus lsa la[;k 2 fups dh rjQ vk tk,xhA tSls H2 dks H₂  gks tk,xkA

©      Super script :- EXCEL es H2 dks H²  Super script djuk gks rks la[;k 2 dks lysDV djus ds ckn Font ds pkVZ es tkdj Super script ds vkxs xksy fcUnq es dlZj ls Dyhd djus ds ckn ok ij Dyhd djus lsa la[;k 2 Åij dh rjQ vk tk,xhA tSls H2 dks H² gks tk,xkA

©      Strickethrough :- excel es blds vkxs Dyhd djus ls e/;e es gks tk,xkA

©      u;h odZ'khV Mkyuk] gVkuk ,oa uke cnyuk (creating / Renaming / Deleting worksheet) :-- LØhu dh fupyh Hkkx ¼status bar½ ij sheet Tab ds Åij jkbZV Dyhd djus ij Insert }kjk vko';dekuwlkj odZ'kkhV dh la[;k c<kbZ (insert) o ?kVkbZ¼Delete½ tk ldrh gSaA rFkk Rename }kjk bPNkuwlkj uke fn;k tk ldrk gSaA

©      Row Heading :- odZ'khV es izR;sd Row ds ck;sa rjQ uEcj Åij ls fups tSls 1,2,3 …ds :i es fy[ks tkrs gSa ftldks Row gSfMax dgk tkrk gSaA tks u;h odZ'khV [kksyus ij fy[ks gq, gksrs gSaA

©       Delete (insert es):-- Delete ds ikl rhj ds fu'kku ij Dyhd djus ls 1.Delete cell:- bl ij Dyhd djus ls cell Delete gks tk,xkA

©      2. Delete sheet Rows:- Row dks lysDV djus ds ckn Delete sheet Rows ij Dyhd djus ls sheet dk Row Delete gks tk,xkA

©      3. Delete sheet column :-- column dks lysDV djus ds ckn Delete sheet column ij Dyhd djus ls sheet dk column Delete gks tk,xkA  

©      4. Delete sheet :- sheet dks lysDV djus ds ckn Delete sheet ij Dyhd djus ls sheet Delete gks tk,xhA

©      Insert es cell styles :- 1. Normal – lk/kkj.k] 2. Total ij Dyhd djus ls la[;k ds fups v.MjykbZu 'kks djsxhA cell styles es vyx&vyx cell dh fMtkbZu ns ldrs gSaA

©      Insert es Forment as Table :- Forment as Table es cell dh vyx&vyx dyj dh fMtkbZu ns ldrs gSaA

     Forment (insert es):-- cell size –

©      Row Height :- Row dks lysDV djus ds ckn Row Height ij Dyhd djus ls NksVk ckWDl vksiu gksxkA ckWDl es Row Height ds vkxs column es NksVh la[;k fy[kdj ok djus ls Row ds chp dk xsi de gks tk,xkA o cM+h la[;k fy[kdj ok djus ls  Row ds chp dk xsi cM+k ¼T;knk½ gks tk,xkA

©      Column width :-- column dks lysDV djus ds ckn Column width ij Dyhd djus ls NksVk ckWDl vksiu gksxkA ckWDl es Column width ds vkxs column ess NksVh la[;k fy[kdj ok djus ls column ds chp dk xsi de gks tk,xkA o cM+h la[;k fy[kdj ok djus ls column ds chp dk xsi cM+k ¼T;knk½ gks tk,xkA

©      Excel es lHkh Row dh Height ,d tSlh djus dk rjhdk%& odZ'khV dks lysDV djus ds ckn ekml dk jkbZV cVu Dyhd djus ls Row Height vksilu vksiu gksxkA Row Height ij Dyhd djus ls ,d NksVk ckWDl vksiu gksxkA ckWDl es 5 la[;k fy[kdj ok djus ls lHkh Row dh Height ,d tSlh gks tk,xhA

©      ,d odZ'khV es dqy fdrus Row o column dk irk yxkus dk rjhdk%& odZ'khV ds ,d Row ;k ,d column dks lysDV djus ds ckn ctrl+shift nckdj key cksMZ dk Lisl nckus ls Row o column dh la[;k Åij 'kks djsxhA

©      Excel es fy[kus ds ckn Data ij Dyhd djus ds ckn Filter ij Dyhd djus ls excel QkbZy es A B C D E  ds dkWye es fups dh rjQ rhj dk fu'kku vksiu gksxsaA Excel es fy[ks gq, dkWye ds fups [kkyh dkWye es Dyhd djus ds ckn lq=& =(E10 ) ;k dksbZ Hkh =(f2) fy[kdj Enter nckus ls lq= gV tk,xk vkSj uke ;k la[;k vksiu gks tk,xkA uke fy[ks gq, dkWye es rhj ds fu'kku ij Dyhd djus ls pkVZ vksiu gksxkA text filters ds fups Anil ds vkxs lgh dk fu'kku jgus nsosaA ckdh lHkh uke ds vkxs Dyhd djds lgh dk fu'kku gVkus ds ckn ok djus lsa anil uke excel QkbZy es vksiu gks tk,xkA ckdh ds uke gV tk,xsaA vkSj select all ij Dyhd djus ds ckn ok djus ij lHkh uke okil vk tk,xsaA

©    Sort filter :- (Home es) excel es dkWye es name,categari, class oxSjk fy[kdj lysDV  djus ds ckn home es sort filter ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es filter vksilu ij ij Dyhd djus ls a,b,c,d ds fups dkWye es rhj dk fu'kku vksiu gksxkA tSls & categari ds dkWye es rhj ds fu'kku ij Dyhd djus ij pkVZ vksiu gksxkA pkVZ es text filter ds fups select all ds vkxs Dyhd djds lgh dk fu'kku gVkus ds ckn OBC, SC, GEN  dksbZ ,d ds vkxs Dyhd dj lgh dk fu'kku vkus ds ckn ok djus ij categari oxSjk dh fyLV vksiu gks tk,xhA

©    Filter :- fdlh dEI;qVj es c³s vkd³ks esa ls mi;ksxh vkd³s NkVaus dks fQYVj dgrs gSaA mi;ksxh vkd³ks dk vklkuh ls vyx dj ldrs gSaA

©    eYVh vkWVks Filter iz;ksx djuk %& ftu & ftu QhYMks ds fy, create la[;k fu/kkZfjr djuk pkgrs gSa mudh Mªki Mkmu fyLV ls Filter pqus] Excel dsoy mrus gh fjdkMZ vksiu djsxk] tks bu QhYMks esa eSp ¼ekStwn gSa½ djrs gSaA

©    Auto filter ls fjdkWMZ NkaVuk %& Excel dh odZ’khV esa ftl dkWyeks es Auto filter yxkdj fjdkWMZ dks NkaVuk pkgrs gSa] ml dkWye ds Åij ds lsy dks lysDV djsa] ’ Home ehuw ij Dyhd djs] ’ sort filter dekUM ij Dyhd djus ij bldk mi & ehuw vksiu gksxk] mlesa ls Auto Filter dekUM ij Dyhd djsA Excel MsVk dks LØsu djsxk vkSj gj QhYM ds vkxs Mªki Mkmu fyLV vksiu gksxhA ’ 1- lHkh fjdkWMZ esa ls ,d fjdkWMZ dks vksiu djus ds fy;s MsVk fQYVj esa Mªki Mkmu fyLV esa show all uked fodYi ij Dyhd djds P lgh dk fpUg gVk,a ’ izR;sd dkWye esa ls ,d create ,jh;k dks pqus ’ ok cVu ij Dyhd djsa] ’ tks fjdkWMZ lysDV fd, gq, create ,jh;k dh 'krksZ dks iqjk djds ] dsoy os gh fjdkWMZ vksiu gksxkA

©    Top 10 Auto Filter iz;ksx djuk %& ftl QhYM esa ls 10 vkbVEl ns[kuk pkgrs gSa ml QhYM es Åij dk lsy esa Dyhd djds lysDV djsa]’ Home ehuw ij Dyhd djsa ’ sort filter ij Dyhd djus ls mi & ehuw Auto Filter vksiu gksxk] ’ Auto Filter ij Dyhd djus ls fQYVj yx tk;sxkA QhYM Mªki Mkmu ij Dyhd djsa ’Number Filters dekUM ij ekml IokbaVj ys tkus ij Top 10 fodYi ij Dyhd djus ls QhYM esa ls 10 vkbVEl LØhu ij [kqydj lkeus vk tk;sxsaa

©    Custom Filter  lsV djuk :- ftl QhYM ds fy;s Create ,jh;k fuf’pr djuk pkgrs gSa] mlds fy;s Auto filter dh Mªki Mkmu fpUg ij Dyhd djs ls Text Filter uke dk fodYi vksiu gksxkA Text Filter ij ekml IokbaVj dks ys tkus ij lwfp esa custom Filter vksiu gksxkA custom Filter ij Dyhd djus ls custom Auto Filter uke dk ckWDl vksiu gksxkA ckWDl esa Mªki Mkmu fyLV esa ls ,d ;k nks rqyukRed okys vksilu ij Dyhd djds lysDV djs] ckWDl es and ;k or vksilu  esa ls ,d ij Dyhd djsaA " rkfd Excel dks irk pys fd bu nksuks create ,jh;k esa eSp gksus okys fjdkWMZ <+q<us gSaA ok cVu ij Dyhd djus ls] tks lysDV ,jh;ka esa fuf’pr fd;k gSa] mlesa eSp gksus okys lHkh fjdkWMZ dks LØhu ij [kqydj lkeus vk tk;sxkA

ü Custom Filter  %& Excel dh QkbZy esa lwpukvksa dh vyx&vyx NaVuh djus ds fy, bl vksilu dk use djrs gSaA

ü Filter :- Filter ges'kk Heading Row esa gh yxrk gSaA

ü Filter yxkus dk rjhdk %& Heading Row dks lysDV djds Home ehuw esa sortand filter option ls Filter ij Dyhd djsaA

©    Excel sheet es Number Filter djuk %& Excel dh odZ’khV dks [kksys " la[;k esa MkVk ,UVj djs] " MkVk ,UVj fd;s gq, dh gSfMUx dks lysDV djs] " Home ehuw esa  Sort & Fiter  fodYi ij Dyhd djs] " Filter fodYi LØhu ij iznf’kZr gksxkA Filter fodYi dk p;u djsA " Åij dh gSfMUx ij Filter yx tk;sxkA " ftl Column esa Number  Filter djuk gks ml Column esa yxs gq, QhYVj vkbdu ij Dyhd djs] " fodYi LØhu ij iznf’kZr gksxk " Number Filter ij ekml IokbaVj dks ys tkus ij Equals, Less than, Grester then oxSjk fodYi LØhu ij iznf’kZr gksxs] " mlesa vko’;drkuwlkj fodYi dk p;u djs " Column esa tSls & 25 la[;k VkbZ djs] " ok cVu ij dyhd djsA 25 la[;k gSa rks [kqydj LØhu ij iznf’kZr gks tk;sxhA

©  Costom filter(Excel es) yxkuk%&

ü Equals(cjkcj) :- Filter yxkus ds ckn]  Filter ds rhj ds fu'kku ij Dyhd djus ls number filter ds rhj ds fu'kku ij Dyhd djus ls Equals vksilu vksiu gksxkA Equals ij Dyhd djus ls ,d Mk;ykWx ckWDl LØhu ij iznf’kZr gksxkA Mk;ykWx ckWDl esa Åij ds column es tks la[;k 25 fy[kksxsa oks la[;k vksiu gks tk,xhA tSls & 25

ü Less Than(NksVk) :- number filter ds rhj ds fu'kku ij Dyhd djus ls Less Than ,d Mk;ykWx ckWDl LØhu ij iznf’kZr gksxkA Less Than ij Dyhd djus ls Mk;ykWx ckWDl vksiu gksxkA pkVZ es tks la[;k Mkyksxs mlls tks de la[;k gksxh oks vksiu gks tk,xhA

ü Less Than or Equal to :- bles Åij ds column es la[;k 85 fy[kdj o fups ds column es 39 es fy[kdj ok djus ls fcp nksuks ds fcp dh la[;k vksiu gks tk,xhA

ü Greater Than(cM+k) :-  Greater Than ij Dyhd djus ls pkVZ vksiu gksxkA pkVZ es Åij ds column es la[;k 80 fy[kdj ok djus ls 80 ds Åij dh la[;k vksiu gksxhA

ü Greater Than(cM+k) or Equal(cjkcj) to :- Greater Than or Equal to ij Dyhd djus ls 80 ls 100 ds fcp dh la[;k vksiu gksxhA

ü = , Equal to –cjkcj]

©       Excel es costam Filter :- costam Filter es la[;k 100 ls 50 ds fcp dh la[;k fudkyus dk rjhdk%& Excel dh odZ'khV es Filter yxkus ds ckn ftl dkWye dk costam Filter es la[;k 100 ls 50 ds fcp dh la[;k fudkyuh gks Filter  ds fu'kku ij Dyhd→ Number Filters ij Dyhd → Less Tham ij Dyhd → Åij ds dkWye es Less Tham (ls de) ds vkxs la[;k 100 fy[kdj] fups okys dkWye es rhj ds fu'kku ij Dyhd dj is Greater than(ls T;knk) dks lysDV ij la[;k 50 fy[kdj ok djus ls 100 ls 50 ds fcp dh la[;k vksiu gks tk,xhA 2. Less Tham ij Dyhd → Åij ds dkWye es Less Tham (ls de) ds vkxs la[;k 100 fy[kdj] fups okys dkWye es rhj ds fu'kku ij Dyhd dj is Greater than or equel(cjkcj) dks lysDV ij la[;k 50 fy[kdj ok djus ls 100 ls 50 ds fcp dh la[;k vksiu gks tk,xhA

©       Rename sheet (format es) :- bl ij Dyhd djds sheet dk uke cny ldrs gSaA

©      Tab color :- sheet dk uke gSa mldk uke dyj es nsukA

©      Excel  odZ'khV es Row dh gkbZV ,d leku djuk %& odZ'khV dks lysDV djus ds ckn Home→ Format→ Auto Fit Row Hight ij Dyhd djus ls Excel  odZ'khV es Row dh gkbZV ,d leku gks tk,xhA

©       Excel  odZ'khV es column dh ds fcp dk xsi ,d leku djuk %& odZ'khV dks lysDV djus ds ckn Home→ Format→ Auto Fit column width ij Dyhd djus ls Excel  odZ'khV es column dh ds fcp dk xsi ,d leku gks tk,xhA

©      Time dh formatting change djuk %& Home es Dyhd & formant cells  ij Dyhd ª Time Dyhd djuk ª type ds fups le; ds vkxs am &pm fy[ks gq, ij Dyhd dj ok djus ls le; dh formatting  change gks tk,xhA tSls %& 23-30 dh txg 11-30pm gks tk,xkA

©      Number dh formatting change djuk %& Home es Dyhd & formant cells  ij Dyhdª Numbar Dyhd djuk ª ckWDl es la[;k 0 fy[kdj ok djus ls formatting change gks tk,xhA

©       izfr’kr fudkyus ds ckn fcUnq ds vkxs nks ls T;knk la[;k vk tkrh gSa A tSls& 63.33333 ª fcUnq ds vkxs nks l[;k j[kus ds fy, %& izfr’kr okys vadks dks lysDV djus ds ckn Home ij Dyhd ª formant cells  ij Dyhd djus ls  ,d pkVZ  vksiu gksxk ª pkVZ es Numbar vksilu ij Dyhd djus ds ckn vksilu ª la[;k 1234.10 ij Dyhd dj ok djus ls fcUnq ds ckn nks la[;k gh jgsxhA tSls& 63.33

©       fcUnq ds vkxs nks l[;k j[kus ds fy, %& Home ij Dyhd ª formant cells  ij Dyhd djus ls ckWDl vksiu gksxk ª ckWDl es Numbar ij Dyhd ª Decimal places ds Next dkWye es la[;k 2 fy[kdj ok djus ls] ’ tSls 63.33333 dh txg 63.33 la[;k 'kks djsxhA

©       izfr'kr fudyus ds ckn la[;k & tSls 63.33333  vk tkrh gSaA 63 n'keyo ds Next l[;k dks gVkus ds fy, ’ Home ij Dyhd ª formant cells  ij Dyhd djus ls ckWDl vksiu gksxk ª ckWDl es Numbar ij Dyhd ª Decimal places ds Next dkWye es 0 fy[kdj ok djus ls ª n'keyo ds ckn dh la[;k 50 ls de gksxh tSls 63.33333 gksxh ª rks la[;k & 63 gh jgsxhA o n'keyo ds ckn dh la[;k 50 ls T;knk gksxh tSls 63.33333 gksxh ª rks la[;k & 64 gks tk,xhA

©       Fill (fy[kuk ;k tks³uk):- Excel – Fill ds ikl rhjds fu'kku ij Dyhd djus ij Down, Right,Up, Left, and Series vksilu vksiu gksxsaA

©       Down(fups dh rjQ)('kksVZdV-ctrl+D) :- odZ'khV ds cell es eSVj ;k la[;k fy[kdj column es fups dh cell dksa lysDV dj Down ij Dyhd djus ls odZ'khV ds cell es fy[kk eSVj ;k la[;k save gks tk,xkA

©       Right ('kksVZdV-ctrl+R):- odZ'khV ds cell es eSVj ;k la[;k fy[kdj nkfgus dh rjQ cell dks lysDV dj Right ij Dyhd djus ls odZ'khV ds cell es fy[kk eSVj ;k la[;k save gks tk,xkA

©       UP :- odZ'khV ds cell es eSVj ;k la[;k fy[kdj column es Åij dh cell dksa lysDV dj up ij Dyhd djus ls odZ'khV ds cell es fy[kk eSVj ;k la[;k save gks tk,xkA

©       Left :- odZ'khV ds cell es eSVj ;k la[;k fy[kdj ck;sa dh rjQ cell dks lysDV dj Left ij Dyhd djus ls odZ'khV ds cell es fy[kk eSVj ;k la[;k save gks tk,xkA

©       Series :- odZ'khV ds cell es la[;k 3 fy[kdj o fups okys cell es 6 fy[kdj fups dh rjQ column ds cell dks lysDV dj Series ij Dyhd djus ls la[;k tSls& 3]6]9]12 save gks tk,xhA

©       Clear (gVkuk):-  Clear ds rhj ds fu'kku ij Dyhd djus ls Clear All, Clear Formats, Clear contents, Clear Comments vksilu vksiu gksxsaA

©       Clear All :- odZ'khV dks lysDV dj Clear All ij Dyhd djus ls odZ'khV dk eSVj lHkh gV tk,xkA vFkkZr Delete gks tk,xkA

©  Clear :-- Excel sheet dks lysDV djus ds ckn Clear ij Dyhd ClearAll ij Dyhd djus ls sheet es fy[kk eSVj gV¼Delete½ tk,xkA

©       Clear Formats :- odZ'khV es lysDV dj cSd xzkm.M dyj nsus ds ckn okil gVkus ds fy, Clear Formats vksilu ij Dyhd djus ls dsoy cSd xzkm.M dyj gh gVsxkA eSVj ugh gVsxkA

©       Clear contents :- odZ'khV fy[ks eSVj dks lysDV dj Clear contents ij Dyhd djus ls lysDV fd;k eSVj gV tk,xkA

©       Clear Comments :- odZ'khV es insert Comments dks okil gVkus ds fy, Comments okys cell es dlZj ls Dyhd dj Clear Comments vksilu ij Dyhd djus ls insert Comments okil gV tk,xkA

©       Formulas - yxk gqvk ,jh;k dks lysDV djuk (Find & select) :- Find & select ds ikl ,jks fpUg ij Dyhd djus ls Formulas vksilu vksiu gksxkA Formulas ij Dyhd djus ls sheet ds vUnj Formulas yxk gqvk ,jh;k lysDV gks tk,xkA

©       Highlight Cells Rules-Conditional Formatting(Homees) :- Conditional Formatting ds ikl rhj ds fu'kku ij Dyhd djus ls Highlight Cells Rules vksilu vksiu gksxkA Highlight Cells Rules ij Dyhd djus ls Greater Than(50 ls] tkss la[;k fy[kksxs mlls T;knk dk ,d dyj gks tk,xk), Less Than(90ls, tkss la[;k fy[kksxs mlls tks de la[;k gksxh mldk  dk ,d dyj gks tk,xk), Between(40-150 ds fcp] nksuks ds fcp dh tks la[;k gksxh ml la[;k dk ,d dyj gks tk,xk), Equal( cjkcj] tks la[;k 60 fy[kksxs] 60 la[;k ftruh gksxh ml la[;k dk ,d dyj gks tk,xk),Taxt that contains ( tks uke oxSjk fy[kk gks mldk dyj djuk] la[;k dk dyj ugh gksxk),

©       icons sets — Conditional Formatting(Homees):-  odZ'khV ds vUnj cell es la[;k fy[kdj mlds ikl Bullets fpUg nsuk dk rjhdk%& odZ'khV ds cell es la[;k fy[kdj] ls[;k dks lysDV dj  icons sets ij Dyhd djus ls fpUg vksiu gksxsaA mles vko';dekuwlkj Bullets fpUg  ns ldrs gSaA o okil gVkus ds fy, Clear — Clear Formats ij Dyhd djus ls Bullets fpUg   gV tk,xsA

©       Color scales(Conditional Formatting(Homees):-- odZ'khV ds vUnj cell es la[;k fy[kdj] lysDV dj Color scales ij Dyhd dj] More Rules ij Dyhd dj] pkVZ es color ds rhj ds fu'kku ij Dyhd dj vko';dekuwlkj dyj ns ldrs gSaaA

©       Conditional Formatting (Home es) }kjk fn;k x;k dyj dks gVkuk %& Excel dh odZ'khV dks lysDV djus ds ckn Home es Conditional Formatting  ds ikl rhj ds fu'kku ij Dyhd → Cear Ruler ij Dyhd → Cear Rules From Entire sheet ij Dyhd ls Conditional Formatting }kjk fn;k x;k dyj iqjh odZ'khV dk  gV tk,xkA Cear Rules From selected cells ij Dyhd djus ls lysDV fd;k gq, cells dk dyj gV tk,xkA 2. nqljk rjhdk%& ftl es dk dyj gVkuk gks mls lysDV djus ds ckn Clear ds ikl rhj ds fu'kku ij Dyhd djus ij Clear Formats ij Dyhd djus ls dyj gV tk,xkA

©       show / Hide comment :- comment dks 'kks djuk ;k pqikukA

©       icon Sets - (Conditional Formatting(Homees):-- Excel dh odZ'khV es la[;k fy[kh gqbZ gks ml cells dks lysDV djus ds ckn icon Sets  ij Dyhd djus ls Bullet fpUg vksiu gksxsA vko';drkuwlkj fpUg dks la[;k ds ikl Bullet fpUg ns ldrs gSaA okil gVkus ds fy, & clear Formats ij dyhd djus ls Bullet fpUg gV tk,xsaA

©       Top/Bottom Rules-(Conditional Formatting(Homees):- odZ'khV es fy[ks eSVj dks lysDV cells ds Top (Åij dh rjQ) dyj nsuk%& Top/Bottom Rules ij Dyhd ªTop 10 items ij Dyhd djus ls lysDV cells ds Top (Åij dh rjQ) dyj gks tk,xkA

©       Bottom 10 items:- odZ'khV es fy[ks eSVj dks lysDV cells ds Bottom (fups dh rjQ) dyj nsuk%& Top/Bottom Rules ij Dyhd ª Bottom 10 items Dyhd djus ls lysDV cells ds fups dh rjQ dyj gks tk,xkA

©       Row o column dh la[;k ns[kus ds fy, %& ,d Row o ,d columndks lysDV djus ds ckn ctrl+shift nckdj Lis'k ;k ,jks dh nckus ls Åij cell Address es 'kks djsxkA

©       Find o Replace dk pkVZ ykus ds fy, %& shift+F5 nckus lsA

©       Excel es dke dj jgs gks] djsD'ku djrs le; Dyhd dj Backspace nckus ij column es lHkh 'kCn gV tkrs gSa] column es ,d 'kCn dk djsD'ku djuk gSa ckdh ds 'kCn gVus ugh pkfg,] Excel es dke dj jgs gks] column es ,d 'kCn dk djsD'ku djuk gSa rks] column es dlZj ls Dyhd djus ds ckn] QDlu key dk F2 nckdj ;k MCcy Dyhd djus ls tgka djsD'ku djuk gSa ogka column es dlZj ls Dyhd dj ;k ,jks key ls vkxs&fiNs tkdj djsD'ku dj ldrs gSaA

©  M.s word dk MkVk dks ,Dlsy es ¼Date interchange with M.S Excel½ M.S Excel open djds insert Menu ckWDl ls create from file Tab ls Browse cVu }kjk Qkby lysDV djds ok cVu ij Dyhd djus ij M.S word dh Qkby dk MkVk M.S Excel es yk;k tk ldrk gSaA

©      Work book :- M.S Excel es ftl QkbZy ij dk;Z fd;k tkrk gSaA ,oa MkVk LVksj fd;k tkrk gSaA mls Work book dgrs gSaA ,d odZcqd es dbZ odZ'khV gksrh gSaA sheet 1, sheet 2, sheet 3 …(sheet Tab dgrs gSa)ds uke ls LØhu dh fupyh Hkkx (status bar) ij fLFkr gksrh gSaA Strikethrough(Excel es) ('kCnks ds Åij fcp es ykbZu ¼dV yxkuk½) & ctrl+5 flEcksy key nckus lsA

©      Workbook :- M.S Excel es ftl QkbZy ij dk;Z fd;k tkrk gSa ,oa MkVk LVksj fd;k tkrk gSa mls odZcqd dgrs gSaA ,d odZcqd es rhu worksheet cuh gqbZ vkrh gSa tks status bar ij sheet1, sheet2, sheet3 'kks djrh gSaA og vksj Hkh worksheet tks³h tk ldrh gSaA o Delete Hkh dh tk ldrh gSaaA

©      sheet1, sheet2, sheet3 bls sheet Tab dgrs gSaA

©      Row Heading :- worksheet es izR;sd Row ds ck;sa rjQ uECkj Åij ls fups dh vksj 1]2]3]3 oxSjk dks Row Heading dgrs gSaA

©      Fist cell ls Last cell es tkus ds fy, & ctrl+ ,jks key nckus lsA

©      Excel es minimaze djus ds fy, & ctrl+F9 nckus lsA

©      Excel es maximize djus ds fy, & ctrl+F10 nckus lsA

©      Chart cukus ds fy, & F11 dks nckus ls xzkQ 'kks djsxkA

©      out luck :--internet ls vkus o tkus okys Email Out Luck es Add djus ij save box es lqj{hr jgrs gSaA

©      izfr'kr dk fpUg ugh vkrk gks rks Forment cell ckWDl es izfr'kr ij Dyhd djus ds ckn ok ij Dyhd djus ls % dk fpUg vk tk,xkA

©      Excel odZ’khV dk fizUV fudkyuk %& Excel odZ’khV dks vksiu djus ds ckn fizUV dek.M ij Dyhd djs] fizUV uke dk Mk;ykWx ckWDl LØhu ij [kqydj lkeus vk tk;sxkA fizUV ckWDl esa fizUVj dks lysDV djuk] isij dks lysDV djuk] fizUV jsUt] izfr;kW dh la[;k dks lsV djds fizfUVx fudky ldrs gSaA odZ’khV dSlh fizUV gksxh] blds fy, fizUV fudkyus ls igys fizUV fizO;w dek.M ds }kjk odZ’khV dks ns[k ysuk pkfg,

©      fizUVj dh properties dks lsV djus ds fy,] properties uked cVu ij Dyhd djsA fizUV uked dek.M ij Dyhd djus ls odZ’khV foUMkst esa bLVkWy vkSj fMQkWYV lsV djds fizUVj ds }kjk rsth ls fizUV fudky ldrs gSaA

©      Excel es print preview ns[kus ds ckn Margin lsV djus dk rjhdk :- show – Margin ds vkxs pkSdM+h es Dyhd djus ls lgh dk fu'kku vkus ls ist ij vkbZdu 'kks djus ls dlZj ls idM+dj Margin dks lsV dj ldrs gSaA

©      Excel es print preview ns[kus ds ckn print Hkh fudky ldrs gSaA

©      Excel es print preview ns[kus ds ckn page setup dj ldrs gSaA

©      Excel es print preview ns[kus ds ckn ist dks Zoom Hkh dj ldrs gSaA

©      Excel dh odZ’khV esa fy[ks x;s eSVj dks ,d lkFk lysDV djuk %& odZ’khV ds fy[ks x;s eSVj ds ,jh;k esa dgh Hkh dlZj ls Dyhd djus ds ckn ctrl+ A nckus ls odZ’khV esa fy[kk x;k eSVj ,d lkFk lysDV gks tk,xkA Ž ;fn fy[ks x;s eSVj ds ,jh;k ls dlZj ckgj Dyhd fd;k gqvk gS rks iqjh odZ’khV ,d lkFk lysDV gks tk,xhA

©      Excel esa fizUVhUx djuk %& office Button esa print uked dek.M ij ekml Iokbavj ys tkus ij fizUV lEcU/k esa rhu fodYi LØhu ij [kqydj lkeus vk tk;sxsaA

ü Print :-  fizUV dek.M ij Dyhd djus ls] print dk MkW;ykx ckWDl LØhu ij [kqydj lkeus vk tk;sxkA ftlls fizUVj] isij lkbZt] fizUV jsUt] izfr;ksa dh la[;k] bR;kfn dks lsV djds fizUVhUx dj ldrs gSaA

ü Print preview :- odZ’khV dSlh fizUV gksxh] fizUV fudkyus ls igys Print preview ns[k ysuk pksfg;sA Print preview ns[kus ds fy;s] Print preview dek.M ij Dyhd djsaA

ü Properties :-  fizUVj dh Properties lsV djus ds fy;s] Properties uked dek.M ij Dyhd djsaA  

ü Quick print :- Quick print uked dek.M ij Dyhd djus ls odZ’khV foUMkst esa bLVkWy vkSj fMQkYV lsV fizUVj }kjk rsth ls fizUV gks tk;sxhA