Excel me Select Cell Cock And Protect sheet

Excel me Select Cell Cock   And   Protect sheet  

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 VSc dk p;u 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,xk

Protect sheet (Review esa ) :- Excel dh odZ'khV dks Protect ¼ykWd½  djus ij i<+ ldrs gSaA Text VkbZi ugh dj ldrs gSaA Protect sheet djus dh fof/k & ftl odZ'khV dks ykWd djuk gSa mls [kksys] Review ehuw ij Dyhd djs] Protect sheet ds vkbdu ij Dyhd djus ij Protect sheet uke dk ,d Mk;ykWx ckWDl iznf'kZr gksxkA ckWDl esa viuh ethZ ls password VkbZi djsA ok cVu ij Dyhd djsA ConFirm Password uke dk Mk;ykWx ckWDl iznf'kZr gksxkA ckWDl esa lse ikloMZ VkbZi djs] vUr esa ok cVu ij Dyhd djsA Excel dh odZ'khV ds ikloMZ yxk nsus ds ckn Ctrl+S key dks nckdj Save djsA ,d ckj Qkby dks cUn djsA mlh Qkby dks okil open djus ij Qkby [kqy tk,xh] exj mles VkbZi ugh dj ldrs gSaA flQZ ns[k ldrs gSaA i<+ ldrs gSA