`mKw 4

Fw.F-kv. FIvk þ

AXn-hn-]p-e-amb

IW-¡p-]p-kvXIw

l k¦oÀ®KWnX§Ä sRmSnbnSbn \S¯mw l

l hÀ¡v_p¡v, hÀ¡vjoäv, skÃpIÄ l

l IWs¡gp¯n\v Ffp¸hgnIÄ l

l hÀ¡v_p¡n\v tamSntbImw l

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

]pXnb t{]m{KmamWv ]Tn¡m³ t]mIp¶Xv F¶Xnsâ {XnÃnembncp¶p cXojpw kp\nXbpw. AXn\m Xs¶ km[mcW ImÀ¯nI hcp¶Xn\v ap¼mbpÅ Iw]yq «À the¯c§Äs¡m¶pw AhÀ apXnÀ¶ncp¶nÃ. ImÀ¯nI hcpt¼mÄ Iw]yq «dpw {]nâdpsams¡ "HmWm'¡n, kvIqÄ hntijhpw ]dªncn¡pIbmbncp¶p Ccphcpw. "F´m, C¶v IgpXbpw hnUvVnbpw CSnbpw sXmgnbpsam¶panÃmsX \à Ip«n Ifmbncn¡p¶Xv?' IS¶]mtS ImÀ¯nI tNmZn¨p. "Hm, H¶panÃ,' kp\nX ]dªp. "R§Ä Asænepw \à Iq«pImctÃ?' "Ipd¨p kwkmcw, IqSpX A²zm\w', cXojv CSbv¡v Ibdn. "C¶v ]pXnb t{]m{KmatÃ?' "h¶ph¶v ]nÅmcnt¸mÄ Iev]n¡m\pw XpS§n,' ImÀ¯nI ]cn`hw t]mse ]dªp. "cmhnse apX sshIpt¶cw hsc Hm^okn t{]m{Kmw FgpXÂ, kÔy Ignªm ho«n t{]m{Kmw ]Tn¸n¡Â. Fsâsbmcp hn[ntb! B KÄ^pImc³ sI«nbh\msW¦n `mcysb¡pdn¨v hnNmchpanÃ.' "\ncmibmtIWvS, tN¨o. Fs¶¡mWp¶Xv Ahs\¡mWp¶Xn\v XpeyatÃ?' cXojv Nncn¨p. "FSm DWvS¡®m, acaWvSm, \o apd¯ot¡dns¡m¯pt¶mSm?' ImÀ¯nI Ahs\

FIvk FIvkÂkv

1

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

ASn¡m³ sN¶p. AhfpsS ssIbn Ibdn¸nSn¨v kp\nX ]dªp: "tN¨o, Ahs\ hnSv... ]mhw CUnbäv. \ap¡v ]pXnb t{]m{Kmw ]Tn¡mw.' "icn, Hcp§ns¡mÅpI', ImÀ¯nI Iw]yq«dn\v ap¼n h¶ncp¶p. "PmeI¸ cn]mSnbpw Fgp¯pw Aev]kzev]w Nn{X¸ WnIfpsams¡ \½Ä ]Tn¨pIgnªp. C\n \ap¡v Aev]w IW¡p Iq«epw IWs¡gp¯pw A¡uWvSv amt\Pvsaâpw ]Tn¡mw.' "At½m! Zm IW¡v hoWvSpw', Icbp¶Xp t]mse cXojv ]dªp. "kvIqfn Xs¶ B \ocmfn shdpsX hnSp ¶nÃ. Ct¸mÄ ChnsSbpw.' " ` b ¡ m s X S m tamt\. FIvk F¶ IWs¡gp¯pImcsâ coXnIÄ GXp aWvS\pw

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Ffp¸w ]nSnIn«p¶XmWv. icn¡pw User-friendly. Asæn ]¯mw¢mÊn X«nap «n IW¡v IS¶ F\n¡v FIvkens\ CjvSs¸Sm³ ]äptam?' "Excel, Office-2000 ]mt¡Pnse Hcp t{]m{KmamsW¶tà tN¨n ]dªXv?' kp\nX tNmZn¨p. "AsX. \ap¡v XpS§mw. XpSt§WvSnS¯v XpS§mhp¶XmWv.' Start sa\phnÂ, Programs- Microsoft Excel FSp¯v Excel Bcw`n¡mw. Hm^okv tjmÀ«vI«v _mdn \n¶pw Excel Xpd¡mw. Excel Xpd¶v hÀ¡v Bcw`n¨pIgnbpt¼mÄ Windows- HmSp¶ GXv \à t{]m{Kmapw t]mse D]tbmKn¡m³ Ffp¸amWnsX¶v a\ÊnemIpw. File->Save tkhv sN¿pw; Edit->Copy ]IÀs¸Sp¡pw; Edit->Paste t]Ìv sN¿pw. A§s\ FÃmw Ffp¸w. Excel ASbv¡m³ File- Exit skeIvSv sN¿pI. Excel hn³tUmbn ssSän _mdnse Close _«¬ ¢nIv sNbvXpw Exit sN¿mw.

hÀ¡v _p¡v, hÀ¡vjoäv, skÂ

"Word- \½Ä tUmIypsaâ v, t]Pv Fs¶ms¡bmWv ]dªncp¶Xv,' ImÀ¯nI XpSÀ¶p. "Excel- hm¡pIÄ¡v Aev]w amäapWvSv.' Excel- tUmIypsaânsâ t]cv Workbook F¶mWv. A¡uWvSânsâ tai¸pds ¯ IW¡p]pkvXI§fntÃ? AXpt]mse¯s¶, ]e t]PpIÄ DÅXmImw Hcp hÀ¡v _p¡v. Workbook F¶ IW¡p]pkvXI¯nse Hmtcm t]Pnt\bpw Worksheet F¶mWv ]dbpI. hÀ¡vjoänemWv \mw ]WnsbSp¡pI. Excel hn³tUmbnse ]e L«§fpw aäv t{]m{KmapIfntet¸mse¯s¶bmWv. sa\p_mdn\v Xmsg, Excel tPmen¡mhiyamb _«WpIÄ DÅ cWvSv SqÄ_mdpIÄ ImWmw. Excel-sâ {][m\`mKw, hÀ¡vjoänse hÀ¡v Gcnb tImf§fpw hcnIfpw \nd ªXmWv. tImf§fneqsSbpw hcnIfneqsSbpw \o§m³ cWvSv kvt{ImÄ _mdpIfp WvSv. Excel Workbook-Â, ASnØm\]cambn tPmenIÄ sN¿p¶Xv Worksheet- BsW¶v ]dªtÃm! tImf§fpw hcnIfpw \ndª CXv \m«nse IW¡¸nÅamcpsS A¡uWvSv ]pkvXI¯nse XmfpIÄ t]me¯s¶bmWv. Name

box

Menu bar

Title bar

Formula bar

Active Cell

Cell row

Cell column

Work sheet

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Hcp Excel hÀ¡v_p¡n aq¶v hÀ¡vjoäpIÄ BWv DWvSmIpI. IqSpX hÀ¡vjoäpIÄ Bhiysa¦n tNÀ¡mw. Xpd¶phcp¶ Hmtcm tUmIypsaân\pw, Document 1, Document 2 F¶n§s\ Word t]cv sImSp¯ncp¶Xpt]mse, Default-

 Hcp hÀ¡v _p¡nse hÀ¡vjoäpIÄ¡v Sheet 1, Sheet 2 F¶mWv t]cv. Hmtcm hÀ¡v joänsâbpw t]cv joän\v Xmgs¯ Sm_pIfn ImWmw. Xpd¶ncn¡p¶ joänsâ t]cv sXfnªncn¡pw. Dt±in¡p¶ joäv Xpd¡m³, B joänsâ Sm_n ¢nIv sN¿pI. Sm_pIfpsS CSXp`mK¯v ImWp¶ kvt{ImÄ _mÀ D]tbmKn¨v Sm_pIfneqsS thK¯n \o§mw. Hcp hÀ¡vjoän\v {]kàamsbmcp t]cv \ÂImw. B Sm_n UºnÄ ¢nIv sNbvXv t]cv sImSp¡pI. "hÀ¡v joän \ndsb hcnIfpw tImf§fpamWtÃm!' ImÀ¯nI ]dªp. "Cu hcnIÄ¡v F®w C«n«pWvSv. Hcp hÀ¡v joän BsI F{X hcnIfpsWvS¶ dnbmtam? A´w hnScpXv þ 65,536. km[mcWbmbn CXn 26þ27 F®ta hn³tUmbn  ImWm³ Ignbq. tamWnädnsâ sdkeyqj³ amdp¶X\pkcn¨v CXn amäw hcpw. tImf§Ä¡v A, B, C, D F¶n§s\ A£c§Ä \ÂInbn«pWvSv. F{X tImf§ fmWv Hcp hÀ¡v joänset¶m? 256. Cw¥ojv A£camebn 26 A£c§ftà DÅq. Z F¶ tImfw Ignªm ASp¯hbv¡v AA, AB, AC F¶n§s\bmWv t]cp IÄ.' tImf§fpw hcnIfpw tNÀ¶v joänse hÀ¡v Gcnbbn \nd ª n c n ¡ p ¶ I Å n I Ä ¡ v skÃpIÄ (cells) F¶v ]dbp¶p. A £ c § f p w A ¡ § f p w t^mÀapeIfpw FÃmsagpXp¶Xv Cu skÃpIfnemWv. tImf ¯nsâ t]cpw hcn

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

bpsS t]cpw tImþHmÀUnt\äpIfmbn FSp¯mWv skÃns\ hnh£n¡pI. B20

F¶m B tImfhpw 20þmw hcnbpw tNÀ¶pWvSmIp¶ skÂ. CXv BZys¯ hÀ¡v joänsâ Imcy¯nÂ. hÀ¡v _p¡nse asämcp hÀ¡v joänse Hcp skÃnsâ A{UÊv Sheet 3! B22 F¶msW¦nÂ, B sk aq¶mas¯ joän B tImfhpw 22þmw hcnbpw tNÀ¶pWvSmIp¶XmWv F¶À°w. asämcp hÀ¡v _p¡nse Hcp sk A{UÊn\v ap¼n B hÀ¡v _p¡nsâ t]cpWvSmIpw. (Test.xls) Sheet 3 C25 F¶ A{UÊnsâbÀ°w Test.xls F¶ hÀ¡v _p¡nse aq¶mw joän C tImfhpw 25þmw hcnbpw tNÀ¶pWvSmIp¶ sk F¶mWv. "CsXms¡ ]pdwImgvNbpsS Imcy§fmWv,' ImÀ¯nI XpSÀ¶p. "Cu skÃp IÄ¡pw hÀ¡vjoäpIÄ¡pw hÀ¡v _p¡pIÄ¡psams¡ ]pdIn Excel-sâ A]mc iànbpÅ IW¡p¡q«Â b{´apWvSv. tai¸pd¯ncn¡p¶ ImÂIpteäÀ FSp ¡m³ \ap¡v thWvSkab¯nepw F{Xtbm Npcp§nb t\cw sImWvSv \½psS Bbnc ¡W¡mb IW¡pIsf Excel Nn«s¸Sp¯pw.'

Excel PmeI¯nse ]cyS\w

sa\p IamâpIfpw Iot_mÀUv Ipdp¡phgnIfpw, tjmÀ«vI«v sa\pIfpw, t^mÀape _mdpw Ìmäkv _mdpw D]tbmK¨v Excel-ambn \mw Bibhn\nabw \S ¯p¶p. IamâpIÄ {][m\ambpw cWvSv hgnIfneqsSbmWv þ sa\p_mdpw tjmÀ«v I«v sa\phpw. Nne IamâpIÄ¡v Iot_mÀUv tjmÀ«vI«pIfpWvSv. DZm: tkhv sN¿m³, Ctrl+S, tIm¸n sN¿m³ Ctrl+C. tjmÀ«vI«pIÄ sa\phnse IamâpIÄs¡m¸w tcJs ¸Sp¯nbncn¡pw. Hcp skÃntem, NmÀ«ntem, SqÄ_mdntem atäm ssdäv ¢nIv sN¿pt ¼mÄ tjmÀ«vI«v sa\p e`n¡p¶p.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

t^mÀape _mÀ hÀ¡vjoänse hÀ¡v Gcnbbv¡v sXm«papIfn SqÄ_mdn\v sXm«v XmsgbmWv t^mÀape _mÀ. Excel-se cWvSv {][m\ [À½§Ä CXv \nÀÆln¡p¶p. 1. IgvkÀ Ccn¡p¶ skÃn Umä tNÀ¡m³ ChnsS ssS¸v sNbvXm aXn. Umä ChnsS Xncp¯m\pw Ignbpw. 2. A¸t¸mÄ tPmen sN¿p¶ skÃn F´msW¶Xv t^mÀape _mdn sXfnbpw. hÀ¡v joäntem, {]nâu«ntem t\m¡n Hcp skÃnse aqey¯n\v ]pdInse t^mÀape Xocpam\n¡m³ IgnbnÃ. AXn\m Excel- tPmen sN¿pt¼mÄ CXv t^mÀape _mdn hyàambncn¡pw. t^mÀape _mdnsâ CSXphi¯mWv Name

Box. CXn ]e t]cpIfpw sk A{UÊpIfpw sXfnªphcpw. 1. Igvkdncn¡p¶ skÃnsâ A{UÊv; 2. Hcp \nc skÃpIÄ¡v aosX Drag sN¿pt¼mÄ, hcnIfptSbpw tImf§fptSbpw F®w; 3. skeIvSv sNbvX t{UmbnwKnsâtbm NmÀ«ns âtbm t]cv F¶nhsbms¡ t^mÀape _mdnse Name

Box- sXfnªp \n¡pw. skÃpIÄ D]tbmKn¡m³ Excel-se Hcp sk skeIvSv sN¿pt¼mÄ AXv Active BIp¶p. AXn\v Npäpw I«nbpÅ Hcp t_mÀUÀ hcp¶p. skeIvSv sNbvX skÃnsâ hcn\¼dpw tImfwseädpw sXfnªp \n¡pw. skÃn Fs´¦nepw F³{Sn DsWvS¦n AXv t^mÀape _mdn sXfnbpw. Active Bb skÃnte Umä FgpXm\mIq. Hcp skÃns\ ]e hn[¯n skeIvSv sN¿mw. * skÃn aukv ¢nIv sN¿pI. * Iot_mÀUnse Arrow IoIÄ D]tbmKn¨v skÃn \n¶pw skÃnte¡v \o§pI. * Edit sa\phn Go To FSp¡pI. (F5 Iobpw Ctrl+G-bpw CXn\mbn D]tbmKn¡mw). Go To UbtemKv t_mIvkv e`n¡pw. GXv skÃnte¡mtWm t]mtIWvSXv B skÃnsâ A{UÊv (DZm: P 1000) Reference- ssS¸v sN¿pI. hÀ¡vjoän ZriyaÃm¯ Hcp skÃnte¡v t]mIm³ Cu coXn klmbIcamWv. * H¶ntesd skÃpIÄ (Hcp \nc þ Range) skeIvSv sN¿m³ AhbneqsS aukv {UmKv sN¿pI. Shift AaÀ¯n, Arrow Io D]tbmKn¡pIbpw sN¿mw. * Hcp Range-sâ hnemkw ImWn¡p¶Xv AXnsâ CSXvþapIfnsebpw heXvþIogv`mKt¯bpw skÃpIÄ sh¨mWv (DZm: A1:K10). Hcp Range-sâ ske Ivj³ Hgnhm¡m³, asämcp skÃn ¢nIv sNbvXm am{Xw aXn. Go to special

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Umäbpw t^mÀapebpw FgpXm³ "AÛpXs¸Smdmbnà Ip«nItf', \mSIob kzc¯n ImÀ¯nI ]dªp. "{Xnà Sn¸n¡p¶ Excel AÛpX§Ä hcm\ncn¡p ¶tXbpÅp. Ct¸mÄ, skÃn Umäbpw t^mÀapebpw FgpXp¶Xv F§s\sb¶p ]dªp Xcmw. "Hcp tImf¯n 65,536 skÃp Ifpw Hcp hcnbn 256 skÃpIfpw DsWvS¶v Rm³ t\cs¯ ]dªtÃm! AXv sh¨v, {XnÃSn¸n¡p¶ Hcp kq{Xw Rm³ Aev]kab ¯n\pÅn ImWn¨pXcmw.' Hcp skÃn F{X IymcIvSdpIÄ Enter

sN¿msat¶m? 32000-¯ntesd. Hcp t^mÀapebn F{X IymcIvSdpIÄ hscbm Imsat¶m? 1024 hsc. Hcp skÃn Umä sbgpXn Enter AaÀ¯n¡gnªm UmäbXn Dd¨p Ignªp. Enter AaÀ¯p¶ Xn\p ap¼v, Umä ambv¨p Ifbm³ Esc Io AaÀ¯pI. Hcp tPmen sNbvXv Ignªv, AXv Dt]£n¡m³ Edit- Undo skeIvSv sN¿pI. SqÄ_mdnse Undo _«Wpw D]tbmKn¡mw. Undo-hnse drop-down enÌv D] tbmKn¨v Ahkm\ambn sNbvX 16 {]hÀ¯nIÄ hsc Undo sN¿mw. Undo sNbvX Hcp {]hr¯n hoWvSpw C^IvSohm¡m³ Edit->Repeat FSp¡pI. Umäbpw t^mÀapebpw FgpXp¶ kab¯v skÃnsâ kuµcys¯¡pdn¨v thhem Xns¸tSWvS. t^mÀamänwKv ]ns¶ sN¿mw. "Ct¸mÄ ]cn]mSn ]Tn¨tÃm!', ImÀ¯nI ]dªp. "C\n Excel-sâ ImÂIptej³ ]hÀ {]mtbmKnIambn ]cntim[n¡mw. cXotj, A1 sk skeIvSv sNbvXv AXn 65536 F¶v Enter sN¿v. Enter AaÀ¯n IgvkÀ Xmgs¯ skÃn F¯n¡pI. C\n A2-hn 256. CXv Excel hÀ¡vjoänse hcnIfp tSbpw tImf§fptSbpw F®amWv. Enter Hcn¡Â IqSn AaÀ¯pI. "C\n A3 skÃn =A1*A2 F¶ t^mÀape ssS¸v sN¿pI. Equal (=) ASbmfw CSm³ ad¡cpXv. \£{X NnÓw (*) KpW\{Inbbv¡pÅ {]XoIamWv. Enter AaÀ¯ntb¡v. A3 skÃn Ct¸mÄ F´mWv ImWp¶Xv? 16777216 AtÃ? AXmbXv Hcp hÀ¡v joän 167 e£ ¯ntesd skÃpIÄ DsWvS¶v' "ât½m!' AÛpXkzcw hnZymÀ°nIÄ Ccphcn \n¶pw GIIme¯mWpWvSmbXv. C\n Excel-sâ hÀ¡v ]hÀ A1, A2

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

t\m¡m\pÅ asämcp ]co£Ww \S¯mw. sk FUnäv sN¿p¶ hnZybmWnXv. A3 skÃnse t^mÀape amän Hcp hÀ¡v _p¡n F{X sk DsWvS¶v IWvSp]n Sn¡mw. * A3 skÃnÂ, AXnse Umä FUnäv sN¿m\mbn, UºnÄ ¢nIv sN¿pI. * t^mÀapebpsS Ahkm\¯n Insertion Point hcp¯m³ End Io AaÀ¯pI. F¶n«v *3 ssS¸v sN¿pI. * Enter AaÀ¯pI. * A3 skÃnse dnkÄ«v t\m¡pIþ50331648. "Hcp hÀ¡v_p¡nse skÃpIfpsS F®sa{X?' ImÀ¯nI tNmZn¨p. "hfsc Ipdhv, AtÃ? A©v tImSnbne[nIw!' Excel-sâ tijnbpsS cpNnbdnbm³ asämcp ]co£Ww FSp¡mw. A1, A2 skÃp Ifnse kwJyIÄ amän t\m¡pI. A3 skÃnse KpW\^ew amdnbXv {i²n¡m³ t]mepw \ap¡v t\cw In«nÃ. A{X s]s«¶mbncn ¡pw amäw.' Hcp t^mÀapebpambn _Ôs¸Sp¶ Umä a m d p ¶ X \ p k c n ¨ v t^mÀape ]p\ÀKWn ¡m³ Excel-\v Ignbp¶p. CsXmcnS¯Ã, Hcp hÀ¡v_p¡nse Hmtcm t^mÀapebnepw Cu doþIm¡ptej³ \S ¡p¶p. UmäIfpw t^mÀapeIfpw AS §p¶ Bbnc¡W¡n\v skÃpIfn C§s\ IW¡p Iq«Â \S¡p¶ Imcyw BtemNn¡pI (skÃnse Unkvt¹, AXnse Umäsb _m[n ¡msX, amäm³ Ignbpw). * A1, A3 skÃpIÄ skeIvSv sN¿pI. A1 cell- \n¶v aukv sImWvSv A3 hsc {UmKv sN¿pI. * skeIvSv sNbvX skÃpIfn FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. tjmÀ«v I«v sa\yphn \n¶v Format Cells FSp¡pI. Format Cells UbtemKv t_mIvkv Xpd¡p¶p. * Number F¶ Sm_v ¢nIv sN¿pI. CXn ske£\pIÄ \S¯pt¼mÄ sample

t_mIvkn\I¯v \¼À sXfnbp¶Xv {i²n¡pI. * Category enÌn Number skeIvSv sN¿pI. Undo

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

* Use 1000 Separator F¶ check

box ¢nIv sN¿pI. Decimal place- "]qPyw' CSpI. * OK ¢nIv sN¿pI. * A1, A2, A3 skÃpIfn 1000þ\v taepÅ kwJyIfpsS Unkvt¹ t\m¡pI. 1000þ§sf thÀXncn¡p¶ tIma ImWmw. DZm: 65,536. ]t£, Cu amäw bYmÀ°\¼ dns\ _m[n¡nÃ. Unkvt¹bn am{XamWo amäw. hyàambdnbm³ Hcp skÃn ¢nIv sNbvXv t^mÀape _mdn t\m¡pI. AhnsS sXfnbp¶ kwJybn tIma DWvSmhnÃ. kwJyIÄsImWvSpÅ Cu Ifn¡n Sbn Nne skÃpIfn Nnet¸mÄ # # # F¶ ASbmfta ImWq', ImÀ¯nI ]dªp. "]t£, `bs¸tSWvS. kwJyb{Xbpw ImWn¡m³ skÃn\v hoXnbnÃm¯ XpsImWvSmImanXv. Format amän, skÃnsâ hoXnIq«ntbm sNdnb t^mWvSp]tbmKnt¨m Cu {]iv\w ]cnlcn¡mw.' Hmt«m ImÂIpteäv skeIvSv sNbvXncn¡p¶ skÃpIfnse kwJyIfpsS XpI Unkvt¹ sN¿m\mbn Hcp henb kuIcyw Excel-\pWvSv. CXmWv Auto Calculate. B4 apX B9 hscbpÅ skÃpIÄ skeIvSv sNbvXncn¡pt¼mÄ (B4:B9) B Bdv skÃpIfnse kwJyIfpsS XpI (Sum =) Status bar- {]Xy£s¸Spw. sNt¿WvS tPmenbpsS t^mÀape FgpXmsX¯s¶ XpI ImWm\pÅ Gähpw \à Ffp¸ hgn CXmWv. (Auto Calculate-

 C\nbpw kuIcy§fpWvSv. Auto

Calculator Cânt¡ädn ¢nIv sNbvXm In«p¶ tjmÀ«vI«v sa\p D]tbmKn¨v, IW¡pIq«ensâ coXn amämhp¶XmWv.)

Excel-se bm{XIÄ

Excel hÀ¡vjoäv Hcp ]mcmhmcamsW ¶v a\ÊnembntÃ? ImÀ¯nI ]dªp. AXnsâ Hcp sNdnb `mKw am{XamWv \mw ImWp¶Xv. hÀ¡vjoänsâ asämcp `mKt¯¡v \o§m³ AhnsS Hcp sk skeIvSv sN¿pItb thWvSp. AXn\v autkm Iot_mÀtUm D]tbm Kn¡mw. Asæn AXn\mbn Iamâpap WvSv. Format Cells

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

skÃneqsS \o§m³ * Hcp Arrow Io AaÀ¯pI * kvt{ImÄ _mdnsâ cWvSä¯pÅ Arrow-

Ifn GsX¦nepsam c®w ¢nIv sNbvXv AXv NqWvSp¶ `mKt ¯¡v Scroll

sN¿mw. * Hcp sk skeIvSv s N ¿ p I . Iot_mÀUnse Scroll Lock

AaÀ¯pI. ske Ivj³ amdmsX ¯s¶ hÀ¡v joänepsS \o§m³ kvt{ImÄ Arrow IoIÄ D]tbmKn¡mw. * aukn\v kvt{ImÄ ho DsWvS¦n AXp]tbmKn¨v hn³tUmbn kvt{ImÄ sN¿mw. kv{Io\neqsS \o§m³ * Hmtcm kv{Io³ apIfntebvt¡m Xmtgbvt¡m \o§m³ Page Up, Page Down

IoIÄ. * Scroll Box _«Wv ]pd¯v kvt{ImÄ _mdn ¢nIv sN¿pI. * Scroll Box {UmKv sN¿pI. Scroll box {UmKv sN¿pt¼mÄ \n§Ä F¯ns¸Sp¶ tImfhpw hcnIfpw sXfnbp¶ Hcp Scroll Tip ImWmw. hÀ¡vjoäpIÄ amäm³ hn³tUmbpsS Iogv`mKs¯ Sm_pIfn ¢nIv sNbvXv BhiyapÅ hÀ¡v joäv FSp¡mw. Ctrl+Page Up, Ctrl+Page Down IoIfpw C¡mcy¯n\mbn D]tbmKn¡mw. IpXn¨pNm«§Ä ]et¸mgpw kv{Io\n ZriyaÃm¯ Hcp skÃntet¡m Range-tebvt¡m \ap¡v NmtSWvSn hcpw. CXn\v Go To UbtemKv t_mIvkv FSp¡mw. (Edit-Go To). UbtemKv t_mIvknse Go To enÌn \n¶v t]mtIWvS Range skeIvSv sN¿pItbm, Reference box- A{UÊv ssS¸v sN¿pItbm sN¿mw. Formula Box-se Name Box D]tbmKn¨pw C¯cw Nm«w \S¯mw. Name box- Hcp hnemktam Range Name-Hm ssS¸v sNbvXv Enter AaÀ¯nbm aXn. CXn\mbn t_mIvknsâ drop-down enÌpw D]tbmKn¡mw.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

* Home Io AaÀ¯nbmÂ, tPmen sN¿p¶ hcnbpsS XpS¡¯n F¯mw. * Ctrl+Home D]tbmKn¨v \nehnepÅ hÀ¡v joänsâ A1 skÃnse¯mw. * Ctrl+End AaÀ¯pI. sXm«pap¼v tPmen sNbvX tImf¯nsebpw hcnbnsebpw skÃnse¯mw. End AaÀ¯nb tijw Home AaÀ¯nbmepw CXp Xs¶ ^ew. * End AaÀ¯n Enter sN¿pI. tPmen sNbvXpsImWvSncn¡p¶ hcnbn Ahkm \ambn D]tbmKn¨ skÃnse¯mw.

hÀ¡v_p¡v amäm³

"Word- Htc kab¯v ]e tUmIypsaân tPmen sN¿p¶Xpt]mse, Excel-

 Htc kab¯v ]e Workbook-Ifn tPmen sN¿mw', ImÀ¯nI ]dªp. "hn³tUm IÄ amdp¶ ]Wnt]mse Xs¶bmWv hÀ¡v_p¡pIÄ amdp¶Xpw.' * ASp¯ hÀ¡v_p¡v kv{Io\n ImWm\psWvS¦n AXn ¢nIv sN¿pI. * Window sa\phn \n¶v BhiyapÅ hÀ¡v_p¡v skeIvSv sN¿pI. * Ctrl+F6 AaÀ¯p¶Xv ASp¯ hn³tUmbnte¡v t]mIm³ klmbn¡p¶p. "Excel-eqsS bm{X sN¿m\pÅ amÀ¤§Ä CsXms¡bmWv. C\n \ap¡v SqÄ_mdp IÄ D]tbmKn¡p¶Xv F§s\bmsW¶v t\m¡mw þ ]Xnhv Im¸n ¡ptijw.' ImÀ¯nI Im¸nsbSp¡m³ apdnhn«pt] mbn.

SqÄ_mÀ D]tbmKn¡p¶Xv

I m ¸ n b p a m b n ImÀ¯nI hcpt¼mÄ kp\nXbpw cXojpw Excel-

sâ ImÂIptej³ ]hÀ ]cntim[n¨psIm WvSncn¡pIbmbncp¶p. "AXv ]n¶oSmImw. \msf sshIo«v Rm³ hcp¶Xn\p ap¼v CjvSw t]mse kabapWvStÃm! Ct¸mÄ \ap¡v SqÄ_mdp IÄ t\m¡mw,' ImÀ¯nI ]dªp. Excel 2000 shÀjt\msSm¸w h¶ Hcp ]pXnb Hm]vj\mWv Personal SqÄ_mÀ. HcmÄ IqSpXembn D]tbmKn¡p¶ SqÄ_mdpIfpsS ]«nIbmWnXnsâ ASn¯d. Standard

SqÄ_mdnsebpw Formatting SqÄ_mdntebpw _«WpIÄ Cu SqÄ_mdn ImWpw. SqÄ_mdn FÃm _«WpIfpw H¶n¨v \nc¯m³ thWvS ØeanÃm¯XpsImWvSv, IqSp Xembn D]tbmKn¡p¶ SqfpIfmbncn¡pw Personal SqÄ_mdn ImWpI. AXn \m¯s¶ Personal Toolbar-se Unkvt¹ sFäwkv hÀ¡\pkcn¨v amdns¡mWvSncn¡pw. http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

BhiyapÅ _«¬ SqÄ_mdn ImWp¶nsæn More Buttons _«¬ ¢nIv sN¿pI. Standard, Formatting SqÄ_mdpIfn ImWp¶ Personal Toolbar D]tbmKw \nÀºÔanÃ. Standard, Formatting SqÄ_mdpIÄ cWvSv \ncIfnembn¯s¶ display

sN¿mhp¶XmWv. Personal Toolbar- FhnsSsb¦nepw ssdäv ¢nIv sN¿pI. Customize UbtemKv t_mIvkv e`n¡p¶p. UbtemKv t_mIvknse Options Sm_v skeIvSv sNbvXv B t]sPSp¡pI. Standard and Formatting Toolbars Share One Row F¶Xnsâ skeIvj³ \o¡w sN¿pI. OK ¢n¡v sN¿pI Standard, Formatting SqÄ_mdpIÄ IqSmsX ]ns¶bpw SqÄ_mdpIÄ DWvSv FIvken Â. ChsbSp¡m³ View sa\phn Toolbars skeIvSv sN¿pI,

slÂ]v e`n¡m³

aq¶v hn[¯nepÅ Help, Excel 2000 hmKvZm\w sN¿p¶p. Office Assistant: Word-tet¸mse Hcp "Indp¡³' IYm]m{Xw tNmZy§Ä¡v icnbp ¯cw Xcp¶p. Help Topics: Excel-s\¡pdn¨pÅ hnhc§Ä AS§p¶ AkwJyw t]PpIÄ. DÅS¡hpw kqNnIbpw hgn CXv e`n¡pw. Help Topics e`n¡m³ F1 AaÀ¯pI. "C\n bYmÀ° tPmenbnte¡v', ImÀ¯nI ]dªp. "Excel D]tbmKnt¡WvS hn[w \n§Ä a\Ênem¡n¡gnªp. C\n Umä FâÀ sN¿m\pw FUnäv sN¿m\pw \msf ]Tn¡mw. Cs¶\n¡v Hm^okn \n¶pÅ Aev]w tlmwhÀ¡pWvSv. Good

Night' "KpUvss\äv, tN¨o.'

Npcp-¡-¯nÂ...

F{X k¦oÀ®amb F¡uWvSpIÄ kq£n¡m\pw MS Excel l Word-s\t¸mse¯s¶.D]tbmKn¡ms\fp¸w Excel l FIvk hÀ¡vjoäv AXnhn]pew l skÃpIÄ¡v A{U

ÊpIÄ þ tImfhpw hcnbpw kwKan¡p¶X\pkcn¨v sk A{UÊv l IW¡pIÄ¡v

t^mÀape l skÃpIfnse {]hr¯nIÄ A¸t¸mÄ t^mÀape _mdn ImWpI l

FIvk IW¡pIq«epIÄ an¶ÂthK¯n \S¡p¶p l skÃpIfpsS Range skeIvSv

sN¿mw, AXn tPmensN¿mw

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

FIvk hÀ¡vjoän IfnIfpw IÅ¡fnIfpambn Ccn¡pIbmbncp¶p kp\n Xbpw cXojpw. i_vZw tI«v hmXn¡te¡v t\m¡nbt¸mÄ AhÀ AÛpXs¸«p.

ImÀ¯nIbpsS IqsS asämcmÄ. ImÀ¯nItbmfw Dbcw, GXmWvStX XSn. \oe Po³kv. SIvþC³ sNbvX, tImfdnÃm¯ sadq¬ SojÀ«v. BWp§sft¸mse t{Im¸p sNbvX apSn. tXmf¯v Xq§n¡nS¡p¶ _mKv. Imen kvt]mÀ«vkv jq. hbÊv 15þ\pw 25þ\pw CSbv¡v FhnsSbpamImw. N´apsÅmcp kpµcn. I®SbnÃ. (cXojnsâ a\ Ên Iw]yq«À cwK¯pÅhscÃmw I®S¡mcmWv). ImÀ¯nI ]pXpapJs¯ ]cn Nbs¸Sp¯n.

"CXv \oena. thjw IWvSv ]Ibv¡pIsbm¶pw thWvS. X\n aebmfns¸¬sIm Snbm. thjw PmSbmbn Iq«nbm aXn. Fsâ Hm^oknse A¡uWvSvkv tkm^vävshbÀ FIvkvs]À«m. Excel BWnhnsS hnjbw F¶v ]dªt¸mÄ ChÄs¡mcp ]qXn, \n§sf AhÄ¡v ]Tn¸n¡Wsa¶v. C\n Excel Igntª t]mIq.' "lmbv... ' \oena Ip«nIÄ¡cnIn h¶p\n¶v kt´mjt¯msS ]dªp.

"Ipg¸amIptam', kp\nX cXojnt\mSv ]ndp]ndp¯p. ]t£, \oenabXv tI«p.

"Hcp Ipg¸hpanÃ', AhÄ ]dªp. "ImÀ¯nItb¡mÄ at\mlcambn Rm³ \n§sf ]Tn¸n¡pw.' Xncnªv ImÀ¯nItbmSv "FSo, Cu \mdp¶ thjw amdtWvS? H¶v Ipfn¡Ww, hni¸v amäWw.' IW-¡nsâ hgn-IÄ

2

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"R§Ä Ipfnbpw Xoäbpw Ignªv hcmw, \n§Ä Ccn¡v' ImÀ¯nI ]dªp.

"B, tN¨namÀ t]mbn«phm', sXsÃmcp kwibt¯msS cXojpw ]dªp.

Umä tNÀ¡m³

Ipfnbpw Im¸nIpSnbpw Ignªph¶ tN¨namÀ t\sc Ip«nIÄ¡cnInse¯n.

ImÀ¯nI F¶t¯bpw t]mse ss\änbnembncp¶p. F¶m \oenabpsS thjw cXojn\v t_m[n¨p.

"ssIenbpw jÀ«pw.' B thj¯n AhÄ icn ¡psamcp B¬Ip«nbmsWt ¶ tXm¶q. Ft´m IpkrXn ]dbm\h³ hm Xpd¡pt¼mtg¡pw ImÀ¯nI ]dªp.

" I p c p ¯ t ¡  sSm¶pw Fgp¶Ån¡WvS DWvS¡®m. ChÄ Bfev]w ioabm.' "]mhamsW¶tà tN¨n t\ct¯ ]d ªXv? kp\nX tNmZn¨p.

"Hm, ]mhw {Iqc!' FÃmhcpw Nncn¨p. ImÀ¯nI Hcp ]pkvXIhpsaSp¯v I«nen Ibdnbncp¶p.

"icn, XpS§mw', \oena ]dªp. "\n§Ä _me]mTsams¡ ]Tn¨p IgnªtÃm!

icn, CUnbäv XpS§v' (cXojv sR«n. Ipäs¸Sp¯pwt]mse ImÀ¯nIsb t\m¡n).

"Hcp skÃn Hcp kwJy F³À sN¿v.' cXojv A1 skÃn 999 F¶ kwJy ssS¸v sNbvXp.

"t^mÀape _mdn t\m¡v', \oena ]dªp. "999 AhnsS h¶XpItWvSm?' "DÆv, AXphcpsa¶v R§Ä¡v t\ct¯ Adnbmw' sXÃl´tbmsS cXojv ]dªp.

"tIt«m ImÀ¯ntI, Cu CUnbän\v Adnh¸w IqSpXem' \oena ]dªp.

"F¶m C\n tUm¦ntbmSmImw (C¯hW kp\nX sR«n). "t^mÀape _mdnÂ, kwJy IpSmsX F´pWvSv?' "Hm, AXnt¸mgm {i²n¨Xv', kp\nX ]dªp. "cWvSv _«WpIÄ. Hcp KpW\ NnÓw, ]ns¶sbmcp SnIv amÀIv. AsX´n\m?' "Hm, \n\s¡¦nepsamcp kwibapWvStÃm!' \oena ]dªp. "F¦n B KpW\ NnÓapff _«Wn H¶v ¢n¡v sN¿v' kp\nX KpW\NnÓ _«Wn ¢n¡v sNbvXp. skÃn ssS¸v sNbvX kwJy A{]Xy£ambn.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"Blm! CXmtWm kw`hw? At¸mÄ CXv Cancel Button', kp\nX ]dªp.

"AsX. A§s\¯ s¶bmWXnsâ t]cv. Esc

Io AaÀ¯nbXn\v Xpeyw. ]t£, kwJysbgpXn Enter sN¿p¶Xn\v ap¼v am{Xta AXp]tbm Kn¡m³ Ignbq', \oena hniZoIcn¨p.

"F¦nÂ, SnIv amÀ¡v F´n\msW¶v Rm³ ]dbmw', cXojv CSbv¡p Ibdn. skÃn hoWvSpw ssS¸v sNbvXv Ah³ SnIv amÀ¡v DÅ _« Wn ¢n¡v sNbvXp.

"atäXv Cancel _«Wm IgptX (kp\nXtbmSv), C\nbo kwJysbm¶v Im³k sN¿v.' "icnbmWv', \oena CSs]«p. "kwJysbgpXn Enter Io AaÀ¯pItbm, SnIv _«¬ ¢n¡v sN¿pItbm sNbvXmte kwJy hÀ¡vjoänsâ `mKamIq. asämcp Imcyw IqSnbp WvSv. Enter Io AaÀ¯n¡gnbp¶tXmsS \½Ä sXm«pXmgs¯ skÃn F¯n ¡gnªp. Shift AaÀ¯n Enter sN¿pIbmsW¦n IgvkÀ sXm«papIfnes¯ skÃnep sa¯pw.' "CXn§s\¯s¶tb ]äq F¶ptWvSm', kwibw kp\nXbptSXv.

"CÃtÃm. AXv amäWsa¶psWvS¦n Tools- Option FSp¡pI. Edit F¶ Sm_v IymcIvSÀ

kwJybv¡v ap¼nse +

NnÓw

E/e

]mc³Xnknkv þ {_m¡äv

iXam\NnÓw (%)

t^mÀhmÀUv Émjv (/)

(lcW NnÓw)

hyhIe\ NnÓw (-)

kwJy¡v ap¼nse ]qPyw (0)

Excel hymJym\w

+ NnÓs¯ AhKWn¡p¶p

NnÓ¯n\v ]pdIn t^mÀape

hcps¶¦n AXns\ = B¡n

amäpw.

imkv{Xobambn [cn¡p¶p

kwJy¡v Ccp]pd¯pamsW¦nÂ

s\Käohv kwJybm¡pw.

100þsâ iXam\ambn ImWpw.

kwJyIfpsS IqsSbmsW¦nÂ

XobXnbmbn [cn¡p¶p.

kwJyIfpsS IqsSbmsW¦nÂ

XnbXnbmbn IW¡m¡mw.

]qPys¯ AhKWn¡p¶p.

F³{Sn

+9,000

+90,$D$6

5.5e7

(600)

10%

9/12/92

6/29

8/02

11-02-97

0789

^ew

9,000

=90+$D$6

5.5E+7

-600

0.10

12þ Sept-1992

June 29, (\S¸phÀjw)

Aug, 2002

2-Nov-1997

789

Tab D]tbmKn¨v

skeIvSv sNbvX

td©neqsS \o§mw

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Xpd¶m In«p¶ Hm]vj³kv Cu \o¡¯n amä§Ä DWvSm¡m³ D]tbmKn¡mw.' \oena ]dªp.

skÃpIfpsS Hcp Range-emWv Umä tNÀ¡p¶sX¦n Hcp Ffp¸hgnbpWvSv.

Range skeIvSv sNbvXpIgnªm Tab Io D]tbmKn¨v XpS¡w apX Range-sâ Ahkm\s¯ sk hsc \o§mw. hoWvSpw Tab AaÀ¯nbm Xncn¨v Range-se BZys¯ skÃnse¯pw.

UmäbpsS Excel hymJym\w \mw \ÂIp¶ Umäsb Excel kz´ambn hymJym\n¡pw þ H¶pIn kwJybmbn, Asæn sSIvÌv Bbn. sSIvkväv Bbn Excel

ImWp¶ Umäsb AXv se^vävþAsse³ sN¿pw. kwJybmbn ImWp¶Xns\ ssdävþAsse³ sN¿pw.

]qPyw (0) apX H¼Xv (9) hscbpÅ A¡§fpw +, -, E, e, (, ), $, %, / F¶nhbpw BWv kwJym Umäbmbn Excel ImWpI.

_m¡n IymcIvSdpIÄ FÃmw Excel-\v sSIvÌmWv. AXpt]mse lcWNnÓanSpt ¼mgpw kq£n¡Ww. 1/25 F¶v lcW¯n \mbn tNÀ¯m Excel CXv XobXnbmbn sXän²cn¨v P\phcn 25 F¶v hymJym \n¡pw. 0.04 F¶ AÀ°¯nemWv \mw 1/

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

25 Fs¶gpXp¶sX¦n AXn\v sNdnsbmcp kq{X{]tbmKw \S¯Ww. kwJybv¡v ap¼n \yq\NnÓw, k¦eNnÓw, ]qPyw(0) F¶nhbn GsX¦nepsam¶v tNÀ¡pI.

F¶m kwJy¡v ap¼n ]qPyw (0) tNÀ¡p¶Xns\ Excel Imcyambn KWn¡nÃ.

AXmbXv, 0484 Fs¶gpXnbm AXv FdWmIpf¯nsâ sSent^m¬ STD tImUÃ, shdpw 484 BWv. At¸mÄ ]ns¶ F´p hgn? 0484-\v ap¼n Hcp ' tNÀ¡pI ('0484). Format sa\phn Cells Iamân Number Sm_n Text skeIvSv sNbvXpw Cu {]iv\w ]cnlcn¡mw. Umä sSIvÌmbn ]cnKWn¡s¸«p Ignªm AXv se^vävþAsse³Uv Bbn amdpw.

Nne IymcIvSdpIÄ thWvShn[w D]tbmKn¨nsænÂ, \mw Dt±in¡p¶ AÀ° ¯nembncn¡nà Excel hymJym\n¡pI.

Umä ^nÂ

"Nne t\c§fn Htc Umätbm t^mÀapetbm Ht«sd tImf§fnepw hcnIfnepw BhÀ¯nt¡WvSXmbn hcmw', \oena ASp¯ L«¯nte¡v IS¶p. "Hmtcm skÃnepw copy-paste {]tbmKn¡pIsb¶m t\cw IfbpI F¶p am{XamWÀ°w.

Cu {]iv\w ]cnlcn¡m³ Excel \ÂIp¶ Ffp¸amÀ¤amWv Data Fill. BZy skÃnsâ DÅS¡hpw t^mÀamäpw Umä ^n ]IÀ¯p¶p. Hcp tImf¯neqsS Xmtgm«pw Hcp hcnbneqsS het¯m«pw Data Fill sN¿p¶XmWv km[mcW coXn. F¦nepw apIfnte ¡pw CSt¯m«pw Fill sN¿epw km[n¡pw. "sa\p D]tbmKn¨v ^n sN¿mw. ^n sNt¿WvS Range skeIvSv sN¿pI.

Range-se BZy skÃnse DÅS¡ambncn¡pw (Xmtgmt«m heXphit¯t¡m) ^n sN¿s¸SpI. Edit sa\phn Fill FSp¯v GXv Znibnte¡mWv ^n sNt¿WvSsX¶v skeIvSv sN¿pI.' aukp]tbmKn¨pw Umäm ^n sN¿mw. CXn\v Excel-sâ ^nÂ

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

lm³Un D]tbmKn¡p¶p. tIm¸n sNt¿WvS sk skeÎv sN¿pI. skÃnsâ Xmg¯v he¯v aqebn IgvkÀ (+) ¹kv ASbmf¯nemIpw. CXmWv Fill handle. AXn ¢n¡v sNbvXv {UmKv sN¿pI.

Umäm kocnkv

kzm`mhnIambn hÀ²n¡p¶ (Progression)

kwJyIfpsS Hcp t{iWnbmWv Data series.

kwJyIÄ X½n GsX ¦nepw \nebv¡v _Ô s¸«ncn¡pw. DZm: 2, 4, 6, 8; 1, 2, 3... Cu cWvSv t{iWnbnÂs¸« kwJy Isfbpw Excel a\Ênem ¡pIbpw hymJym\n¡p Ibpw sN¿pw. am{XaÃ, Umä Enter sN¿p¶ skÃpIfpsS range- Umä \ndbv¡pIbpw sN¿pw.

kocnkv CSm\pÅ Range skeIvSv sN¿pI.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Edit sa\phn Fill- Series F¶ Iamâ v skeIvSv sNbvXm Hcp UbtemKv t_mIvkv e`n¡pw. UbtemKv t_mIvkn aq¶v hn`mK§fnembn Hm]vj\pIÄ ImWmw.

Series in:- skeIvSv sNbvXncn¡p¶ Range A\pkcn¨v Umä \ndbvt¡WvS Zni Excel \nÀ®bn¡pw. skÃpIfpsS Row (hcn), Columns F¶nhbn H¶v skeIvSv sN¿pI.

Type Linear: skÃn \ÂInbn«pÅ kwJysb B[mcam¡n, Step value F¶ t_mIvkn \ÂIp¶ aqeya\pkcn¨v td©nse skÃpIfn Linear Progressiosn

A\pkcn¨v Excel Umä \nc¯pw.

td©nse BZyskÃn InS¡p¶Xv 10þDw Step value 10-Dw BsW¦n td©nse skÃpIfn 10, 20, 30, 40 F¶n§s\ Umä hogpw.

Type-Growth: Step Value t_mIvkn \evInbncn¡p¶ aqeyw sImWvSv BZy skÃnse kwJybpsS km[mcW KpW\^e§Ä ASp¯ skÃpIfn \nc¯m \mWv Cu Hm]vj³. skÃnse aqeyw 1þDw Step value 2-Dw BsW¶ncn¡s«. 1, 1x2, 2x2, 4x2, 8x2 Ft¶m, 1, 2, 4, 8, 16 Ft¶m Excel Umä \ndbv¡pw.

Type-Date: BgvNb \pkcnt¨m, amka\pkcnt ¨m, XnbXnIfpsS kocnkv \ndbv¡m\mWv Cu Hm]vj³. DZm: H¶mas ¯ skÃn 8/31/01

F¶v FâÀ sNbvXv Date

Hm]vj³ Month FSp¡p IbmsW¦n 8/31/01, 9/

30/01,10/31/01 F¶n §s\ Excel Umä \ndbv¡pw.

Type-Autofill: Iptd skÃpIfn Umä FâÀ sNbvX tijw, Hcp td©nse _m¡n skÃp IÄ \ndbv¡m³ Excels\ A\phZn¡m³ A¡ §Ä X½nepÅ _Ôw hyàam¡p¶ Cu Hm]vj³ D]tbmKn¨m aXn. BZyskÃn 15þDw ASp¯ skÃn 25þDw \mw FâÀ sNbvXv Cu Hm]vj³ FSp¯m ASp¯ skÃpIfn 35, 45, 55 F¶n §s\ Excel kwJy \nc¯pw.

Trend: Linear, Growth Hm]vj\pIÄt¡ Cu t_mIvkv e`yamIq.

Step Value, Stop Value: kwJyIfptStbm XnbXnIfptStbm hÀ²\ F{]Imcw thWsa¶pw KpW\w F§s\ thWsa¶pw \nÀ®bn¡p¶Xv Step Value BWv.

kocnknse Gähpw IqSnb kwJy Stop Value t_mIvkn \nÀt±in¡p¶p.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"CXv kwKXn Ffp¸amWtÃm tN¨o', kp\nX ]dªp. "FÃm skÃnepw A¡ §Ä \ndt¡WvS KXntISnÃtÃm!' "AsX', \oena k½Xn¨p. "]t£, sImSp¡p¶ aqey§Ä IrXyambncn¡Wsa ¶pam{Xw.' "Aà tN¨o, CsX´m Ipsd Umä CSXp` mK¯pw thsd Iptdsb ®w heXp`mK¯pw Asse³ sNbvXncn¡p ¶Xv?' cXojv tNmZn¨p.

"AXv \n\¡v t\cs¯ ]dªp X¶ XmWv. kwJyIÄ heXp `mK¯pw sSIvÌv CSXp `mK¯pamWv Asse³ sN¿pI', \oena ]dªp. "]t£, \o tNmZn¨sX\n¡v a\Ênembn.

]dbmw. \mw Hcp tS_nÄ DWvSm¡n F¶ncn ¡s«. AXns\¡pdn¨v Hcp Ipdn¸v AXnsâ

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

sbm¸w tNÀt¡WvSnht¶¡mw. AXv tS_nfnsâ heXp`mK¯v ssS¸v sN¿mw. ]t£, kv{Io\nÂ, Ipdn¸v apgph³ {]Xy£ambnsöv hcmw. At¸mÄ B sk skeIvSv sNbvXv Edit sa\phn Fill- Justify FSp¡pI. CXv ItWvSm? Ipdn¸v B tImf ¯n¯s¶ Xmtgm«v Xmtgm«v hn`Pn¨v \nc¶ntÃ?' "Great!' kp\nX ]dªp.

ssdäv ¢n¡v

"tIt«m, kp\ntX' cXojv kXoÀ°ysb hnfn¨p. "Excel- ssdäv ¢n¡n\v henb {]m[m\yw Csöm tXm¶p¶Xv.' "t]mSm, DWvS¡®m', D¯cw ]dªXv \oenabmWv.

"\obÃtÃm AXv Xocpam\n¡p¶Xv. hntijn ¨v Autofill D]tbmKs ¸Sp¶XmWv ssdäv ¢n¡v.' ^n sN¿m\pÅ Range sXcsªSp¡m³, ^n lm³Un {UmKv s N ¿ p ¶ X n \ p a p ¼ v heXp _«¬ AaÀ¯pI. td©v sXcs ªSp¯p Ignªm _«¬ hnSpI. Hcp tjmÀ«vI«v sa\p e`n ¡p¶p. Autofill sN¿m \pÅ ]e Hm]vj\pIÄ CXn DWvSv.

Copy Cells: Hcp ]pXnb kocnkv krjvSn¡p¶Xn\v ]Icw, sXcsªSp¯ skÃnsâ tIm¸nbmbncn ¡pw Autofill BIpI.

Fill Series: Autofill D]tbmKn¨v kocokv \ndbv¡p¶ AtX ^ew e`n¡p¶p.

Fill Format: Edit sa\phn Paste Special-se Formats FSp¡p¶Xn\v kZriyam WnXv.

tIm¸n sNbvX td©nse t^mÀamänsâ AtX {Ia¯nembncn¡pw tIm¸n sN¿ s¸Sp¶Xpw.

Fill Values: skÃpIfnse aqey§Ä tIm¸n sN¿p¶p. ]t£, t^mÀamäpIÄ ]IÀ¯s¸Sp¶nÃ.

XobXn ASnØm\s¸Sp¯nbpÅ range BsW¦n Days, Weekdays, Years

F¶nh ^n sN¿m\pw, Linear Trend, Growth Trend, Series F¶nhbv¡pw ssdäv ¢n¡vþ{UmKv D]tbmKn¡mw. CXn Series skeIvSv sNbvXm Series UbtemKv t_mIvkv e`n¡pw.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

IÌw ^nÂ

Hcp td©nse skÃpIfn H¶n\Sp¯ Znhkw ASp¯ skÃn hcpwhn[w BgvNbnse Znhk§sf \nc¯m³ Autofill-\v Ignbpw. DZmlcW¯n\v, BZy skÃn Monday

F¶v ssS¸v sNbvXv skÃnsâ ^n lm³Un hcnbneqsS IpdpsI {UmKv sNbvXm ASp¯ skÃpIfn ASp¯ Znhk§Ä (Tuesday, Wednesday...) sXfnbpw. BgvNbnse Znhk§Ä, amk§Ä F¶n§s\ Øntcm]tbmKw hcp¶ enÌpIÄ D]tbmKn¡p¶ Imcy¯n CXv hfsc {]tbmP\IcamWv. CXpt]mse aäp ]eImcy§fnepw (DZm:

Hcp kq¸ÀamÀ¡änse tkm¸v {_m³UpIfpsS enÌv) C¯cw enÌpIÄ D]tbmKn¡m³ Ignbp¶Xv KpWIcamImw.

t]cphnhc§fpsS (GXv sSIvÌnsâbpw) kz´amb Hcp enÌv (Custom List) Excel-

 krjvSn¡m³ Ignbpw. C§s\ krjvSn¨ Hcp enÌv ]n¶oSv Autofill- D] tbmKn¡mw. AXmbXv enÌnse BZys¯ t]cv FâÀ sNbvXv {UmKv sNbvXm _m¡n t]cpIÄ {Ia¯n Autofill Bbns¡mÅpw.

IÌw enÌv F§s\ DWvSm¡mw? hÀ¡vjoänse Hcp tImf¯n enÌnemt¡WvS t]cpIÄ ssS¸v sN¿pI. enÌn DÄs¸Spt¯WvS {Ia¯nembncn¡Ww ssS¸v sN¿p¶Xv.

t]cpIÄ DÄs¡mÅp¶ Cell range skeIvSv sNbvXv Tools-Â \n¶v Options

UbtemKv t_mIvkv FSp¡pI. AXnse Custom Lists Xpd¡pI.

* Lists t_mIvkn New List sslsseäv Bbn«psWvS¶v Dd¸m¡pI.

* skeIvSv sNbvX Range, Import List from cells F¶ t_mIvkn sXfnªncn ¡pw.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

tNÀ¡s¸Spw. ]pXnb enÌv CSXphis¯ Custom Lists F¶ t_mIvknepw sXfnbpw.

* OK sN¿pI.

UbtemKv t_mIvkn t\cn«v ]pXnb enÌv FâÀ sN¿mw. Custom List

t_mIvkn New List skeIvSv sNbvX tijw List Entries t_mIvkn ]pXnb enÌnse t]cpIÄ {Iaa\pkcn¨v ssS¸v sN¿pI. Hmtcm t]cn\pw tijw Enter

AaÀ¯Ww. enÌv ssS¸v sNbvXp Ignªm Add ¢n¡v sN¿pI.

CXpt]mse¯s¶ Xncp¯pIÄ¡mbn enkvänse t]cpIÄ FUnäv sN¿pIbpamImw.

"CXp t]mse Excel- DÅ asämcp kuIcyamWv Auto complete. Htc Umä ]e skÃpIfn BhÀ¯nt¡WvSn hcpt¼mÄ CXv hfsc {]tbmP\{]ZamWv', \oena ]dªp.

Auto complete {]mhÀ¯nIam¡m³ Tools- Options FSp¡pI. AXn Edit

Sm_v Xpd¶v Enable

Auto Complete for Cell

Values F¶Xv skeIvSv sN¿pI. skÃn Umä ssS¸v sNbvXpsImWvSncns ¡, AXv ]qÀ¯nbm ¡m³ Excel {ian¨psIm WvSncn¡pw. ap³]v F³À sNbvX hnhc§fn \n¶pamWv Cu "Dulw' Excel \S¯p¶Xv.

"Auto Complete- asämcp kuIcyw IqSnbp WvSv', \oena XpSÀ¶p.

ap³]v FâÀ sNbvX UmäIfpsS Hcp dropdown

enÌn \n¶v ASp¯ skÃnte¡v thWvSXv skeIvSv sN¿mw.' FâÀ sN¿m\pÅ ASp¯ sk skeIvSv sNbvXv ssdäv ¢n¡v sN¿pI. Dropdown

enÌn \n¶pw BhiyambXv skeIvSv sN¿pI.

Umä Xncp¯m³

"Hcp skÃn F³À sNbvX Umätbm t^mÀapetbm Xncpt¯WvSnhcmw', \oena XpSÀ¶p.

"CXn\v BZyw sk skeIvSv sN¿pI. t^mÀape _mdn AXnse DÅS¡w sXfnbpw. skÃnse Umä FUnäv sN¿m³ t^mÀape _mdn ¢n¡v sN¿pItbm F2

Io AaÀ¯pItbm sN¿pI. F´p kw`hn¡psa¶v t\m¡mw.'

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

\mw Edit tamUnemsW¶v ImWn¡m³ Ìmäkv _mdn Edit F¶v sXfnbpw.

t^mÀape _mdn Umä Xncp¯m\pw, AXneqsS \o§m\pambn, Hcp IgvkÀ sXfnbpw. skÃn Xs¶ (In-cell) FUnäv sN¿m\pÅ Hm]vj³ Tools- skeIvSv sNbvXn«psWvS¦n IgvkÀ skÃn ImWmw.

atäsXmcp t{]m{Kmantebpw t]mse¯s¶bmWv Excel-epw FUnänwKv. CXv GXv thÀUv t{]mÊdnsebpw t]mse Ffp¸hpamWv.

an¡ hn³tUmkv t{]m{KmapIfntebpw t]mse Excel-epw Edit

sa\phn Hcp Undo

IamâpWvSv. Undo Iamsâ Sp¯m F´mWv kw` hn¡pIsb¶v sa\phn tcJs¸Sp¯nbncn¡pw.

ÌmtâÀUv SqÄ_mdnse Undo _«¬ Cu {]hr¯n Xs¶ sN¿p¶p. IqSmsX, sXm«vap¼v sNbvX 16 {]hr¯nIfpsS Hcp enÌv Cu _«Wn \n¶v drop-down Bbn e`n ¡p¶p. CXn \n¶v GXv {]hr¯nbmWv Undo sNt¿WvSsX¶v sXcsªSp¡mw.

UmäbpsS Øm\amäw

"Cutting, Copying, Pasting F¶o {]hr¯nIÄ Excel- CSbv¡nsS BhÀ¯nt ¡WvSXmbn hcmdpWvSv', \oena ]dªp. "CXn\mbn FIvk ]e amÀ¤§Ä \evIp¶p. ]t£, FhnsSsb¦nepw Umä t]Ìv sN¿p¶psh¦n B skÃn ap¼p WvSmbncp¶ Umä ]ns¶ ImWnsöXv HmÀ½n¡Ww.

hen¨p \o¡Â Hcp Øe¯v \n¶pw asämcnSt¯¡v Umä amäm\pÅ Excel-se Ffp¸amÀ¤w Drag-and-drop BWv. CXn\mbn BZyw Øm\w amtäWvS td©v skeIvSv sN¿pI.

td©nsâ t_mÀUdn aukv ]nSn¨v ]pXnb Øet¯¡v {UmKv sN¿pI.

C§s\ \o§p¶tXmsSm¸w F¯ns¸Sp¶ skÃpIfpsS Øm\w Excel ImWn¨p Xcpw.

Tools- Options FSp¯m In«p¶ UbtemKv t_mIvknsâ Edit Sm_v Xpd¶v AXnse Hm]vj\pIÄ D]tbmKn¨p thWw Drag-and- drop kuIcysaSp¡m³.

skeIvSv sNbvX td©n\v Npäpw hoXnIqSnb t_mÀUÀ ImWp¶nsæn Cu UbtemKv t_mIvknse skänwKv amtäWvSnhcpw.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

CtX coXnbn Umä tIm¸n sN¿mw. Umä {UmKv sNbvXv drop sN¿p¶Xn\v ap¼v Ctrl Io AaÀ¯pI. Umä Cut sN¿pIbÃ, ]IÀ¯pIbmWv F¶v ImWn¡p¶ Hcp sNdnb ¹kv (+) ASbmfw Igvkdn\v apIfnembn sXfnbpw.

UmäbpsS Cutting, Copying, Pasting F¶nhbv¡v Io t_mÀUv tjmÀ«v I«pIÄ Word-teXp t]mse¯s¶bmWv. Ctrl+X, Ctrl+C, Ctrl+V F¶n§s\. Edit sa\phnse IamâpIÄ D]tbmKn¨pw Cu {]hr¯nIÄ sN¿mw. SqÄ_mdnse _«WpIfpw CtX tPmenIÄ¡mbn D]tbmKn¡mw.

"tN¨o, sk Cut sN¿pIsb¶v ]dªmÂ, FSp¯p amäp¶Xv sk Xs¶ bmtWm?' cXojnsâ kwibw.

"\ymbamb tNmZyw', \oena Nncn¨p. "]dªp Xcmw.' Hcp hÀ¡vjoänsâ Hcp `mK¯p\n¶pw thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶pw asäm¶ntet¡m, asämcp hÀ¡v_p¡ntet¡m Umä amäm³ (t^mÀamäpw amämw) Cutting-Dw Pasting-

Dw D]tbmKn¡mw. Cutting

F¶mWv hm¡v F¦nepw skÃnse Umä am{Xta amäs¸Sp¶pÅp. sk ]gb t^mÀam än \ne\n¡p¶p. Hcp hÀ¡vjoänse sk \o¡w sN¿m³ AXns\ delete sN¿Ww.

"AsX§s\!', tNmZyw kp\nXbn \n¶v.

"AXp ]ns¶ ]dbmw.' Hcp sktÃm tdt©m Cut sN¿pt¼mÄ AXn\vNpäpw Ip¯pIÄs¡mWvSpÅ Hcp sse³ sXfnbpw. Cut sNbvX Umä asämcnS¯v H«n¨p tNÀ¡p¶Xp hsc Excel

Umäsb icn¡pw Cut sN¿nÃ. Umä asämcnS¯v t]Ìv sNbvXm Ip¯pIÄ sImWvSpÅ sse³ A{]Xy£amIpw.

C u t t i n g -D w Pasting-Dw Ign ªmepw Umä bpsS sk sd^ d³kv ]gbXpXs ¶bmbncn¡pw.

DZmlcW¯n\v A8*B8 F¶ t^mÀape Cut

sNbvXv H8-Â Paste sNbvXmepw d^d³kv A8*B8

F¶p Xs¶bmbncn ¡pw.

tImf§fpw hcnIfpw Hfn¸n¡mw, sXfnbn¡mw. Hcp tImfw Hfn¸n¡m³

tImfw slUnwKn ssdäv ¢n¡v sNbvXp In«p¶ sa\phn \n¶v Hide

skeIvSv sN¿pI. tImfw hoWvSpw sXfnbn¡m³ Hfnªncn¡p¶ tImf

¯nsâ Ccp`mK¯papÅ tImf§Ä skeIvSv sNbvXv Hcp tImf¯nÂ

ssdäv ¢n¡v sN¿pI. sa\phnÂ\n¶v Unhide FSp¡pI.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"tN¨o, A§s\bmsW¦n Cutting-Dw Copying-Dw X½n F´mWv hyXymkw?' cXojv tNmZn¨p.

"Copying-Dw Cutting-Dw an¡hmdpw kZri amWv', \oena hniZoIcn¨p. "]t£, hyXymk apWvSv. Cut sNbvXpIgnªm Umä AhnsS ]ns¶ ImWnÃ. Copy sN¿pIbmsW ¦n Umä AhnsS¯s¶ \ne\n¡pw.

am{XaÃ, Copy sNbvX Umä F{X Øe§ fn thWsa¦nepw Paste sN¿mw.' Hcp sktÃm, tdt©m Copy sN¿pt ¼mÄ, Cut sN¿pt¼mgs¯t¸mse, AXn\v Npäpw Ip¯pIÄs¡mWvSv XoÀ¯ Hcp sse³ {]Xy£s¸Spw. CXv Umä ¢n]v t_mÀUnte ¡v \o§n F¶v kqNn¸n¡p¶p. C\n, FhnsSbmtWm Paste sNt¿WvSXv B td©v skeIvSv sN¿mw. F¶ment¸mÄ, Cut sNbvXv Paste sNbvXt¸mgs¯t¸mse, sse³ A{] Xy£amIp¶nÃ. CXnsâbÀ°w ¢n]v t_mÀUv Ct¸mgpw BIvSohv BsW¶pw C\nbpw t]ÌnwKv \S¯msa¶pamWv.

Paste sN¿m\pÅ td©v sXcsªSp¡pt¼mÄ, apgp³ td©pw skeIvSv sN¿p ¶Xn\v ]Icw, td©nsâ CS¯p aqebnse sk am{Xw sXcsªSp¯m aXnbmIpw.

tImf§fptSbpw hcnIfptSbpw IrXyamb kwJytbmÀ¯v Xs¶ Excel Paste

sN¿pw.

"Paste sN¿p¶Xv Word-tet¸mse¯s¶bmtWm tN¨o?' cXojv tNmZn¨p.

"AXmWn\n ]dbp¶Xv', Paste Iamâ v \ÂInbmÂ, ¢n]v t_mÀUn InS¡p¶ Umä skeIvSv sNbvX `mK¯v H«n¨p shbv¡pI am{XamWv Excel sN¿p¶Xv. Hcp td©mWv tIm¸n sNbvXsX¦nÂ, Paste sN¿m³ Hcp sk am{Xw ¢n¡v sNbvXmepw, Umäbv¡v Bhiy amb td©v Excel sslsseäv sN¿pw. Copy sNbvX Umäbv¡v A\pkrXamb coXnbneà tImfhpw hcnbpw skeIvSv sNbvXsX¦n Excel Hcp Error Message

ImWn¡pw.

"Htc tIm¸n Xs¶ ]e Øe¯v Paste sN¿ms\m¡ptam, tN¨o', kp\nX tNmZn¨p.

"tNmZn¨Xv \¶mbn', \oena ]dªp. "Excel- C¸Wn ]et¸mgpw Bhiyambn hcp¶XmWv.' Hscmä skÃns\ hyXykvX td©pIfnte¡v tIm¸n sN¿mw. BZyw, ]IÀt¯WvS Umä tIm¸n sN¿pI. AXn\ptijw e£yamb sk skeIvSv sN¿pI. C\n GsXms¡ td©nte¡mtWm ]IÀt¯WvSXv, Ctrl Io AaÀ¯n¸nSn¨v Ah skeIvSv sN¿pI. FÃmw skeIvSv sNbvXv Ignªm km[mcWt]mse¯s¶ Paste sN¿pI.

12 hyXykvX UmäIÄ (hyXykvX Office t{]m{KmapIfn \n¶pamImw) tiJZn

cn¨v ¢n]vt_mÀUnen«v Ah Paste sN¿m\pÅ kuIcyhpw Excel Xcp¶pWvSv.

Paste Special: hfsc {]tbmP\{]Zamb Nne Pasting kuIcy§Ä Paste Special

F¶ UbtemKv t_mIvkv hgn Excel \ÂIp¶p. CXnse Paste hn`mK¯n Cu {]tXyI Hm]vj\pIÄ e`n¡p¶p. Paste All : efnXamb t]ÌnwKv Formulas : sk t^mÀamänwKv FSp¡msX t^mÀape am{Xw Paste sN¿mw. Values : tIm¸n sNbvX t^mÀapebpsS ^ew am{Xw Paste sN¿p¶p. Comments : Ipdn¸pIÄ Hcp skÃn \n¶v asäm¶nte¡v ]IÀ¯p¶p. Validation : \ÂInbn«pÅ {]tXyI aqey\nÀ®b am\ZWvU§Ä ]IÀ¯p¶p. All Except Borders : Umä ]IÀ¯pt¼mÄ ]pXnb td©nsâ t_mÀUdn\v amäap WvSmIp¶nÃ. "Paste Special tIm¸n sN¿m\pÅ Iamân\v am{Xta _m[IamIq. hÀ¡vjo än \n¶pw Cut sNbvX Umä ]IÀ¯m³ CXp]tbmKn¡m\mhnÃ', \oena HmÀ½n ¸n¨p.

Paste Special UbtemKv t_mIvknse Operations hn`mKw, Paste sN¿pt¼mÄ \St¯WvS KWnXimkv{X {]{Inbsb´msW¶v \nÀt±in¡m\pÅXmWv.

Umä Uneoäv sN¿mw "kp\nXbtà t\ct¯ Data Uneoäv sN¿p¶sX§s\sb¶v tNmZn¨Xv', \oena XpSÀ¶p. "AXv hntijn¨v ]dbms\m¶panÃ. F¦nepw \ap¡v t\m¡mw.' Umä cWvSp hn[¯n Delete sN¿mw. H¶v, skÃnse Umäsb am{Xambn \o¡w sN¿mw. Asæn sk Xs¶bpw Delete sN¿mw.

Umä am{Xw \o¡w sN¿m³ ]e hgnIfpWvSv.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

* skÃnÂ, FUnäv tamUnÂ, kwJyIÄ \o¡w sN¿pI. (Back space, Delete

IoIÄ). * Edit sa\phnse Clear Iamâp]tbmKn¡pI. * skÃn ssdäv ¢n¡v sNbvXv t]m¸v A]v sa\phn Clear contents FSp¡pI. * ^n lm³Un CSXp`mK¯v apIfntem«v {UmKv sNbvXv skÃns\ aqSpI. Ìmäkv _mdn Drag Inside to Clear Cell ktµiw ImWmw. * skÃnse F³{Sn skeIvSv sNbvXv ]pXnb Umä ssS¸v sN¿pI. "CsXms¡ tIma¬ sk³knsâ ImcyamWtÃm!' cXojv \nÊmc`mh¯n ]dªp. "t]ms«, sk F§s\bmWv Delete sN¿p¶Xv?' "AXmtemNn¡m\pÅ tIma¬sk³kv \n\¡nÃ, AtÃ?' \oena Nncn¨p.

"Hm, Ahs\mcp ]mhw CUnbätÃ?' kp\nX CSbv¡p Ibdn.

"B t]ms«', \oena hne¡n.

Umä Uneoäv sN¿p¶Xpt]mse A{X efnXaà skÃpIÄ \o¡w sN¿p¶Xv.

ImcWw Hä sktÃm Hcp tdt©m Uneoäv sN¿p¶Xv hÀ¡vjoänsâ LS\sb _m[n¡pw. AXn\m C¸Wn¡v apXncp¶Xn\v ap¼v HcÂ]w Nn´n¡p¶Xv \à XmWv. Hcp sk am{Xambn Uneoäv sN¿p¶Xnepw t`Zw, an¡t¸mgpw, Hcp hcntbm tImftam At¸msS \o¡w sN¿p¶Xmbncn¡pw. ImcWw tS_nfpIfpw sk sd^ d³kpIfpsam¶pw XIcmdnemImXncn¡m³ CXv klmbn¡pw.

"AXnsâ kq{X¸Wn Rm³ ImWn¨pXcmw', cXojv ]dªp. "hcnbpsStbm tImf ¯nsâtbm slUnwKn (hcnbpsS \¼À, tImf¯nsâ A£cw) ¢n¡v sN¿pI.

C\n Edit sa\phn Delete FSp¡pI. t]mbntÃ?

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"AsX', \oena hnhcn¨p.

"hcntbm tImftam \o¡w sN¿p¶Xnsâsbm¸w, Xmgs¯ hcnIsf apIfnte¡pw heXp`mKs¯ tImf§sf CSXp`mKt¯¡pw Excel sImWvSphcp¶p. H¸w Xs¶ FÃm t^mÀapeIsfbpw delete sNbvXX\pkcn¨v Xncp¯pIbpw sN¿p¶p. cWvSmaXv t^mÀapeIÄ FgpXn XIcmdnemthWvS.' "AsXmcp{K³ ]cn]mSnbmWtÃm!' kp\nX AÛpXw {]ISn¸n¨p.

"tIma¬sk³kv thWsaSo, tUm¦o', cXojv Ifnbm¡n.

"CUnbänsâ tIma¬sk³kv F\n¡ntÃ', kp\nX ssIaeÀ¯n ImWn¨p.

"\nÀ¯v \nÀ¯v', \oena imkn¨p. "C\n Hcp sktÃm, tdt©m Uneoäv sN¿p¶ sX§s\sb¶v t\m¡mw.' hcntbm tImftam Uneoäv sN¿p¶ AtX {]{InbbmWv CXn\pw. ]t£, sNdnsbmcp Ipg¸w. CSbv¡p\ns¶mcp sk t]mIpt¼mÄ _m¡nbpÅ Umäsb F§ s\bmWv kÖoIcnt¡WvSsX¶v Excel-\v ]nSnIn«nÃ. A¡mcyw ]dªpsImSpt¡WvSn hcpw. sktÃm tdt©m skeIvSv sNbvXv Delete Iamâ v \ÂIpI. _m¡n skÃp Isf F§s\ kÖoIcn¡Wsa¶Xn\v Hm]vj\pIÄ \nÀt±in¡p¶ Hcp UbtemKv t_mIvkv e`n¡pw. ChnsSbpw delete sNbvXXpsImWvSpWvSmb {]iv\w XoÀ¡m³ t^mÀapeIÄ kzbw IW¡p Iq«m³ Excel {ian¡pw. F¶m Nne tIkp Ifn ]niIv ImWn¡p¶ #REF skÃn sXfnbpw. ChnsS \mw Xs¶ AXv icnbmt ¡WvSn hcpw.

" A s X m c e v ] w {]iv\amWtÃm!' kp\nX ]dªp. "Cu ]Wn Hgnhm ¡m³ {ian¡pIbmWv \ÃXv.' ]ns¶ tN¨o, Umä Uneoäv sN¿msa ¦n C³kÀ«v sN¿m\pw IgnbntÃ?' " I g n b p a t à m ! ' \oena ]dªp.

Umä XncpIn¡bämw Uneoäv sN¿p¶ AtX coXn Xs¶bmWv C³kÀ«v sN¿p¶Xn\pw Hcp hcntbm tImftam apgph\pamtbm, Hcp sktÃm, tdt©m am{Xamtbm CSbvs¡hnsSsb ¦nepw C³kÀ«v sN¿mw.

UneoänwKn F¶ t]mse¯s¶ Hcp hcntbm tImftam apgph\pambn C³kÀ«v sN¿p¶XmWv Ffp ¸amb GÀ¸mSv.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

Npcp-¡-¯nÂ...

t^mÀape _mdn Im³kÂ, FâÀ _«WpIÄ l UmäbpsS FIvk hymJym\w hyà

ambn a\Ênem¡Ww l ZimwikwJyIÄ \ÂIpt¼mÄ {]tXyI{i² Bhiyw l H¶ntesd

tImf§fnepw hcnIfnepw Htc kwJy BhÀ¯n¡m³ Umäm ^n l kzm`mhnI

hÀ²\bpWvSmIp¶ (Progression) kwJyIsf Umäm kocokneqsS FâÀ sN¿mw l koco

knsâ \nÀ®bw Step value, Stop value F¶nh hgn l BgvNIfpw amk§fpw t]mse

XpSÀ¨bmb Imcy§Ä FâÀ sN¿m³ Custom fill l 16 {]hr¯nIÄ hsc Undo sN¿m³

kuIcyw

Hcp hcntbm tImftam ]qÀ®ambpw C³kÀ«v sN¿m³, AXv skeIvSv sN¿pI.

AXn\v Delete- sNbvXXpt]mse¯s¶ hcnbpsS \¼dntem tImf¯nsâ A£ c¯ntem ¢n¡v sN¿pI. hcnbmsW¦n skeIvSv sNbvXXn\v sXm«papIfnepw tImfamsW¦n sXm«v CS¯p`mK¯pw Insertion \S¡p¶p. ]pXnb hcnbpsS (tImf ¯nsâ) NpäpapÅ skÃpIÄ t^mÀamäp sNbvXn«pÅXmsW¦n ]pXnb skÃp IÄ¡pw AtX t^mÀamäv e`n¡pw. ChnsSbpw KWnX¯nsâ ]p\xkÖoIcWw Excel \S¯pw.

Hcp sktÃm tdt©m C³kÀ«v sN¿p¶Xnepw, Delete sN¿pt¼mÄ DWvSmb sIm¨p{]iv\apWvSmIpw. sktÃm, tdt©m skeIvSv sN¿pI. Edit sa\phn Insert

IamsâSp¡pI. skÃpIÄ het¯mt«m Xmtgmt«m amtäWvSXv F¶v tNmZn¡p¶ UbtemKv t_mIvkv sXfnbpw.

Ft¸mgmWv C³kÀj³ Bhiyambn hcp¶Xv? Hcp hÀ¡vjoänsâ Hcp `mK¯v \n¶v thsdmcp `mKt¯t¡m, Hcp hÀ¡vjoän \n¶v thsdmcp hÀ¡vjoäntet¡m, Hcp hÀ¡v_p¡n \n¶v asämcp hÀ¡v _p¡ntet¡m Umä Cut sNbvtXm Copy

sNbvtXm amtäWvSn hcpt¼mgmWtÃm Cu Bhiyw hcp¶Xv. CXnsâ thKw Iq«m³ Excel-  kuIcyapWvSv. skÃpIÄ Cut sN¿pItbm Copy sN¿pItbm sNbvXm Insert sa\phnse Hm]vj³ AX\pkcn¨v Cut cells Asæn Copied cells F¶mbn amdpw. C³kÀ«v sNt¿WvS `mKw skeIvSv sNbvXv Cu Hm]vj³ ¢n¡v sN¿pI.

Cu {]hr¯nIÄ¡mbn ssdäv ¢n¡v sN¿pt¼mÄ In«p¶ t]m]v A]v sa\phnse IamâpIfpw D]tbmKn¡mhp¶XmWv. Hcp skÃnse FUnänwKv tPmen IÄ¡mbn tjmÀ«vI«v sa\phn Cut, Copy, Insert, Delete, Clear Contents XpS§nb Hm]vj³kv e`n¡p¶p.

"C\n \ap¡v Excel-sâ bYmÀ° iàn ImWmw. C¶Ã, \msf', \oena ]dªp.

]t£, \msf Rm³ DWvSmhnÃ. AXn\m aä¶mÄ. C\n DuWv Ign¨v kpJamsbm ¶pd§mw.'

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

\oena¡v Hcp \mfs¯ tPmen Ignªt¸mtg¡pw Hch[n e`n¨p. Ip«nIÄ¡pw ImÀ¯nIbv¡pw Ah[n e`n¨nsöv am{XaÃ, B Znhkw ISp¯ ]Wnbmbncp¶p.

hn³tUmkvþan apX Excel hsc ]Tn¨ ]mT§f{Xbpw {]mtbmKnIambn Iw]yq« dn Ip«nIÄ ]co£n¨p.

ASp¯ Znhkw kÔy¡v ImÀ¯nIbpw \oenabpw Ibdnh¶t¸mÄ kp\n Xbpw cXojpw A£acmbncp¶p. Ft´m IWvSp]nSn¨ `mhambncp¶p CcphcpsSbpw apJ¯v.

"Ft´m H¯ a«pWvStÃm!' \oena tNmZn¨p.

"Hs¯t¶m?' kp\nXbmWv adp]Sn ]dªXv. "s]s«¶v Ipfn¨v Im¸n IpSn¨v hm. C¶v Excel R§Ä \n§sf ]Tn¸n¡pw.' ImÀ¯nIbpw \oenabpw ]ckv]cw t\m¡n. Xncn¨p h¶t¸mÄ, kv{Io\n Hcp hÀ¡vjoäpambn Ip«nIfncphcpw A£acmbn¯s¶ Ccn¡pIbmWv.

"Cu tS_nÄ R§Ä X¿mdm¡nbXmWv,' cXojv ]dªp. "C\nbnXnsâ slUnwKpw tImfw slUnwKpw Hs¡ R§Ä at\mlcam¡m³ t]mIpIbmWv.' Format sa\phn \n¶pah³ Format Cells UbtemKv t_mIvskSp¯p.

"skeIvSv sNbvX UmäbpsS Asse³saâ v, Zm, Cu Alignment F¶ Sm_v Xpd¶v AXnepÅ Hm]vj\pIÄ D]tbmKn¨v Nn«s¸Sp¯mw. Horizontal Hm]vj³ IpdpsI

3at\m-l-c-amb IW-¡p-]p-kvXIw

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

bpÅ hn\ymk¯n\v. CXn Indent \ÂIn skÃn sSIvÌnsâ Øm\w \nÀ® bn¡mw', BËmZt¯msS cXojv ]dªp.

"At¸mÄ \n§Ä ]Tn¨p Ignªp', \oena Ahsc {]iwkn¨p. B Vertical- \nÀt±iw \ÂIn, Umäsb tImf¯n ew_am¡mw. tS_nfpIfn A¯cw tImfw slUnwKpIÄ at\mlcam bncn¡pw.' "IgnªnÃ', kp\nX \oenasb XSªp. "Cu Text control Hm]vj³ F{X {]tbmP\IcamsWt ¶m! CXn Wrap

Text, Shrink to Fit F¶nh sSIvÌv hn\ymk¯n\v hyXykvX `wKnIÄ \ÂIp¶p.' "Umäsb XncÝo\ ambpw ew_ambpw am{Xa Ã, tImtWmSptIm Wmbpw \ÂImw', \oena ]dªp. "AXn\mWv Cu Orientation Hm]vj³.

skÃn\I¯v sSIvÌv

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

F{X Un{Knbn thWsa ¦nepw CXp]tbmKn¨v Id¡mw.' CXp t]mse skÃp IÄ¡pw sk td©p IÄ¡pw `wKnbpÅ t _ m À U d p I f p w \ÂIm³ Ignbpw. Format

Cell UbtemKv t_mIvknse Border

Sm_v Xpd¶v B t]sPSp ¡pI. CXnse Line

F¶ t_mIvknse Style

enÌn \n¶v t_mÀUdn\ v CjvSs¸« ]mtä¬ skeIvSv sN¿pI.

AXn\v Xmsg color F¶ drop-down enÌn \n¶v t_mÀUdn\mhiyamb \ndw sXcsªSp¡mw.

Presets hn`mK¯nse _«WpIfn Outline thtWm, Inside t_mÀUÀ thtWm F¶v Xocpam\n¡pI. t_mÀUÀ H¶pw thsWvS¦n None ¢nIv sN¿pI.

"MS hn³tUmkpw, hntijn¨v MS Office-Dw \ÂIp¶ kuµcykwhÀ²t\m]

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

[nIÄ Word- F¶ t]mse Excel-Dw Hcp tUmIypsaâ v (ChnsSsbmcp Workbook) at\ml cam¡m³ sXsÃm¶pa à klmbn¡p¶Xv', ImÀ¯nI CSs]«p.

AXphsc FÃmw IWvSnc n ¡ p I b m b n c p ¶ p ImÀ¯nI.

"Hm, \n\¡sænepw apSn Nmbv¨pw sNcn¨pw sI«m\pw kuµcyw Iq«m \patà t\capÅp', \oena Ahsf Ifnbm ¡n.

"apSnbnÃm¯hÀ ]ns¶ F§s\ Nmbv¡m³, sNcn¡m³, sI«nshbv¡m³...!' ImÀ¯nIbpw hn«nÃ.

"sIm¨phÀ¯am\w \nÀ¯v So¨Àamsc', Kuch¯n kp\nX ]dªp. "kwKXn icnbm. Hmtcm hn`mKw F³{Sn¡pw Hmtcm tjbvUv \ÂIp¶Xv tS_nfn\v Hcp sKä¸v Xs¶bmWv.' skÃpIÄt¡m sk td©pIÄt¡m {]tXyI hÀ®§Ä \ÂImw. CXn\mbn Format Cells UbtemKv t_mIvknse Pattern Sm_v Xpd¡pI. CXn IfÀ t_mIvkn \n¶v Bhiyamb \ndhpw Pattern

t_mIvkn \n¶v skÃn\v thWvS ]mtäWpw sXcsª Sp¡mw.

Excel-2000, Personal

Toolbar Fs¶mcp Hm]vj³ Xcp¶pWvSv.

HcmÄ Øncambn D] tbmKn¡p¶ SqÄkv BWv Cu SqÄ_mdn {]Xy£s¸Sp¶Xv. ]pXnsbmcp SqÄ D]tbmKn¡p ¶X\pkcn¨v AXnsâ _«¬ SqÄ_mdn {]Xy £s¸Spw. am{XaÃ, W o r d -s e t ¸ m s e Toolbar-Ifpw sa\pIfpw http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

FÃmw Iw]yq«À D]tbmKn¡p¶ BfpsS XmÂ]cya\pkcn¨v Customize sN¿m\pw Excel-Â kuIcyapWvSv.

Tools sa\phnse Customize IamsâSp¯m Hcp UbtemKv t_mIvkv e`n¡p¶p.

CXnse Toolbars Sm_v Xpd¶pIn«p¶ t]Pn Toolbars F¶ kvIvtdmÄ t_mIvkn \n¶v BhiyapÅXv sXcsªSp¯v D]tbmKn¡m\mbn \ap¡v hn³tUmbn sImWvSp hcmw.

CXpt]mse¯s¶ Hmtcm sa\phnepw Bhiyamb IamâpIfpw Customize

sN¿mw. Customize UbtemKv t_mIvknse Commands Xpd¶v In«p¶ t_mIvkp IÄ D]tbmKn¨v s]s«¶pÅ D]tbmK¯n\mbn Iamâ v _«WpIÄ drag-and-drop

coXnbn SqÄ_mdn tNÀ¡mw.

"BsI¡qSn CsXmcp kpJapÅ GÀ¸mSmWtÃm!' cXojv Iaâ v ]dªp.

"AsX.' \oena k½Xn¨p.

"Hcp Imcyw', kp\nX ]dªp. "R§Ä DWvSm¡nb sSent^m¬ \¼dpIÄ Hs¡ bptWvSm?' ]cnlmk¨phtbmsS ImÀ¯nI tNmZn¨p.

"CtÃ, CÃ', kp\nX k½Xn¨p. "Excel {]hÀ¯\w ]cntim[n¡m\mbn sNbvsXt ¶bpÅp. Umä tN¨nbpsS C³UIvkv _p¡ntebm.' sSent^m¬ C³UIvkv X¿mdm¡nb hÀ¡v_p¡v kp\nX Xpd¶pImWn¨p.

t_mÀUdpIfpw \nd§fpw sImWvSv at\mlcam¡n. C³UIvkv IWvSv So¨Àamcncphcpw Ip«nIsf {]iwkn¨p.

"sImÅmatÃm', ImÀ¯nI ]dªp. "t]cpIÄ A£camem{Ia¯nÂXs¶. ]mSps] «ncp¶v ssS¸v sNbvXpImWpw?'

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

"aWvS¯cw ]dbmsXsâ tN¨o', cXojv ]dªp. "Excel- FÃm kq{XhpapWvSv.' "Rm³ ]dbmw,' kp\nX CSs]«p. "tN¨nbpsS C³UIvkv _p¡nsâ XpS¡w apX HSp¡w hsc¯s¶bmWv CXn FâÀ sNbvXXv F¶Xv t\cv. AXpsImWvSv cWvSmas¯bpw aq¶mat¯bpsams¡ A£c§Ä {Ia¯nÂXs¶ hcptam?' "IqSpX _p²nImWn¡WvS', ImÀ¯nIbv¡v CtaPv hosWvSSp¡Wambncp¶p.

"AXn\mWv Data sa\phnse Sort UbtemKv t_mIvkv. t_mIvknse Ascending _«¬ skeIvSv sNbvXm A

apX Z hscbpÅ {Ia ¯n sSIvÌv kÖoIcn ¡pw Excel. Descending

_«¬ skeIvSv sNbvXm Z apX A

hscbpw.' "At¸mÄ hnhcap WvSv', Ifnbmbn cXojv ]dªq.

"t]mSm DWvS¡®m.' "Cu ImÀ¯nIbpw ]ntÅcpw Hcp t]msebm WtÃm!' \oena ]cmXn ]dªp. "Excel-sâ KpW §Ä C\nbpapWvSv.' Umä F³À sNbvXp Ignªv Insert sa\phnse Function UbtemKv t_mIvkv D]tbmKn¨v Im¡ptejsâ hnhn[ `mK§fnse {]iv\§Ä ]cnlcn¡mw. Financial, Math & Trig. (KWnXhpw {XntImWanXnbpw), Statistical, Logical F¶n§s\ hnhn[ hn`mKw [À½§Ä Function Category-bn DWvSmIpw. CXn \n¶v BhiyapÅXv skeIvSv sNbvXm Function Name t_mIvknÂ, B {]tXyI IymäKdnbpsS {]hr ¯nIÄ sXfnbpw. At¸mÄ e`n¡p¶ UbtemKv t_mIvknepsS {]iv\]cnlmcw £n{]km²yw.

FIvkensâ At\zjWw Hcp skÃntem t^mÀapebntem sk sd^d³kntem td©v \ma¯ntem DÅ GsXmcp sSIvÌv `mKhpw At\zjn¨p IsWvS¯mw. IsWvS¯n¡gnªmeXv Hmtcm ¶mtbm, Replace Iamâp]tbmKn¨v HäbSnt¡m amämhp¶XpamWv. Hcp hÀ¡vjoäv apgph\ptam, Hcp hÀ¡v_p¡nse apgph³ joäpIfptam Excels\ s¡mWvSv At\zjn¸n¨v Bhiyamb sSIvÌv `mKw IsWvS¯mw. Hcp hÀ¡v_p¡v apgph³ sXcbm³, BZyw AXnse hÀ¡vjoäpIsf {Kq¸v sN¿Ww. {Kq¸v sN¿m³ BZyhÀ¡vjoäv skeIvSv sNbvXv, Shift Io AaÀ¯n¸nSn¨v Ahkm\ hÀ¡vjoäpw skeIvSv sN¿pI.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

skÀ¨v \S¯p¶Xv C{]Imcw 1. hÀ¡vjoän apgph³ skÀ¨v \S¯m³ Hscmä sk skeIvSv sN¿pI; Hcp td©v skÀ¨v sN¿m³, B td©v skevIvSv sN¿pI. 2. Edit sa\phn Find FSp¡pI (Ctrl+F IoIfpw D]tbmKn¡mw). Find UbtemKv t_mIvkv e`n¡p¶p 3. Find What F¶ t_mIvkn IsWvS t¯WvS sSIvÌv `mKw  ssS¸v sN¿pI. 4. \ncIÄ (Rows) A\pkcn¨pw tImf§Ä A\pkcn¨pw skÀ¨v sN¿m³ Find- Hm]vj \pWvSv. 5. Look in Hm]vj\n F³{Sn \S¯pI. CXn Aev]w {i² \ÃXmWv. t^mÀapeIÄ, aqey§Ä (values), comment

F¶nh Look in-Â \ÂImw. 6. Search-\v IrXy

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

amb Hcp ^ew (match) Xs¶ thWsa¦n Match

Case skeIvSv sN¿pI. ChnsS, \mw At\zjn¡m³ ]dbp¶ sSIvÌnsâ AtX Case (upper/

lower) DÅ am¨pIfm bncn¡pw Find

IsWvS¯pI. 7. Hcp skÃnse Umä b{Xbpw IsWvS ¯m³ Find Entire

Cells Only sN¡v sN¿pI. 8. At\zjn¡m\mhiy s¸« sSIvÌv IsWvS¯nbmÂ, FIvk AXv sslsseäv sN¿pw. C\n skÃn ¢n¡v sNbvXv, thWsa¦n UmäXncp¯mw. Asæn Replace _«¬ D]tbmKn¨v AXns\ amämw. 9. CtX sSIvÌv C\nbpw FhnsSsb¦nepw DsWvS¦n IsWvS¯m³ Find Next ¢n¡v sN¿pI. 10. At\zjW^ew Xr]vXnIcambn e`n¨m Close.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

sSIvÌv amä Find UbtemKv t_mIvkp]tbmKn¨v IsWvS¯nb sSIvÌns\ Replace _«¬ D]tbmKn¨v amämw. CXv Find-eqsSbÃmsXbpw sN¿mw. Edit sa\phnse Replace

Iamtâm, Ctrl+H IoItfm D]tbmKn¨pw sSIvÌv amämw. Replace t_mIvkn Find-teXp t]mse Look in Hm]vj³ CÃ. t^mÀapeIfntebpw Øncaqey§fntebpw (Constant values) sSIvÌv `mK§sf IsWvS¯n amäp IbmWv Replace sN¿pI. Hcp IW¡pIq«ensâ ^es¯ IsWvS¯mt\m amämt\m Replace-\v IgnbnÃ. skeIvSv sNbvX HäskÃnse sSIvÌv Replace D]tbmKn¨v amämw. Asæn Replace All _«Wp]tbmKn¨v Hcp hÀ¡vjoänepÅXp apgph³ amämw. amtäWvSXmb sSIvÌv `mKw C\nsbmcnS¯pansöv h¶m Excel A¡mcyw Adnbn¡pw. At¸mÄ Close FSp¯v skÀ¨v Ahkm\n¸n¡mw. FIvskÃnsâ kvs]ÃnwKv amÌÀ thÀUnset¸mse, A£cs¯äpIÄ At\zjn ¨p IWvSp]nSn¡p¶ Hcp Spell Checker FIvkenepw DWvSv. Hcp hmt¡m, Hcp sSIvÌv F³{Sntbm, hÀ¡vjoäv apgph\ptam Bhiym\pkcWw CXv ]cntim[n¡pw. Tools sa\p hgntbm F7 D]tbmKnt¨m Spell

Check FSp¡mw. Hscmä sk skeIvSv sNbvXv hÀ¡vjoän apgh³ ]cntim[\ \S¯mw. Hcp td©n am{XamWv ]cntim[\ \St¯WvS sX¦n B td©v am{Xw skeIvSv sN¿pI. Hcp skÃnse am{Xw sSIvÌv F³{Sntbm Hscmä hmt¡m thWsa¦nepw Spell

sN¡v sN¿mw. CXn\mbn Edit Mode FSp¡Ww. t^mÀape _mdn ¢n¡v sNbvtXm F2 Io AaÀ¯ntbm Edit tamsUSp¡mw. ]cntim[nt¡WvS hm¡v skeIvSv sNbvXv Tools- Spelling FSp¡pI. FIvkensâ Spelling UbtemKv t_mIvkv Word-tâXn\v kZriamWv. ]cntim [n¡p¶ hm¡v sXfnª t_mIvkn\v Xmsg FIvkensâ \nÀ±njvS]Z§Ä ImWmw. Ignore, Ignore All, Change, Change All, Add, Autocorrect XpS§nb Hm]vj\pIÄ ChnsS bpapWvSv.

http://www.geocities.com/bluemangoaz

 http://bluemango.50webs.com/

hÀ¡vjoäpIÄ \o¡w sN¿pI, tNÀ¡pI Hcp hÀ¡v_p¡n Default Bbn DÅXv aq¶v hÀ¡vjoäpIfmWtÃm! CXn hÀ¡vjoäv C³kÀ«v sNbvXv _p¡nsâ I\wIq«mw. \o¡w sNbvXv I\w Ipd¡mw. hÀ¡v_p¡n \n¶pw joäpIÄ \o¡w sN¿m³ joäpIÄ skeIvSv sN¿pI. BZyw Hcp joäv Sm_n ¢n¡v sNbvXv, Shift Io AaÀ¯n ASp¯ joäv Sm_v ¢n¡v sN¿pI. Edit sa\phn Delete- Sheet FSp¡pI. Asæn skeIvSv sNbvX Hcp joäv Sm_n ssdäv ¢n¡v sNbvXv In«p¶ sa\phn Delete FSp¡pI. skÃpIÄ \o¡w sN¿pt¼mÄ kw`hn¡p¶Xpt]mse joäpIÄ \o¡w sN¿pt ¼mgpw, ASp¯ joäpIÄ hnShv \nI¯m³ CSt¯m«v \o§p¶p. F¶mÂ, skÃp IÄ Uneoäv sNbvX tijw, CSt¯m«v \o§nhcp¶ skÃpIfpsS hnemkw amdp¶ Xpt]mse joäpIÄ ]p\À\maIcWw sN¿s¸Sp¶nÃ. hÀ¡v_p¡n \n¶v Sheet 2

\o¡w sNbvXm ]ns¶bm _p¡n joäv 2 CÃ. A{XXs¶. hÀ¡v_p¡n ]pXnb joäpIÄ tNÀ¡m³, H¶ntesd joäpIÄ tNÀ¡pIbmsW ¦nÂ, Ah skeIvSv sN¿pI. Insert sa\phn Worksheet skeIvSv sN¿pI. Default Bb Hcp hÀ¡vjoämWnSp¶sX¦n AXn\v hyXymksam¶pw ImWnÃ. AXsæn skeIvSv sNbvX joäv Sm_pIfnsem¶n U_nÄ¢n¡v sNbvXv In«p¶ sa\phn \n¶v Insert FSp¡pI. e`n¡p¶ UbtemKv t_mIvkn GXpXcw hÀ¡vjoämWv CtSWvSXv F¶v Xocpam\n¡mw.

Npcp-¡-¯nÂ...

hÀ¡v_p¡v at\mlcam¡m³ Format cells UbtemKv t_mIvkv D]tbmKn¡pI l slUnw KpIÄ s\SpIbpw IpdpsIbpw CSmw l skÃpIÄ¡pw td©pIÄ¡pw t_mÀUdpIÄ

\ÂImw l tamSn]nSn¸n¡Â Word-teXn\v kZriw l skÃpIÄ¡v \ndw \ÂImw l

ImtWWvSXv IsWvS¯m³ FIvken Find kuIcyw l hÀ¡v_p¡n apgph³ Search

\S¯n thWvSXv IWvSp]nSn¡mw l Find sNbvX sSIvÌns\ amän asäm¶hnsS sh¡m³

Replace _«¬ l FIvken\papWvSv kvs]ÃnwKv ]cntim[I³