Excel View and ReView

View- ehuw

©      Normal :- Page Break preview ns[kus ds ckn okil odZ'khV ykus ds fy, Normal ij Dyhd djus iqjh odZ'khV vksiu gksxhA

©      Page Layout :- odZ'khV es izR;sd ist ij Header o Footer es gSfMax ¼uke½ nsus ds fy, Page Layout ij Dyhd djus ds ckn izR;sd ist vyx&vyx 'kkss djsxsaA ist ds Åij click to add Header o click to add Footer ij Dyhd dj uke ;k dksbZ Hkh gSafMx fy[k ldrs gSaA Normal ij Dyhd djus ls odZ'khV lk/kj.k gks tk,xhA

©      Page Break preview :- odZ'khV es MkVk ¼eSVj½ fy[kus ds ckn Page Break preview vksilu ij Dyhd djus ls odZ'khV es tks dk;Z fd;k gSa oks ist vyx& vyx ist o ist la[;k 'kks djsxkA ckdh dh ist ugh fn[ksxsaA

©      Custom views :- odZ'khV es ftl ist ij tkuk gks] rks Custom views ij Dyhd djus ls ckWDl vksiu gksxkA ckWDl es add ij Dyhd djus ls ,d vksj ckWDl vksiu gksxkA dksbZ Hkh uke ;k key nckdj ok djus ls uke add gks tk,xkA izR;sd ist ds uke ns ldrs gSaaA ckn uke ij Dyhd o show ij Dyhd djus ls dlZj ml ist ij pyk tk,xkA

©      Full screen :- Full screen ij Dyhd djus ls odZ'khV dh lkbZt iqjs DeskTop Qqy gks tk,xhA

©      Farmula bar (viewes):- Excel es farmula iVVh ij ykus dk rjhdk%& view ij Dyhd & farmula bar vksilu ds vkxs Dyhd dj lgh dk fu'kku vkus ls farmula iVVh ij vk tk,xkA Farmula bar ds vkxs Dyhd dj lgh dk fu'kku gVkus ls  farmula iVVh ugh vk,xkA

©      Excel es view ds vUnj Hide(pqikuk)  ij Dyhd djus ls Excel sheet es fy[kk eSVj pqi tk,xkA o Unhide ij Dyhd djus ls okil Excel sheet vksiu gks tk,xhA

©      Visibility es hide(pqikuk) & UnHide (pqis gq, dks vksiu djuk) :- Hide Row – Row dks lysDV djus ds ckn Hide Row ij Dyhd djus ls Row pqi ¼?kk;c gks½ tk,xkA Un Hide Row ij Dyhd djus ls pqik gqvk Row okil vksiu gks tk,xkA

©      Hide column :- column dksa lysDV djus ds ckn Hide column ij Dyhd djus ls column pqi ¼?kk;c gks½ tk,xkA Un Hide column ij Dyhd djus ls pqik gqvk column okil vksiu gks tk,xkA

©      Hide sheet :-- sheet dks lysDV djus ds ckn Hide sheet ij Dyhd djus ls sheet pqi ¼?kk;c gks½ tk,xhA Un Hide sheet ij Dyhd djus ls ,d NksVk ckWDl vksiu gksxkA ckWDl es sheet Dyhd dj ok djus ls okil vksiu gks tk,xhA

©      Farmula bar (viewes):- Excel es farmula iVVh ij ykus dk rjhdk%& view ij Dyhd & farmula bar vksilu ds vkxs Dyhd dj lgh dk fu'kku vkus ls farmula iVVh ij vk tk,xkA Farmula bar ds vkxs Dyhd dj lgh dk fu'kku gVkus ls  farmula iVVh ugh vk,xkA

©      Freeze panes  (view es):-  Excel es coulamn o Row dh Åij dh gSafMx LFkkbZ djus dk rjhdk %& Excel ds coulamn o Row es Åij dh gSafMx fy[kdj ] gSafMx ds vafre ds fups Dyhd djus ds ckn view es Freeze panes vksilu ij Dyhd djus ij] Freeze panes vksilu ij Dyhd djus ls Åij dh gSafMx LFkkbZ gks tk,xhA Unfreeze panes vksilu ij Dyhd djus ls LFkkbZ dh gqbZgSafMxgV tk,xhA                                                                                           

©      Protect sheet :- work sheet es dk;Z djus ds ckn Protect sheet Dyhd djus ls Protect sheet uke dk ckWDl vksiu gksxkA ckWDl es Protect worksheet and contents oF locked cells ij Dyhd dj lgh dk fu'kku vkus ds ckn] select locked cells, select unlocked cells, Foemat cells, Format column, Format Rows, bu ij Dyhd dj lgh dk fu'kku vkus ds ckn ok djuk ls worksheet ykWd gks tk,xhA worksheet ykWd gks tkus ds ckn mles fy[k ugh ldrs gSaA fy[kus ds fy, view es UnProtect sheet vksilu ij Dyhd djus ls worksheet dk ykWd [kqy tk,xkA worksheet ykWd gksus ij view es Protect sheet dh txg UnProtect sheet vksilu 'kks djsxkA

Review

©       Excel – New Comment(Review es):- odZ'khV es tgka dlZj gSa New Comment ij Dyhd djus ls ml cell es New Comment, insert gks tk,xkA

©       New Comment, insert gks tkus ls New Comment dh txg Edit Comment 'kks djsxkA Edit Comment ij Dyhd dj Comment ds vUnj eSVj dks fy[k ldrs gSaA o gVk Hkh ldrs gSaA

©       Delete :- Comment dks okil gVkus ds fy, Comment okys cell es dlZj ls Dyhd dj Delete ij Dyhd djus ls Comment gV tk,xkA

©       odZ'khV esa T;knk Comment, insert gSa rks previous o next vksilu dks iz;ksx es fy;k tkrk gSaaA

©       show all comments:- odZ'khV esa Comment, insert gSa ml cell es dlZj lsa Dyhd dj show all comments ij Dyhd djus ls comments vksiu gks tk,xkA mles eSVj fy[k Hkh ldrs gSaA o gVk Hkh ldrs gSaA

©       Protect sheet :- Excel sheet es eupkgs lysDV cells dks ykWd djuk %& sheet es [kkyh txg ¼odZ ,jh;k ls ckgj½ dlZj ls Dyhd djs]’ ctrl+A nckdj] All select djs] ’ ctrl+! key nck;s] ;k ekml dk jkbZV cVu Dyhd djus ls Format cells (Home es) uked fodYi ij Dyhd djus ij LØhu ij ckWDl vksiu gksxkA ’ Format cells ckWDl esa Protection uked fodYi ij Dyhd djsa] Locked uked fodYi ij dlZj ls Dyhd dj P dk fpUg gVk;s] vkSj ok cVu ij Dyhd djsaA ’ ckn sheet esa ftl cells, Column, Row ,jh;k dks ykWd djuk gSa] ml cell, column, Row dks lysDV djs] " ekml dk ys¶V cVu nckdj] [khapdj eupkgs cells dks  lysDV djsa] ’ fQj nwckjk ctrl+! key nck;s] ;k ekml dk jkbZV cVu Dyhd djus ls Format cells uked fodYi ij Dyhd djus ij LØhu ij ckWDl vksiu gksxkA ’ Format cells ckWDl esa protection uked fodYi ij Dyhd djsa] Locked uked fodYi ij dlZj ls Dyhd djus ij Pdk fpUg vkbdu 'kks djsxk] "  ckn] ok cVu ij Dyhd djsaA ’ Review ehuw ij Dyhd djsa]’ protect sheet uked fodYi ij Dyhd djus ij ckWDl vksiu gksxkA ’ protect sheet uked ckWDl es] password to protect sheet ds uhps foUMks esa vius eupkgs password Mkydj ok cVu ij Dyhd djsaA ’ confirm password ckWDl es nwckjk ikloMZ ok cVu ij Dyhd djus ls] lysDV fd;s x;s cells ykWd gks tk,xkA