`mKw 4

Fw.F-kv. FIvk

AXn-hn-]p-e-amb

IW-p-]p-kvXIw

l koKWnX sRmSnbnSbn \Smw l

l hv_pv, hvjov, skpI l

l IWsgpn\v FfphgnI l

l hv_pn\v tamSntbImw l

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

]pXnb t{]m{KmamWv ]Tnm t]mIpXv FXns {Xnnembncpp cXojpw kp\nXbpw. AXn\m Xs km[mcW ImnI hcpXn\v apmbp Iw]yq thecsmpw Ah apXnncpn. ImnI hcptm Iw]yq dpw {]ndpsams "HmWm'n, kvIq hntijhpw ]dncnpIbmbncpp Ccphcpw. "Fm, Cv IgpXbpw hnUvVnbpw CSnbpw sXmgnbpsampanmsX \ Ipn IfmbncnpXv?' IS]mtS ImnI tNmZnp. "Hm, Hpan,' kp\nX ]dp. "R Asænepw \ IqpImct?' "Ipdp kwkmcw, IqSpX Azm\w', cXojv CSbvv Ibdn. "Cv ]pXnb t{]m{Kmat?' "hphv ]nmcntm Iev]nm\pw XpSn,' ImnI ]cn`hw t]mse ]dp. "cmhnse apX sshIptcw hsc Hm^okn t{]m{Kmw FgpX, ky Ignm hon t{]m{Kmw ]Tnn. Fssbmcp hn[ntb! B K^pImc sInbh\msWn `mcysbpdnv hnNmchpan.' "\ncmibmtIWvS, tNo. FsmWpXv Ahs\mWpXn\v Xpeyat?' cXojv Nncnp. "FSm DWvSm, acaWvSm, \o apdotdnsmptmSm?' ImnI Ahs\

FIvk FIvkkv

1

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

ASnm sNp. AhfpsS ssIbn IbdnnSnv kp\nX ]dp: "tNo, Ahs\ hnSv... ]mhw CUnbv. \apv ]pXnb t{]m{Kmw ]Tnmw.' "icn, HcpnsmpI', ImnI Iw]yqdn\v apn hncpp. "PmeI cn]mSnbpw Fgppw Aev]kzev]w Nn{X WnIfpsams \ ]TnpIgnp. C\n \apv Aev]w IWp Iqepw IWsgppw AuWvSv amt\Pvsapw ]Tnmw.' "Atm! Zm IWv hoWvSpw', IcbpXp t]mse cXojv ]dp. "kvIqfn Xs B \ocmfn shdpsX hnSp n. Ctm ChnsSbpw.' " ` b m s X S m tamt\. FIvk F IWsgppImcs coXnI GXp aWvS\pw

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Ffpw ]nSnInpXmWv. icnpw User-friendly. Asæn ]mwmn Xnap n IWv IS F\nv FIvkens\ CjvSsSm ]ptam?' "Excel, Office-2000 ]mtPnse Hcp t{]m{KmamsWt tNn ]dXv?' kp\nX tNmZnp. "AsX. \apv XpSmw. XpStWvSnSv XpSmhpXmWv.' Start sa\phn, Programs- Microsoft Excel FSpv Excel Bcw`nmw. Hm^okv tjmvIv _mdn \npw Excel Xpdmw. Excel Xpdv hv Bcw`npIgnbptm Windows- HmSp GXv \ t{]m{Kmapw t]mse D]tbmKnm FfpamWnsXv a\nemIpw. File->Save tkhv sNpw; Edit->Copy ]IsSppw; Edit->Paste t]v sNpw. As\ Fmw Ffpw. Excel ASbvm File- Exit skeIvSv sNpI. Excel hntUmbn ssSn _mdnse Close _ nIv sNbvXpw Exit sNmw.

hv _pv, hvjov, sk

"Word- \ tUmIypsa v, t]Pv FsmsbmWv ]dncpXv,' ImnI XpSp. "Excel- hmpIġv Aev]w amapWvSv.' Excel- tUmIypsans t]cv Workbook FmWv. AuWvSns taipds IWp]pkvXIfnt? AXpt]mses, ]e t]PpI DXmImw Hcp hv _pv. Workbook F IWp]pkvXInse Hmtcm t]Pnt\bpw Worksheet FmWv ]dbpI. hvjonemWv \mw ]WnsbSppI. Excel hntUmbnse ]e Lfpw av t{]m{KmapIfntetmsesbmWv. sa\p_mdn\v Xmsg, Excel tPmenmhiyamb _WpI D cWvSv Sq_mdpI ImWmw. Excel-s {][m\`mKw, hvjonse hv Gcnb tImffpw hcnIfpw \nd XmWv. tImffneqsSbpw hcnIfneqsSbpw \om cWvSv kvt{Im _mdpIfp WvSv. Excel Workbook-, ASnm\]cambn tPmenI sNpXv Worksheet- BsWv ]dtm! tImffpw hcnIfpw \nd CXv \mnse IWnamcpsS AuWvSv ]pkvXInse XmfpI t]mesbmWv. 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 hv_pn aqv hvjopI BWv DWvSmIpI. IqSpX hvjopI Bhiysan tNmw. Xpdphcp Hmtcm tUmIypsan\pw, Document 1, Document 2 Fns\ Word t]cv sImSpncpXpt]mse, Default-

Hcp hv _pnse hvjopIġv Sheet 1, Sheet 2 FmWv t]cv. Hmtcm hv jonsbpw t]cv jon\v Xmgs Sm_pIfn ImWmw. Xpdncnp jons t]cv sXfnncnpw. Dtinp jov Xpdm, B jons Sm_n nIv sNpI. Sm_pIfpsS CSXp`mKv ImWp kvt{Im _m D]tbmKnv Sm_pIfneqsS thKn \omw. Hcp hvjon\v {]kamsbmcp t]cv \Imw. B Sm_n Un nIv sNbvXv t]cv sImSppI. "hv jon \ndsb hcnIfpw tImffpamWtm!' ImnI ]dp. "Cu hcnIġv Fw CnpWvSv. Hcp hv jon BsI F{X hcnIfpsWvS dnbmtam? Aw hnScpXv 65,536. km[mcWbmbn CXn 2627 Fta hntUmbn ImWm Ignbq. tamWndns sdkeyqj amdpX\pkcnv CXn amw hcpw. tImfġv A, B, C, D Fns\ Ac \InbnpWvSv. F{X tImf fmWv Hcp hv jonsetm? 256. Cwojv Acamebn 26 Acft Dq. Z F tImfw Ignm ASphbvv AA, AB, AC Fns\bmWv t]cp I.' tImffpw hcnIfpw tNv jonse hv Gcnbbn \nd n c n p I n I v skpI (cells) Fv ]dbpp. A c f p w A f p w t^mapeIfpw FmsagpXpXv Cu skpIfnemWv. tImf ns t]cpw hcn

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

bpsS t]cpw tImHmUnt\pIfmbn FSpmWv skns\ hnhnpI. B20

Fm B tImfhpw 20mw hcnbpw tNpWvSmIp sk. CXv BZys hv jons Imcyn. hv _pnse asmcp hv jonse Hcp skns A{Uv Sheet 3! B22 FmsWn, B sk aqmas jon B tImfhpw 22mw hcnbpw tNpWvSmIpXmWv Fw. asmcp hv _pnse Hcp sk A{Un\v apn B hv _pns t]cpWvSmIpw. (Test.xls) Sheet 3 C25 F A{Unsbw Test.xls F hv _pnse aqmw jon C tImfhpw 25mw hcnbpw tNpWvSmIp sk FmWv. "CsXms ]pdwImgvNbpsS ImcyfmWv,' ImnI XpSp. "Cu skp Iġpw hvjopIġpw hv _ppIġpsams ]pdIn Excel-s A]mc inbp IWpq b{apWvSv. taipdncnp ImIpte FSp m \apv thWvSkabnepw F{Xtbm Npcpnb t\cw sImWvSv \psS Bbnc Wmb IWpIsf Excel NnsSppw.'

Excel PmeInse ]cyS\w

sa\p IampIfpw Iot_mUv IpdpphgnIfpw, tjmvIv sa\pIfpw, t^mape _mdpw mkv _mdpw D]tbmKv Excel-ambn \mw Bibhn\nabw \S pp. IampI {][m\ambpw cWvSv hgnIfneqsSbmWv sa\p_mdpw tjmv Iv sa\phpw. Nne IampIġv Iot_mUv tjmvIpIfpWvSv. DZm: tkhv sNm, Ctrl+S, tImn sNm Ctrl+C. tjmvIpI sa\phnse IampIsmw tcJs Spnbncnpw. Hcp skntem, Nmntem, Sq_mdntem atm ssdv nIv sNpt m tjmvIv sa\p e`npp.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

t^mape _m hvjonse hv Gcnbbvv sXmpapIfn Sq_mdn\v sXmv XmsgbmWv t^mape _m. Excel-se cWvSv {][m\ [ CXv \nlnpp. 1. Igvk Ccnp skn Um tNm ChnsS ssSv sNbvXm aXn. Um ChnsS Xncpm\pw Ignbpw. 2. Atm tPmen sNp skn FmsWXv t^mape _mdn sXfnbpw. hv jontem, {]nuntem t\mn Hcp sknse aqeyn\v ]pdInse t^mape Xocpam\nm Ignbn. AXn\m Excel- tPmen sNptm CXv t^mape _mdn hyambncnpw. t^mape _mdns CSXphimWv Name

Box. CXn ]e t]cpIfpw sk A{UpIfpw sXfnphcpw. 1. Igvkdncnp skns A{Uv; 2. Hcp \nc skpIġv aosX Drag sNptm, hcnIfptSbpw tImffptSbpw Fw; 3. skeIvSv sNbvX t{UmbnwKnstbm Nmns tbm t]cv Fnhsbms t^mape _mdnse Name

Box- sXfnp \n¡pw. skpI D]tbmKnm Excel-se Hcp sk skeIvSv sNptm AXv Active BIpp. AXn\v Nppw Inbp Hcp t_mU hcpp. skeIvSv sNbvX skns hcn\dpw tImfwsedpw sXfnp \n¡pw. skn Fsnepw F{Sn DsWvSn AXv t^mape _mdn sXfnbpw. Active Bb sknte Um FgpXm\mIq. Hcp skns\ ]e hn[n skeIvSv sNmw. * skn aukv nIv sNpI. * Iot_mUnse Arrow IoI D]tbmKnv skn \npw skntev \opI. * Edit sa\phn Go To FSppI. (F5 Iobpw Ctrl+G-bpw CXn\mbn D]tbmKnmw). Go To UbtemKv t_mIvkv e`npw. GXv skntemtWm t]mtIWvSXv B skns A{Uv (DZm: P 1000) Reference- ssSv sNpI. hvjon Zriyam Hcp skntev t]mIm Cu coXn klmbIcamWv. * Hntesd skpI (Hcp \nc Range) skeIvSv sNm AhbneqsS aukv {UmKv sNpI. Shift Aan, Arrow Io D]tbmKnpIbpw sNmw. * Hcp Range-s hnemkw ImWnpXv AXns CSXvapIfnsebpw heXvIogv`mKtbpw skpI shmWv (DZm: A1:K10). Hcp Range-s ske Ivj Hgnhmm, asmcp skn nIv sNbvXm am{Xw aXn. Go to special

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Umbpw t^mapebpw FgpXm "ApXsSmdmbn IpnItf', \mSIob kzcn ImnI ]dp. "{Xn Snnp Excel ApX hcm\ncnp tXbpp. Ctm, skn Umbpw t^mapebpw FgpXpXv Fs\sbp ]dp Xcmw. "Hcp tImfn 65,536 skp Ifpw Hcp hcnbn 256 skpIfpw DsWvSv Rm t\cs ]dtm! AXv shv, {XnSnnp Hcp kq{Xw Rm Aev]kab n\pn ImWnpXcmw.' Hcp skn F{X IymcIvSdpI Enter

sNmsatm? 32000-ntesd. Hcp t^mapebn F{X IymcIvSdpI hscbm Imsatm? 1024 hsc. Hcp skn Um sbgpXn Enter Aangnm UmbXn Ddp Ignp. Enter Aap Xn\p apv, Um ambvp Ifbm Esc Io AapI. Hcp tPmen sNbvXv Ignv, AXv Dt]nm Edit- Undo skeIvSv sNpI. Sq_mdnse Undo _Wpw D]tbmKnmw. Undo-hnse drop-down env D] tbmKnv Ahkm\ambn sNbvX 16 {]hnI hsc Undo sNmw. Undo sNbvX Hcp {]hrn hoWvSpw C^IvSohmm Edit->Repeat FSppI. Umbpw t^mapebpw FgpXp kabv skns kucyspdnv thhem XnstSWvS. t^mamnwKv ]ns sNmw. "Ctm ]cn]mSn ]Tntm!', ImnI ]dp. "C\n Excel-s ImIptej ]h {]mtbmKnIambn ]cntim[nmw. cXotj, A1 sk skeIvSv sNbvXv AXn 65536 Fv Enter sNv. Enter Aan Igvk Xmgs skn FnpI. C\n A2-hn 256. CXv Excel hvjonse hcnIfp tSbpw tImffptSbpw FamWv. Enter Hcn IqSn AapI. "C\n A3 skn =A1*A2 F t^mape ssSv sNpI. Equal (=) ASbmfw CSm adcpXv. \{X Nnw (*) KpW\{Inbbvp {]XoIamWv. Enter Aantbv. A3 skn Ctm FmWv ImWpXv? 16777216 At? AXmbXv Hcp hv jon 167 e ntesd skpI DsWvSv' "tm!' ApXkzcw hnZymnI Ccphcn \npw GIImemWpWvSmbXv. C\n Excel-s hv ]h A1, A2

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

t\mm\p asmcp ]coWw \Smw. sk FUnv sNp hnZybmWnXv. A3 sknse t^mape amn Hcp hv _pn F{X sk DsWvSv IWvSp]n Snmw. * A3 skn, AXnse Um FUnv sNm\mbn, Un nIv sNpI. * t^mapebpsS Ahkm\n Insertion Point hcpm End Io AapI. Fnv *3 ssSv sNpI. * Enter AapI. * A3 sknse dnkīv t\mpI50331648. "Hcp hv_pnse skpIfpsS Fsa{X?' ImnI tNmZnp. "hfsc Ipdhv, At? Av tImSnbne[nIw!' Excel-s tijnbpsS cpNnbdnbm asmcp ]coWw FSpmw. A1, A2 skp Ifnse kwJyI amn t\mpI. A3 sknse KpW\^ew amdnbXv {inm t]mepw \apv t\cw Inn. A{X s]smbncn pw amw.' Hcp t^mapebpambn _sSp Um a m d p X \ p k c n v t^mape ]p\KWn m Excel-\v Ignbpp. CsXmcnS, Hcp hv_pnse Hmtcm t^mapebnepw Cu doIm¡ptej \S pp. UmIfpw t^mapeIfpw AS p BbncWn\v skpIfn Cs\ IWp Iq \Sp Imcyw BtemNnpI (sknse Unkvt, AXnse Umsb _m[n msX, amm Ignbpw). * A1, A3 skpI skeIvSv sNpI. A1 cell- \nv aukv sImWvSv A3 hsc {UmKv sNpI. * skeIvSv sNbvX skpIfn FhnsSsbnepw ssdv nIv sNpI. tjmv Iv sa\yphn \nv Format Cells FSppI. Format Cells UbtemKv t_mIvkv Xpdpp. * Number F Sm_v nIv sNpI. CXn ske\pI \Sptm sample

t_mIvkn\Iv \ sXfnbpXv {inpI. * Category enn Number skeIvSv sNpI. Undo

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

* Use 1000 Separator F check

box nIv sNpI. Decimal place- "]qPyw' CSpI. * OK nIv sNpI. * A1, A2, A3 skpIfn 1000\v taep kwJyIfpsS Unkvt t\mpI. 1000sf thXncnp tIma ImWmw. DZm: 65,536. ]t, Cu amw bYm\ dns\ _m[nn. Unkvtbn am{XamWo amw. hyambdnbm Hcp skn nIv sNbvXv t^mape _mdn t\mpI. AhnsS sXfnbp kwJybn tIma DWvSmhn. kwJyIsImWvSp Cu Ifnn Sbn Nne skpIfn Nnetm # # # F ASbmfta ImWq', ImnI ]dp. "]t, `bstSWvS. kwJyb{Xbpw ImWnm skn\v hoXnbnm XpsImWvSmImanXv. Format amn, skns hoXnIqntbm sNdnb t^mWvSp]tbmKntm Cu {]iv\w ]cnlcnmw.' Hmtm ImIptev skeIvSv sNbvXncnp skpIfnse kwJyIfpsS XpI Unkvt sNm\mbn Hcp henb kuIcyw Excel-\pWvSv. CXmWv Auto Calculate. B4 apX B9 hscbp skpI skeIvSv sNbvXncnptm (B4:B9) B Bdv skpIfnse kwJyIfpsS XpI (Sum =) Status bar- {]XysSpw. sNtWvS tPmenbpsS t^mape FgpXmsXs XpI ImWm\p Ghpw \ Ffp hgn CXmWv. (Auto Calculate-

C\nbpw kuIcyfpWvSv. Auto

Calculator Cntdn nIv sNbvXm Inp tjmvIv sa\p D]tbmKnv, IWpIqens coXn ammhpXmWv.)

Excel-se bm{XI

Excel hvjov Hcp ]mcmhmcamsW v a\nembnt? ImnI ]dp. AXns Hcp sNdnb `mKw am{XamWv \mw ImWpXv. hvjons asmcp `mKtv \om AhnsS Hcp sk skeIvSv sNpItb thWvSp. AXn\v autkm Iot_mtUm D]tbm Knmw. Asæn AXn\mbn Iampap WvSv. Format Cells

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

skneqsS \om * Hcp Arrow Io AapI * kvt{Im _mdns cWvSp Arrow-

Ifn GsXnepsam cw nIv sNbvXv AXv NqWvSp `mKt v Scroll

sNmw. * Hcp sk skeIvSv s N p I . Iot_mUnse Scroll Lock

AapI. ske Ivj amdmsX s hv jonepsS \om kvt{Im Arrow IoI D]tbmKnmw. * aukn\v kvt{Im ho DsWvSn AXp]tbmKnv hntUmbn kvt{Im sNmw. kv{Io\neqsS \om * Hmtcm kv{Io apIfntebvtm Xmtgbvtm \om Page Up, Page Down

IoI. * Scroll Box _Wv ]pdv kvt{Im _mdn nIv sNpI. * Scroll Box {UmKv sNpI. Scroll box {UmKv sNptm \n FnsSp tImfhpw hcnIfpw sXfnbp Hcp Scroll Tip ImWmw. hvjopI amm hntUmbpsS Iogv`mKs Sm_pIfn nIv sNbvXv Bhiyap hv jov FSpmw. Ctrl+Page Up, Ctrl+Page Down IoIfpw Cmcyn\mbn D]tbmKnmw. IpXnpNm ]etmgpw kv{Io\n Zriyam Hcp skntetm Range-tebvtm \apv NmtSWvSn hcpw. CXn\v Go To UbtemKv t_mIvkv FSpmw. (Edit-Go To). UbtemKv t_mIvknse Go To enn \nv t]mtIWvS Range skeIvSv sNpItbm, Reference box- A{Uv ssSv sNpItbm sNmw. Formula Box-se Name Box D]tbmKnpw Ccw Nmw \Smw. Name box- Hcp hnemktam Range Name-Hm ssSv sNbvXv Enter Aanbm aXn. CXn\mbn t_mIvkns drop-down enpw D]tbmKnmw.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

* Home Io Aanbm, tPmen sNp hcnbpsS XpSn Fmw. * Ctrl+Home D]tbmKnv \nehnep hv jons A1 sknsemw. * Ctrl+End AapI. sXmpapv tPmen sNbvX tImfnsebpw hcnbnsebpw sknsemw. End Aanb tijw Home Aanbmepw CXp Xs ^ew. * End Aan Enter sNpI. tPmen sNbvXpsImWvSncnp hcnbn Ahkm \ambn D]tbmKn sknsemw.

hv_pv amm

"Word- Htc kabv ]e tUmIypsan tPmen sNpXpt]mse, Excel-

Htc kabv ]e Workbook-Ifn tPmen sNmw', ImnI ]dp. "hntUm I amdp ]Wnt]mse XsbmWv hv_ppI amdpXpw.' * ASp hv_pv kv{Io\n ImWm\psWvSn AXn nIv sNpI. * Window sa\phn \nv Bhiyap hv_pv skeIvSv sNpI. * Ctrl+F6 AapXv ASp hntUmbntev t]mIm klmbnpp. "Excel-eqsS bm{X sNm\p am CsXmsbmWv. C\n \apv Sq_mdp I D]tbmKnpXv Fs\bmsWv t\mmw ]Xnhv Imn ptijw.' ImnI ImnsbSpm apdnhnpt] mbn.

Sq_m D]tbmKnpXv

I m n b p a m b n ImnI hcptm kp\nXbpw cXojpw Excel-

s ImIptej ]h ]cntim[npsIm WvSncnpIbmbncpp. "AXv ]noSmImw. \msf sshIov Rm hcpXn\p apv CjvSw t]mse kabapWvStm! Ctm \apv Sq_mdp I t\mmw,' ImnI ]dp. Excel 2000 shjt\msSmw h Hcp ]pXnb Hm]vj\mWv Personal Sq_m. Hcm IqSpXembn D]tbmKnp Sq_mdpIfpsS ]nIbmWnXns ASnd. Standard

Sq_mdnsebpw Formatting Sq_mdntebpw _WpI Cu Sq_mdn ImWpw. Sq_mdn Fm _WpIfpw Hnv \ncm thWvS eanmXpsImWvSv, IqSp Xembn D]tbmKnp SqfpIfmbncnpw Personal Sq_mdn ImWpI. AXn \m¯s Personal Toolbar-se Unkvt sFwkv h\pkcnv amdnsmWvSncnpw. http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Bhiyap _ Sq_mdn ImWpnsæn More Buttons _ nIv sNpI. Standard, Formatting Sq_mdpIfn ImWp Personal Toolbar D]tbmKw \nan. Standard, Formatting Sq_mdpI cWvSv \ncIfnembns display

sNmhpXmWv. Personal Toolbar- FhnsSsbnepw ssdv nIv sNpI. Customize UbtemKv t_mIvkv e`npp. UbtemKv t_mIvknse Options Sm_v skeIvSv sNbvXv B t]sPSppI. Standard and Formatting Toolbars Share One Row FXns skeIvj \ow sNpI. OK nv sNpI Standard, Formatting Sq_mdpI IqSmsX ]nsbpw Sq_mdpI DWvSv FIvken . ChsbSpm View sa\phn Toolbars skeIvSv sNpI,

sl]v e`nm

aqv hn[nep Help, Excel 2000 hmKvZm\w sNpp. Office Assistant: Word-tetmse Hcp "Indp' IYm]m{Xw tNmZyġv icnbp cw Xcpp. Help Topics: Excel-s\pdnp hnhc ASp AkwJyw t]PpI. DShpw kqNnIbpw hgn CXv e`npw. Help Topics e`nm F1 AapI. "C\n bYm tPmenbntev', ImnI ]dp. "Excel D]tbmKntWvS hn[w \n a\nemngnp. C\n Um F sNm\pw FUnv sNm\pw \msf ]Tnmw. Cs\nv Hm^okn \np Aev]w tlmwhpWvSv. Good

Night' "KpUvss\v, tNo.'

 

Npcp--n...

F{X koamb FuWvSpI kqnm\pw MS Excel l Word-s\tmses.D]tbmKnms\fpw Excel l FIvk hvjov AXnhn]pew l skpIġv A{U

pI tImfhpw hcnbpw kwKanpX\pkcnv sk A{Uv l IWpIġv

t^mape l skpIfnse {]hrnI Atm t^mape _mdn ImWpI l

FIvk IWpIqepI anthKn \Spp l skpIfpsS Range skeIvSv

sNmw, AXn tPmensNmw

 

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

FIvk hvjon IfnIfpw IšfnIfpambn CcnpIbmbncpp kp\n Xbpw cXojpw. i_vZw tIv hmXn¡tev t\mnbtm Ah ApXsp.

ImnIbpsS IqsS asmcm. ImnItbmfw Dbcw, GXmWvStX XSn. \oe Pokv. SIvC sNbvX, tImfdnm sadq Sojv. BWpsftmse t{Imp sNbvX apSn. tXmfv XqnnSp _mKv. Imen kvt]mvkv jq. hbv 15\pw 25\pw CSbvv FhnsSbpamImw. Napsmcp kpcn. ISbn. (cXojns a\ n Iw]yq cwKphscmw ISmcmWv). ImnI ]pXpapJs ]cn NbsSpn.

"CXv \oena. thjw IWvSv ]IbvpIsbmpw thWvS. X\n aebmfnssIm Snbm. thjw PmSbmbn Iqnbm aXn. Fs Hm^oknse AuWvSvkv tkm^vvshb FIvkvs]m. Excel BWnhnsS hnjbw Fv ]dtm Chsmcp ]qXn, \nsf Ahġv ]TnnWsav. C\n Excel Ignt t]mIq.' "lmbv... ' \oena IpnIġcnIn hp\nv ktmjtmsS ]dp.

"IpgamIptam', kp\nX cXojnt\mSv ]ndp]ndpp. ]t, \oenabXv tIp.

"Hcp Ipghpan', Ah ]dp. "ImnItbm at\mlcambn Rm \nsf ]Tnnpw.' Xncnv ImnItbmSv "FSo, Cu \mdp thjw amdtWvS? Hv IpfnWw, hniv amWw.' IW-ns hgn-I

2

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"R Ipfnbpw Xobpw Ignv hcmw, \n Ccnv' ImnI ]dp.

"B, tNnam t]mbnphm', sXsmcp kwibtmsS cXojpw ]dp.

Um tNm

Ipfnbpw ImnIpSnbpw Ignph tNnam t\sc IpnIġcnInsen.

ImnI Ftbpw t]mse ss\nbnembncpp. Fm \oenabpsS thjw cXojn\v t_m[np.

"ssIenbpw jpw.' B thjn Ah icn psamcp BIpnbmsWt tXmq. Ftm IpkrXn ]dbm\h hm Xpdptmtgpw ImnI ]dp.

" I p c p t sSmpw FgpnWvS DWvSm. Ch Bfev]w ioabm.' "]mhamsWt tNn t\ct ]d Xv? kp\nX tNmZnp.

"Hm, ]mhw {Iqc!' Fmhcpw Nncnp. ImnI Hcp ]pkvXIhpsaSpv Inen Ibdnbncpp.

"icn, XpSmw', \oena ]dp. "\n _me]mTsams ]Tnp Igntm!

icn, CUnbv XpSv' (cXojv sRn. IpsSppwt]mse ImnIsb t\mn).

"Hcp skn Hcp kwJy F sNv.' cXojv A1 skn 999 F kwJy ssSv sNbvXp.

"t^mape _mdn t\mv', \oena ]dp. "999 AhnsS hXpItWvSm?' "Dv, AXphcpsav Rġv t\ct Adnbmw' sXltbmsS cXojv ]dp.

"tItm ImntI, Cu CUnbn\v Adnh¸w IqSpXem' \oena ]dp.

"Fm C\n tUmntbmSmImw (ChW kp\nX sRn). "t^mape _mdn, kwJy IpSmsX FpWvSv?' "Hm, AXntmgm {inXv', kp\nX ]dp. "cWvSv _WpI. Hcp KpW\ Nnw, ]nssbmcp SnIv amIv. AsXn\m?' "Hm, \n\snepsamcp kwibapWvStm!' \oena ]dp. "Fn B KpW\ Nnapff _Wn Hv nv sNv' kp\nX KpW\Nn _Wn nv sNbvXp. skn ssSv sNbvX kwJy A{]Xyambn.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"Blm! CXmtWm kw`hw? Atm CXv Cancel Button', kp\nX ]dp.

"AsX. As\ sbmWXns t]cv. Esc

Io AanbXn\v Xpeyw. ]t, kwJysbgpXn Enter sNpXn\v apv am{Xta AXp]tbm Knm Ignbq', \oena hniZoIcnp.

"Fn, SnIv amv Fn\msWv Rm ]dbmw', cXojv CSbvp Ibdn. skn hoWvSpw ssSv sNbvXv Ah SnIv amv D _ Wn nv sNbvXp.

"atXv Cancel _Wm IgptX (kp\nXtbmSv), C\nbo kwJysbmv Imk sNv.' "icnbmWv', \oena CSs]p. "kwJysbgpXn Enter Io AapItbm, SnIv _ nv sNpItbm sNbvXmte kwJy hvjons `mKamIq. asmcp Imcyw IqSnbp WvSv. Enter Io AangnbptXmsS \ sXmpXmgs skn Fn gnp. Shift Aan Enter sNpIbmsWn Igvk sXmpapIfnes sknep sapw.' "CXns\stb ]q FptWvSm', kwibw kp\nXbptSXv.

"Ctm. AXv amWsapsWvSn Tools- Option FSppI. Edit F Sm_v IymcIvS

kwJybvv apnse +

Nnw

E/e

]mcXnknkv {_mv

iXam\Nnw (%)

t^mhmUv mjv (/)

(lcW Nnw)

hyhIe\ Nnw (-)

kwJyv apnse ]qPyw (0)

Excel hymJym\w

+ Nns AhKWnpp

Nnӯn\v ]pdIn t^mape

hcpsn AXns\ = Bn

ampw.

imkv{Xobambn [cnpp

kwJyv Ccp]pdpamsWn

s\Kohv kwJybmpw.

100s iXam\ambn ImWpw.

kwJyIfpsS IqsSbmsWn

XobXnbmbn [cnpp.

kwJyIfpsS IqsSbmsWn

XnbXnbmbn IWmmw.

]qPys AhKWnpp.

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, (\Sphjw)

Aug, 2002

2-Nov-1997

789

Tab D]tbmKnv

skeIvSv sNbvX

tdneqsS \omw

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Xpdm Inp Hm]vjkv Cu \on am DWvSmm D]tbmKnmw.' \oena ]dp.

skpIfpsS Hcp Range-emWv Um tNpsXn Hcp FfphgnbpWvSv.

Range skeIvSv sNbvXpIgnm Tab Io D]tbmKnv XpSw apX Range-s Ahkm\s sk hsc \omw. hoWvSpw Tab Aanbm Xncnv Range-se BZys sknsepw.

UmbpsS Excel hymJym\w \mw \Ip Umsb Excel kzambn hymJym\npw HpIn kwJybmbn, Asæn sSIvv Bbn. sSIvkvv Bbn Excel

ImWp Umsb AXv se^vvAsse sNpw. kwJybmbn ImWpXns\ ssdvAsse sNpw.

]qPyw (0) apX HXv (9) hscbp Afpw +, -, E, e, (, ), $, %, / Fnhbpw BWv kwJym Umbmbn Excel ImWpI.

_mn IymcIvSdpI Fmw Excel-\v sSIvmWv. AXpt]mse lcWNnanSpt mgpw kqnWw. 1/25 Fv lcWn \mbn tNm Excel CXv XobXnbmbn sXncnv P\phcn 25 Fv hymJym \npw. 0.04 F AnemWv \mw 1/

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

25 FsgpXpsXn AXn\v sNdnsbmcp kq{X{]tbmKw \SWw. kwJybvv apn \yq\Nnw, keNnw, ]qPyw(0) Fnhbn GsXnepsamv tNpI.

Fm kwJyv apn ]qPyw (0) tNpXns\ Excel Imcyambn KWnn.

AXmbXv, 0484 FsgpXnbm AXv FdWmIpfns sSent^m STD tImU, shdpw 484 BWv. Atm ]ns Fp hgn? 0484-\v apn Hcp ' tNpI ('0484). Format sa\phn Cells Iamn Number Sm_n Text skeIvSv sNbvXpw Cu {]iv\w ]cnlcnmw. Um sSIvmbn ]cnKWnsp Ignm AXv se^vvAsseUv Bbn amdpw.

Nne IymcIvSdpI thWvShn[w D]tbmKnnsæn, \mw Dtinp A nembncnn Excel hymJym\npI.

Um ^n

"Nne t\cfn Htc Umtbm t^mapetbm Htsd tImffnepw hcnIfnepw BhntWvSXmbn hcmw', \oena ASp Lntev ISp. "Hmtcm sknepw copy-paste {]tbmKnpIsbm t\cw IfbpI Fp am{XamWw.

Cu {]iv\w ]cnlcnm Excel \Ip FfpamamWv Data Fill. BZy skns DShpw t^mampw Um ^n ]Ipp. Hcp tImfneqsS Xmtgmpw Hcp hcnbneqsS hetmpw Data Fill sNpXmWv km[mcW coXn. Fnepw apIfnte pw CStmpw Fill sNepw km[npw. "sa\p D]tbmKnv ^n sNmw. ^n sNtWvS Range skeIvSv sNpI.

Range-se BZy sknse DSambncnpw (Xmtgmtm heXphittm) ^n sNsSpI. Edit sa\phn Fill FSpv GXv ZnibntemWv ^n sNtWvSsXv skeIvSv sNpI.' aukp]tbmKnpw Umm ^n sNmw. CXn\v Excel-s ^n

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

lmUn D]tbmKnpp. tImn sNtWvS sk skev sNpI. skns Xmgv hev aqebn Igvk (+) kv ASbmfnemIpw. CXmWv Fill handle. AXn nv sNbvXv {UmKv sNpI.

Umm kocnkv

kzm`mhnIambn hnp (Progression)

kwJyIfpsS Hcp t{iWnbmWv Data series.

kwJyI Xn GsX nepw \nebvv _ sncnpw. DZm: 2, 4, 6, 8; 1, 2, 3... Cu cWvSv t{iWnbns kwJy Isfbpw Excel a\nem pIbpw hymJym\np Ibpw sNpw. am{Xa, Um Enter sNp skpIfpsS range- Um \ndbvpIbpw sNpw.

kocnkv CSm\p Range skeIvSv sNpI.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Edit sa\phn Fill- Series F Iam v skeIvSv sNbvXm Hcp UbtemKv t_mIvkv e`npw. UbtemKv t_mIvkn aqv hn`mKfnembn Hm]vj\pI ImWmw.

Series in:- skeIvSv sNbvXncnp Range A\pkcnv Um \ndbvtWvS Zni Excel \nbnpw. skpIfpsS Row (hcn), Columns Fnhbn Hv skeIvSv sNpI.

Type Linear: skn \Inbnp kwJysb B[mcamn, Step value F t_mIvkn \Ip aqeya\pkcnv tdnse skpIfn Linear Progressiosn

A\pkcnv Excel Um \ncpw.

tdnse BZyskn InSpXv 10Dw Step value 10-Dw BsWn tdnse skpIfn 10, 20, 30, 40 Fns\ Um hogpw.

Type-Growth: Step Value t_mIvkn \evInbncnp aqeyw sImWvSv BZy sknse kwJybpsS km[mcW KpW\^e ASp skpIfn \ncm \mWv Cu Hm]vj. sknse aqeyw 1Dw Step value 2-Dw BsWncns. 1, 1x2, 2x2, 4x2, 8x2 Ftm, 1, 2, 4, 8, 16 Ftm Excel Um \ndbvpw.

Type-Date: BgvNb \pkcntm, amka\pkcnt m, XnbXnIfpsS kocnkv \ndbvm\mWv Cu Hm]vj. DZm: Hmas skn 8/31/01

Fv F sNbvXv Date

Hm]vj Month FSpp IbmsWn 8/31/01, 9/

30/01,10/31/01 Fn s\ Excel Um \ndbvpw.

Type-Autofill: Iptd skpIfn Um F sNbvX tijw, Hcp tdnse _mn skp I \ndbvm Excels\ A\phZnm A Xnep _w hyamp Cu Hm]vj D]tbmKnm aXn. BZyskn 15Dw ASp skn 25Dw \mw F sNbvXv Cu Hm]vj FSpm ASp skpIfn 35, 45, 55 Fn s\ Excel kwJy \ncpw.

Trend: Linear, Growth Hm]vj\pIt Cu t_mIvkv e`yamIq.

Step Value, Stop Value: kwJyIfptStbm XnbXnIfptStbm h\ F{]Imcw thWsapw KpW\w Fs\ thWsapw \nbnpXv Step Value BWv.

kocnknse Ghpw IqSnb kwJy Stop Value t_mIvkn \ntinpp.

 

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"CXv kwKXn FfpamWtm tNo', kp\nX ]dp. "Fm sknepw A \ndtWvS KXntISntm!' "AsX', \oena kXnp. "]t, sImSpp aqey IrXyambncnWsa pam{Xw.' "A tNo, CsXm Ipsd Um CSXp` mKpw thsd Iptdsb w heXp`mKpw Asse sNbvXncnp Xv?' cXojv tNmZnp.

"AXv \n\v t\cs ]dp X XmWv. kwJyI heXp `mKpw sSIvv CSXp `mKpamWv Asse sNpI', \oena ]dp. "]t, \o tNmZnsX\nv a\nembn.

]dbmw. \mw Hcp tS_n DWvSmn Fncn s. AXns\pdnv Hcp Ipdnv AXns

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

sbmw tNtWvSnhtmw. AXv tS_nfns heXp`mKv ssSv sNmw. ]t, kv{Io\n, Ipdnv apgph {]Xyambnsöv hcmw. Atm B sk skeIvSv sNbvXv Edit sa\phn Fill- Justify FSppI. CXv ItWvSm? Ipdnv B tImf n¯s Xmtgmv Xmtgmv hn`Pnv \ncnt?' "Great!' kp\nX ]dp.

ssdv nv

"tItm, kp\ntX' cXojv kXoysb hnfnp. "Excel- ssdv nn\v henb {]m[m\yw Csöm tXmpXv.' "t]mSm, DWvSm', Dcw ]dXv \oenabmWv.

"\obtm AXv Xocpam\npXv. hntijn v Autofill D]tbmKs SpXmWv ssdv nv.' ^n sNm\p Range sXcsSpm, ^n lmUn {UmKv s N p X n \ p a p v heXp _ AapI. tdv sXcs Spp Ignm _ hnSpI. Hcp tjmvIv sa\p e`n pp. Autofill sNm \p ]e Hm]vj\pI CXn DWvSv.

Copy Cells: Hcp ]pXnb kocnkv krjvSnpXn\v ]Icw, sXcsSp skns tImnbmbncn pw Autofill BIpI.

Fill Series: Autofill D]tbmKnv kocokv \ndbvp AtX ^ew e`npp.

Fill Format: Edit sa\phn Paste Special-se Formats FSppXn\v kZriyam WnXv.

tImn sNbvX tdnse t^mamns AtX {Ianembncnpw tImn sN sSpXpw.

Fill Values: skpIfnse aqey tImn sNpp. ]t, t^mampI ]IsSpn.

XobXn ASnm\sSpnbp range BsWn Days, Weekdays, Years

Fnh ^n sNm\pw, Linear Trend, Growth Trend, Series Fnhbvpw ssdv nv{UmKv D]tbmKnmw. CXn Series skeIvSv sNbvXm Series UbtemKv t_mIvkv e`npw.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Iw ^n

Hcp tdnse skpIfn Hn\Sp Znhkw ASp skn hcpwhn[w BgvNbnse Znhksf \ncm Autofill-\v Ignbpw. DZmlcWn\v, BZy skn Monday

Fv ssSv sNbvXv skns ^n lmUn hcnbneqsS IpdpsI {UmKv sNbvXm ASp skpIfn ASp Znhk (Tuesday, Wednesday...) sXfnbpw. BgvNbnse Znhk, amk Fns\ ntcm]tbmKw hcp enpI D]tbmKnp Imcyn CXv hfsc {]tbmP\IcamWv. CXpt]mse ap ]eImcyfnepw (DZm:

Hcp kqamnse tkmv {_mUpIfpsS env) Ccw enpI D]tbmKnm IgnbpXv KpWIcamImw.

t]cphnhcfpsS (GXv sSIvnsbpw) kzamb Hcp env (Custom List) Excel-

krjvSnm Ignbpw. Cs\ krjvSn Hcp env ]noSv Autofill- D] tbmKnmw. AXmbXv ennse BZys t]cv F sNbvXv {UmKv sNbvXm _mn t]cpI {Ian Autofill Bbnsmpw.

Iw env Fs\ DWvSmmw? hvjonse Hcp tImfn ennemtWvS t]cpI ssSv sNpI. enn DsSptWvS {IanembncnWw ssSv sNpXv.

t]cpI Dsmp Cell range skeIvSv sNbvXv Tools- \nv Options

UbtemKv t_mIvkv FSppI. AXnse Custom Lists XpdpI.

* Lists t_mIvkn New List sslssev BbnpsWvSv DdmpI.

* skeIvSv sNbvX Range, Import List from cells F t_mIvkn sXfnncn pw.

 

 

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

tNsSpw. ]pXnb env CSXphis Custom Lists F t_mIvknepw sXfnbpw.

* OK sNpI.

UbtemKv t_mIvkn t\cnv ]pXnb env F sNmw. Custom List

t_mIvkn New List skeIvSv sNbvX tijw List Entries t_mIvkn ]pXnb ennse t]cpI {Iaa\pkcnv ssSv sNpI. Hmtcm t]cn\pw tijw Enter

AaWw. env ssSv sNbvXp Ignm Add nv sNpI.

CXpt]mses XncppIġmbn enkvnse t]cpI FUnv sNpIbpamImw.

"CXp t]mse Excel- D asmcp kuIcyamWv Auto complete. Htc Um ]e skpIfn BhntWvSn hcptm CXv hfsc {]tbmP\{]ZamWv', \oena ]dp.

Auto complete {]mhnIamm Tools- Options FSppI. AXn Edit

Sm_v Xpdv Enable

Auto Complete for Cell

Values FXv skeIvSv sNpI. skn Um ssSv sNbvXpsImWvSncns , AXv ]qnbm m Excel {ianpsIm WvSncnpw. ap]v F sNbvX hnhcfn \npamWv Cu "Dulw' Excel \SpXv.

"Auto Complete- asmcp kuIcyw IqSnbp WvSv', \oena XpSp.

ap]v F sNbvX UmIfpsS Hcp dropdown

enn \nv ASp skntev thWvSXv skeIvSv sNmw.' F sNm\p ASp sk skeIvSv sNbvXv ssdv nv sNpI. Dropdown

enn \npw BhiyambXv skeIvSv sNpI.

Um Xncpm

"Hcp skn F sNbvX Umtbm t^mapetbm XncptWvSnhcmw', \oena XpSp.

"CXn\v BZyw sk skeIvSv sNpI. t^mape _mdn AXnse DSw sXfnbpw. sknse Um FUnv sNm t^mape _mdn nv sNpItbm F2

Io AapItbm sNpI. Fp kw`hnpsav t\mmw.'

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

\mw Edit tamUnemsWv ImWnm mkv _mdn Edit Fv sXfnbpw.

t^mape _mdn Um Xncpm\pw, AXneqsS \om\pambn, Hcp Igvk sXfnbpw. skn Xs (In-cell) FUnv sNm\p Hm]vj Tools- skeIvSv sNbvXnpsWvSn Igvk skn ImWmw.

atsXmcp t{]m{Kmantebpw t]msesbmWv Excel-epw FUnnwKv. CXv GXv thUv t{]mdnsebpw t]mse FfphpamWv.

an hntUmkv t{]m{KmapIfntebpw t]mse Excel-epw Edit

sa\phn Hcp Undo

IampWvSv. Undo Iams Spm FmWv kw` hnpIsbv sa\phn tcJsSpnbncnpw.

mtUv Sq_mdnse Undo _ Cu {]hrn Xs sNpp. IqSmsX, sXmvapv sNbvX 16 {]hrnIfpsS Hcp env Cu _Wn \nv drop-down Bbn e`n pp. CXn \nv GXv {]hrnbmWv Undo sNtWvSsXv sXcsSpmw.

UmbpsS m\amw

"Cutting, Copying, Pasting Fo {]hrnI Excel- CSbvnsS Bhnt WvSXmbn hcmdpWvSv', \oena ]dp. "CXn\mbn FIvk ]e am \evIpp. ]t, FhnsSsbnepw Um t]v sNppshn B skn app WvSmbncp Um ]ns ImWnsöXv HmnWw.

henp \o Hcp ev \npw asmcnStv Um amm\p Excel-se Ffpamw Drag-and-drop BWv. CXn\mbn BZyw m\w amtWvS tdv skeIvSv sNpI.

tdns t_mUdn aukv ]nSnv ]pXnb etv {UmKv sNpI.

Cs\ \optXmsSmw FnsSp skpIfpsS m\w Excel ImWnp Xcpw.

Tools- Options FSpm Inp UbtemKv t_mIvkns Edit Sm_v Xpdv AXnse Hm]vj\pI D]tbmKnp thWw Drag-and- drop kuIcysaSpm.

skeIvSv sNbvX tdn\v Nppw hoXnIqSnb t_mU ImWpnsæn Cu UbtemKv t_mIvknse sknwKv amtWvSnhcpw.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

CtX coXnbn Um tImn sNmw. Um {UmKv sNbvXv drop sNpXn\v apv Ctrl Io AapI. Um Cut sNpIb, ]IpIbmWv Fv ImWnp Hcp sNdnb kv (+) ASbmfw Igvkdn\v apIfnembn sXfnbpw.

UmbpsS Cutting, Copying, Pasting Fnhbvv Io t_mUv tjmv IpI Word-teXp t]msesbmWv. Ctrl+X, Ctrl+C, Ctrl+V Fns\. Edit sa\phnse IampI D]tbmKnpw Cu {]hrnI sNmw. Sq_mdnse _WpIfpw CtX tPmenIġmbn D]tbmKnmw.

"tNo, sk Cut sNpIsbv ]dm, FSpp ampXv sk Xs bmtWm?' cXojns kwibw.

"\ymbamb tNmZyw', \oena Nncnp. "]dp Xcmw.' Hcp hvjons Hcp `mKp\npw thsdmcp `mKttm, Hcp hvjon \npw asmntetm, asmcp hv_pntetm Um amm (t^mampw ammw) Cutting-Dw Pasting-

Dw D]tbmKnmw. Cutting

FmWv hmv Fnepw sknse Um am{Xta amsSppp. sk ]gb t^mam n \ne\n¡pp. Hcp hvjonse sk \ow sNm AXns\ delete sNWw.

"AsXs\!', tNmZyw kp\nXbn \nv.

"AXp ]ns ]dbmw.' Hcp sktm tdtm Cut sNptm AXn\vNppw IppIsmWvSp Hcp sse sXfnbpw. Cut sNbvX Um asmcnSv Hnp tNpXp hsc Excel

Umsb icnpw Cut sNn. Um asmcnSv t]v sNbvXm IppI sImWvSp sse A{]XyamIpw.

C u t t i n g -D w Pasting-Dw Ign mepw Um bpsS sk sd^ dkv ]gbXpXs bmbncnpw.

DZmlcWn\v A8*B8 F t^mape Cut

sNbvXv H8- Paste sNbvXmepw d^dkv A8*B8

Fp Xsbmbncn pw.

tImffpw hcnIfpw Hfnnmw, sXfnbnmw. Hcp tImfw Hfnnm

tImfw slUnwKn ssdv nv sNbvXp Inp sa\phn \nv Hide

skeIvSv sNpI. tImfw hoWvSpw sXfnbnm Hfnncnp tImf

ns Ccp`mKpap tImf skeIvSv sNbvXv Hcp tImfn

ssdv nv sNpI. sa\phn\nv Unhide FSppI.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"tNo, As\bmsWn Cutting-Dw Copying-Dw Xn FmWv hyXymkw?' cXojv tNmZnp.

"Copying-Dw Cutting-Dw anhmdpw kZri amWv', \oena hniZoIcnp. "]t, hyXymk apWvSv. Cut sNbvXpIgnm Um AhnsS ]ns ImWn. Copy sNpIbmsW n Um AhnsSs \ne\n¡pw.

am{Xa, Copy sNbvX Um F{X e fn thWsanepw Paste sNmw.' Hcp sktm, tdtm Copy sNpt m, Cut sNptmgstmse, AXn\v Nppw IppIsmWvSv Xo Hcp sse {]XysSpw. CXv Um n]v t_mUnte v \on Fv kqNnnpp. C\n, FhnsSbmtWm Paste sNtWvSXv B tdv skeIvSv sNmw. Fmentm, Cut sNbvXv Paste sNbvXtmgstmse, sse A{] XyamIpn. CXnsbw n]v t_mUv Ctmgpw BIvSohv BsWpw C\nbpw t]nwKv \SmsapamWv.

Paste sNm\p tdv sXcsSpptm, apgp tdpw skeIvSv sNp Xn\v ]Icw, tdns CSp aqebnse sk am{Xw sXcsSpm aXnbmIpw.

tImffptSbpw hcnIfptSbpw IrXyamb kwJytbmv Xs Excel Paste

sNpw.

"Paste sNpXv Word-tetmsesbmtWm tNo?' cXojv tNmZnp.

"AXmWn\n ]dbpXv', Paste Iam v \Inbm, n]v t_mUn InSp Um skeIvSv sNbvX `mKv Hnp shbvpI am{XamWv Excel sNpXv. Hcp tdmWv tImn sNbvXsXn, Paste sNm Hcp sk am{Xw nv sNbvXmepw, Umbvv Bhiy amb tdv Excel sslssev sNpw. Copy sNbvX Umbvv A\pkrXamb coXnbne tImfhpw hcnbpw skeIvSv sNbvXsXn Excel Hcp Error Message

ImWnpw.

"Htc tImn Xs ]e ev Paste sNms\mptam, tNo', kp\nX tNmZnp.

"tNmZnXv \mbn', \oena ]dp. "Excel- CWn ]etmgpw Bhiyambn hcpXmWv.' Hscm skns\ hyXykvX tdpIfntev tImn sNmw. BZyw, ]ItWvS Um tImn sNpI. AXn\ptijw eyamb sk skeIvSv sNpI. C\n GsXms tdntemtWm ]ItWvSXv, Ctrl Io AannSnv Ah skeIvSv sNpI. Fmw skeIvSv sNbvXv Ignm km[mcWt]mses Paste sNpI.

12 hyXykvX UmI (hyXykvX Office t{]m{KmapIfn \npamImw) tiJZn

 

cnv n]vt_mUnenv Ah Paste sNm\p kuIcyhpw Excel XcppWvSv.

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

F UbtemKv t_mIvkv hgn Excel \Ipp. CXnse Paste hn`mKn Cu {]tXyI Hm]vj\pI e`npp. Paste All : efnXamb t]nwKv Formulas : sk t^mamnwKv FSpmsX t^mape am{Xw Paste sNmw. Values : tImn sNbvX t^mapebpsS ^ew am{Xw Paste sNpp. Comments : IpdnpI Hcp skn \nv asmntev ]Ipp. Validation : \Inbnp {]tXyI aqey\nb am\ZWvU ]Ipp. All Except Borders : Um ]Iptm ]pXnb tdns t_mUdn\v amap WvSmIpn. "Paste Special tImn sNm\p Iamn\v am{Xta _m[IamIq. hvjo n \npw Cut sNbvX Um ]Im CXp]tbmKnm\mhn', \oena Hmn np.

Paste Special UbtemKv t_mIvknse Operations hn`mKw, Paste sNptm \StWvS KWnXimkv{X {]{InbsbmsWv \ntinm\pXmWv.

Um Uneov sNmw "kp\nXbt t\ct Data Uneov sNpsXs\sbv tNmZnXv', \oena XpSp. "AXv hntijnv ]dbms\mpan. Fnepw \apv t\mmw.' Um cWvSp hn[n Delete sNmw. Hv, sknse Umsb am{Xambn \ow sNmw. Asæn sk Xsbpw Delete sNmw.

Um am{Xw \ow sNm ]e hgnIfpWvSv.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

* skn, FUnv tamUn, kwJyI \ow sNpI. (Back space, Delete

IoI). * Edit sa\phnse Clear Iamp]tbmKnpI. * skn ssdv nv sNbvXv t]mv A]v sa\phn Clear contents FSppI. * ^n lmUn CSXp`mKv apIfntemv {UmKv sNbvXv skns\ aqSpI. mkv _mdn Drag Inside to Clear Cell ktiw ImWmw. * sknse F{Sn skeIvSv sNbvXv ]pXnb Um ssSv sNpI. "CsXms tIma skkns ImcyamWtm!' cXojv \nmc`mhn ]dp. "t]ms, sk Fs\bmWv Delete sNpXv?' "AXmtemNnm\p tImaskkv \n\n, At?' \oena Nncnp.

"Hm, Ahs\mcp ]mhw CUnbt?' kp\nX CSbvp Ibdn.

"B t]ms', \oena hnen.

Um Uneov sNpXpt]mse A{X efnXa skpI \ow sNpXv.

ImcWw H sktm Hcp tdtm Uneov sNpXv hvjons LS\sb _m[npw. AXn\m CWnv apXncpXn\v apv Hc]w NnnpXv \ XmWv. Hcp sk am{Xambn Uneov sNpXnepw t`Zw, antmgpw, Hcp hcntbm tImftam AtmsS \ow sNpXmbncnpw. ImcWw tS_nfpIfpw sk sd^ dkpIfpsampw XIcmdnemImXncnm CXv klmbnpw.

"AXns kq{XWn Rm ImWnpXcmw', cXojv ]dp. "hcnbpsStbm tImf nstbm slUnwKn (hcnbpsS \, tImfns Acw) nv sNpI.

C\n Edit sa\phn Delete FSppI. t]mbnt?

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"AsX', \oena hnhcnp.

"hcntbm tImftam \ow sNpXnssbmw, Xmgs hcnIsf apIfntepw heXp`mKs tImfsf CSXp`mKtpw Excel sImWvSphcpp. Hw Xs Fm t^mapeIsfbpw delete sNbvXX\pkcnv XncppIbpw sNpp. cWvSmaXv t^mapeI FgpXn XIcmdnemthWvS.' "AsXmcp{K ]cn]mSnbmWtm!' kp\nX ApXw {]ISnnp.

"tImaskkv thWsaSo, tUmo', cXojv Ifnbmn.

"CUnbns tImaskkv F\nnt', kp\nX ssIaen ImWnp.

"\nv \nv', \oena imknp. "C\n Hcp sktm, tdtm Uneov sNp sXs\sbv t\mmw.' hcntbm tImftam Uneov sNp AtX {]{InbbmWv CXn\pw. ]t, sNdnsbmcp Ipgw. CSbvp\nsmcp sk t]mIptm _mnbp Umsb F s\bmWv koIcntWvSsXv Excel-\v ]nSnInn. Amcyw ]dpsImSptWvSn hcpw. sktm tdtm skeIvSv sNbvXv Delete Iam v \IpI. _mn skp Isf Fs\ koIcnWsaXn\v Hm]vj\pI \ntinp Hcp UbtemKv t_mIvkv e`npw. ChnsSbpw delete sNbvXXpsImWvSpWvSmb {]iv\w Xom t^mapeI kzbw IWp Iqm Excel {ianpw. Fm Nne tIkp Ifn ]niIv ImWnp #REF skn sXfnbpw. ChnsS \mw Xs AXv icnbmt WvSn hcpw.

" A s X m c e v ] w {]iv\amWtm!' kp\nX ]dp. "Cu ]Wn Hgnhm m {ianpIbmWv \Xv.' ]ns tNo, Um Uneov sNmsa n Ckv sNm\pw Ignbnt?' " I g n b p a t m ! ' \oena ]dp.

Um XncpInbmw Uneov sNp AtX coXn XsbmWv Ckv sNpXn\pw Hcp hcntbm tImftam apgph\pamtbm, Hcp sktm, tdtm am{Xamtbm CSbvshnsSsb nepw Ckv sNmw.

UneonwKn F t]mses Hcp hcntbm tImftam apgph\pambn Ckv sNpXmWv Ffp amb GmSv.

 

 

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

Npcp--n...

t^mape _mdn Imk, F _WpI l UmbpsS FIvk hymJym\w hy

ambn a\nemWw l ZimwikwJyI \Iptm {]tXyI{i Bhiyw l Hntesd

tImffnepw hcnIfnepw Htc kwJy Bhnm Umm ^n l kzm`mhnI

h\bpWvSmIp (Progression) kwJyIsf Umm kocokneqsS F sNmw l koco

kns \nbw Step value, Stop value Fnh hgn l BgvNIfpw amkfpw t]mse

XpSbmb Imcy F sNm Custom fill l 16 {]hrnI hsc Undo sNm

kuIcyw

 

Hcp hcntbm tImftam ]qambpw Ckv sNm, AXv skeIvSv sNpI.

AXn\v Delete- sNbvXXpt]mses hcnbpsS \dntem tImfns A cntem nv sNpI. hcnbmsWn skeIvSv sNbvXXn\v sXmpapIfnepw tImfamsWn sXmv CSp`mKpw Insertion \Spp. ]pXnb hcnbpsS (tImf ns) Nppap skpI t^mamp sNbvXnpXmsWn ]pXnb skp Iġpw AtX t^mamv e`npw. ChnsSbpw KWnXns ]p\xkoIcWw Excel \Spw.

Hcp sktm tdtm Ckv sNpXnepw, Delete sNptm DWvSmb sImp{]iv\apWvSmIpw. sktm, tdtm skeIvSv sNpI. Edit sa\phn Insert

IamsSppI. skpI hetmtm Xmtgmtm amtWvSXv Fv tNmZnp UbtemKv t_mIvkv sXfnbpw.

FtmgmWv Ckj Bhiyambn hcpXv? Hcp hvjons Hcp `mKv \nv thsdmcp `mKttm, Hcp hvjon \nv thsdmcp hvjontetm, Hcp hv_pn \nv asmcp hv _pntetm Um Cut sNbvtXm Copy

sNbvtXm amtWvSn hcptmgmWtm Cu Bhiyw hcpXv. CXns thKw Iqm Excel- kuIcyapWvSv. skpI Cut sNpItbm Copy sNpItbm sNbvXm Insert sa\phnse Hm]vj AX\pkcnv Cut cells Asæn Copied cells Fmbn amdpw. Ckv sNtWvS `mKw skeIvSv sNbvXv Cu Hm]vj nv sNpI.

Cu {]hrnIġmbn ssdv nv sNptm Inp t]m]v A]v sa\phnse IampIfpw D]tbmKnmhpXmWv. Hcp sknse FUnnwKv tPmen Iġmbn tjmvIv sa\phn Cut, Copy, Insert, Delete, Clear Contents XpSnb Hm]vjkv e`npp.

"C\n \apv Excel-s bYm in ImWmw. C, \msf', \oena ]dp.

]t, \msf Rm DWvSmhn. AXn\m am. C\n DuWv Ignv kpJamsbm pdmw.'

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

\oenav Hcp \mfs tPmen Igntmtgpw Hch[n e`np. IpnIġpw ImnIbvpw Ah[n e`nnsöv am{Xa, B Znhkw ISp ]Wnbmbncpp.

hntUmkvan apX Excel hsc ]Tn ]mTf{Xbpw {]mtbmKnIambn Iw]yq dn IpnI ]conp.

ASp Znhkw kyv ImnIbpw \oenabpw Ibdnhtm kp\n Xbpw cXojpw Aacmbncpp. Ftm IWvSp]nSn `mhambncpp CcphcpsSbpw apJv.

"Ftm H apWvStm!' \oena tNmZnp.

"Hstm?' kp\nXbmWv adp]Sn ]dXv. "s]sv Ipfnv Imn IpSnv hm. Cv Excel R \nsf ]Tnnpw.' ImnIbpw \oenabpw ]ckv]cw t\mn. Xncnp htm, kv{Io\n Hcp hvjopambn IpnIfncphcpw Aacmbns CcnpIbmWv.

"Cu tS_n R XmdmnbXmWv,' cXojv ]dp. "C\nbnXns slUnwKpw tImfw slUnwKpw Hs R at\mlcamm t]mIpIbmWv.' Format sa\phn \npah Format Cells UbtemKv t_mIvskSpp.

"skeIvSv sNbvX UmbpsS Assesa v, Zm, Cu Alignment F Sm_v Xpdv AXnep Hm]vj\pI D]tbmKnv NnsSpmw. Horizontal Hm]vj IpdpsI

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

 

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

bp hn\ymkn\v. CXn Indent \In skn sSIvns m\w \n bnmw', BmZtmsS cXojv ]dp.

"Atm \n ]Tnp Ignp', \oena Ahsc {]iwknp. B Vertical- \ntiw \In, Umsb tImfn ew_ammw. tS_nfpIfn Acw tImfw slUnwKpI at\mlcam bncnpw.' "Ignn', kp\nX \oenasb XSp. "Cu Text control Hm]vj F{X {]tbmP\IcamsWt m! CXn Wrap

Text, Shrink to Fit Fnh sSIvv hn\ymkn\v hyXykvX `wKnI \Ipp.' "Umsb Xnco\ ambpw ew_ambpw am{Xa , tImtWmSptIm Wmbpw \Imw', \oena ]dp. "AXn\mWv Cu Orientation Hm]vj.

skn\Iv sSIvv

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

F{X Un{Knbn thWsa nepw CXp]tbmKnv Idmw.' CXp t]mse skp Iġpw sk tdp Iġpw `wKnbp t _ m U d p I f p w \Im Ignbpw. Format

Cell UbtemKv t_mIvknse Border

Sm_v Xpdv B t]sPSp pI. CXnse Line

F t_mIvknse Style

enn \nv t_mUdn\ v CjvSs ]mt skeIvSv sNpI.

AXn\v Xmsg color F drop-down enn \nv t_mUdn\mhiyamb \ndw sXcsSpmw.

Presets hn`mKnse _WpIfn Outline thtWm, Inside t_mU thtWm Fv Xocpam\npI. t_mU Hpw thsWvSn None nIv sNpI.

"MS hntUmkpw, hntijnv MS Office-Dw \Ip kucykwht\m]

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

[nI Word- F t]mse Excel-Dw Hcp tUmIypsa v (ChnsSsbmcp Workbook) at\ml camm sXsmpa klmbnpXv', ImnI CSs]p.

AXphsc Fmw IWvSnc n p I b m b n c p p ImnI.

"Hm, \n\sænepw apSn Nmbvpw sNcnpw sIm\pw kucyw Iqm \pat t\capp', \oena Ahsf Ifnbm n.

"apSnbnmh ]ns Fs\ Nmbvm, sNcnm, sInshbvm...!' ImnIbpw hnn.

"sImpham\w \nv Soamsc', Kuchn kp\nX ]dp. "kwKXn icnbm. Hmtcm hn`mKw F{Snpw Hmtcm tjbvUv \IpXv tS_nfn\v Hcp sKv XsbmWv.' skpItm sk tdpItm {]tXyI h \Imw. CXn\mbn Format Cells UbtemKv t_mIvknse Pattern Sm_v XpdpI. CXn If t_mIvkn \nv Bhiyamb \ndhpw Pattern

t_mIvkn \nv skn\v thWvS ]mtWpw sXcs Spmw.

Excel-2000, Personal

Toolbar Fsmcp Hm]vj XcppWvSv.

Hcm ncambn D] tbmKnp Sqkv BWv Cu Sq_mdn {]XysSpXv. ]pXnsbmcp Sq D]tbmKnp X\pkcnv AXns _ Sq_mdn {]Xy sSpw. 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/

Fmw Iw]yq D]tbmKnp BfpsS Xm]cya\pkcnv Customize sNm\pw Excel- kuIcyapWvSv.

Tools sa\phnse Customize IamsSpm Hcp UbtemKv t_mIvkv e`npp.

CXnse Toolbars Sm_v XpdpInp t]Pn Toolbars F kvIvtdm t_mIvkn \nv BhiyapXv sXcsSpv D]tbmKnm\mbn \apv hntUmbn sImWvSp hcmw.

CXpt]mses Hmtcm sa\phnepw Bhiyamb IampIfpw Customize

sNmw. Customize UbtemKv t_mIvknse Commands Xpdv Inp t_mIvkp I D]tbmKnv s]sp D]tbmKn\mbn Iam v _WpI drag-and-drop

coXnbn Sq_mdn tNmw.

"BsIqSn CsXmcp kpJap GmSmWtm!' cXojv Ia v ]dp.

"AsX.' \oena kXnp.

"Hcp Imcyw', kp\nX ]dp. "R DWvSmnb sSent^m \dpI Hs bptWvSm?' ]cnlmkphtbmsS ImnI tNmZnp.

"Ct, C', kp\nX kXnp. "Excel {]h\w ]cntim[nm\mbn sNbvsXt bpp. Um tNnbpsS CUIvkv _pntebm.' sSent^m CUIvkv Xmdmnb hv_pv kp\nX XpdpImWnp.

t_mUdpIfpw \ndfpw sImWvSv at\mlcamn. CUIvkv IWvSv Soamcncphcpw IpnIsf {]iwknp.

"sImmatm', ImnI ]dp. "t]cpI Acamem{IanXs. ]mSps] ncpv ssSv sNbvXpImWpw?'

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

"aWvScw ]dbmsXs tNo', cXojv ]dp. "Excel- Fm kq{XhpapWvSv.' "Rm ]dbmw,' kp\nX CSs]p. "tNnbpsS CUIvkv _pns XpSw apX HSpw hscsbmWv CXn F sNbvXXv FXv t\cv. AXpsImWvSv cWvSmasbpw aqmatbpsams Ac {IanXs hcptam?' "IqSpX _pnImWnWvS', ImnIbvv CtaPv hosWvSSpWambncpp.

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

apX Z hscbp {Ia n sSIvv koIcn pw Excel. Descending

_ skeIvSv sNbvXm Z apX A

hscbpw.' "Atm hnhcap WvSv', Ifnbmbn cXojv ]dq.

"t]mSm DWvSm.' "Cu ImnIbpw ]ntcpw Hcp t]msebm Wtm!' \oena ]cmXn ]dp. "Excel-s KpW C\nbpapWvSv.' Um F sNbvXp Ignv Insert sa\phnse Function UbtemKv t_mIvkv D]tbmKnv Im¡ptejs hnhn[ `mKfnse {]iv\ ]cnlcnmw. Financial, Math & Trig. (KWnXhpw {XntImWanXnbpw), Statistical, Logical Fns\ hnhn[ hn`mKw [ Function Category-bn DWvSmIpw. CXn \nv BhiyapXv skeIvSv sNbvXm Function Name t_mIvkn, B {]tXyI IymKdnbpsS {]hr nI sXfnbpw. Atm e`np UbtemKv t_mIvknepsS {]iv\]cnlmcw n{]kmyw.

FIvkens At\zjWw Hcp skntem t^mapebntem sk sd^dkntem tdv \mantem D GsXmcp sSIvv `mKhpw At\zjnp IsWvSmw. IsWvSngnmeXv Hmtcm mtbm, Replace Iamp]tbmKnv HbSntm ammhpXpamWv. Hcp hvjov apgph\ptam, Hcp hv_pnse apgph jopIfptam Excels\ smWvSv At\zjnnv Bhiyamb sSIvv `mKw IsWvSmw. Hcp hv_pv apgph sXcbm, BZyw AXnse hvjopIsf {Kqv sNWw. {Kqv sNm BZyhvjov skeIvSv sNbvXv, Shift Io AannSnv Ahkm\ hvjopw skeIvSv sNpI.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

skv \SpXv C{]Imcw 1. hvjon apgph skv \Sm Hscm sk skeIvSv sNpI; Hcp tdv skv sNm, B tdv skevIvSv sNpI. 2. Edit sa\phn Find FSppI (Ctrl+F IoIfpw D]tbmKnmw). Find UbtemKv t_mIvkv e`npp 3. Find What F t_mIvkn IsWvS tWvS sSIvv `mKw ssSv sNpI. 4. \ncI (Rows) A\pkcnpw tImf A\pkcnpw skv sNm Find- Hm]vj \pWvSv. 5. Look in Hm]vj\n F{Sn \SpI. CXn Aev]w {i \XmWv. t^mapeI, aqey (values), comment

Fnh Look in- \Imw. 6. Search-\v IrXy

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

amb Hcp ^ew (match) Xs thWsan Match

Case skeIvSv sNpI. ChnsS, \mw At\zjnm ]dbp sSIvns AtX Case (upper/

lower) D ampIfm bncnpw Find

IsWvSpI. 7. Hcp sknse Um b{Xbpw IsWvS m Find Entire

Cells Only sNv sNpI. 8. At\zjnm\mhiy s sSIvv IsWvSnbm, FIvk AXv sslssev sNpw. C\n skn nv sNbvXv, thWsan UmXncpmw. Asæn Replace _ D]tbmKnv AXns\ ammw. 9. CtX sSIvv C\nbpw FhnsSsbnepw DsWvSn IsWvSm Find Next nv sNpI. 10. At\zjW^ew Xr]vXnIcambn e`nm Close.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

sSIvv am Find UbtemKv t_mIvkp]tbmKnv IsWvSnb sSIvns\ Replace _ D]tbmKnv ammw. CXv Find-eqsSbmsXbpw sNmw. Edit sa\phnse Replace

Iamtm, Ctrl+H IoItfm D]tbmKnpw sSIvv ammw. Replace t_mIvkn Find-teXp t]mse Look in Hm]vj C. t^mapeIfntebpw ncaqeyfntebpw (Constant values) sSIvv `mKsf IsWvSn amp IbmWv Replace sNpI. Hcp IWpIqens ^es IsWvSmt\m ammt\m Replace-\v Ignbn. skeIvSv sNbvX Hsknse sSIvv Replace D]tbmKnv ammw. Asæn Replace All _Wp]tbmKnv Hcp hvjonepXp apgph ammw. amtWvSXmb sSIvv `mKw C\nsbmcnSpansöv hm Excel Amcyw Adnbnpw. Atm Close FSpv skv Ahkm\nnmw. FIvskns kvs]nwKv am thUnsetmse, AcspI At\zjn p IWvSp]nSnp Hcp Spell Checker FIvkenepw DWvSv. Hcp hmtm, Hcp sSIvv F{Sntbm, hvjov apgph\ptam Bhiym\pkcWw CXv ]cntim[npw. Tools sa\p hgntbm F7 D]tbmKntm Spell

Check FSpmw. Hscm sk skeIvSv sNbvXv hvjon apgh ]cntim[\ \Smw. Hcp tdn am{XamWv ]cntim[\ \StWvS sXn B tdv am{Xw skeIvSv sNpI. Hcp sknse am{Xw sSIvv F{Sntbm Hscm hmtm thWsanepw Spell

sNv sNmw. CXn\mbn Edit Mode FSpWw. t^mape _mdn nv sNbvtXm F2 Io Aantbm Edit tamsUSpmw. ]cntim[ntWvS hmv skeIvSv sNbvXv Tools- Spelling FSppI. FIvkens Spelling UbtemKv t_mIvkv Word-tXn\v kZriamWv. ]cntim [np hmv sXfn t_mIvkn\v Xmsg FIvkens \nnjvS]Z ImWmw. Ignore, Ignore All, Change, Change All, Add, Autocorrect XpSnb Hm]vj\pI ChnsS bpapWvSv.

http://www.geocities.com/bluemangoaz

http://bluemango.50webs.com/

hvjopI \ow sNpI, tNpI Hcp hv_pn Default Bbn DXv aqv hvjopIfmWtm! CXn hvjov Ckv sNbvXv _pns I\wIqmw. \ow sNbvXv I\w Ipdmw. hv_pn \npw jopI \ow sNm jopI skeIvSv sNpI. BZyw Hcp jov Sm_n nv sNbvXv, Shift Io Aan ASp jov Sm_v nv sNpI. Edit sa\phn Delete- Sheet FSppI. Asæn skeIvSv sNbvX Hcp jov Sm_n ssdv nv sNbvXv Inp sa\phn Delete FSppI. skpI \ow sNptm kw`hnpXpt]mse jopI \ow sNpt mgpw, ASp jopI hnShv \nIm CStmv \opp. Fm, skp I Uneov sNbvX tijw, CStmv \onhcp skpIfpsS hnemkw amdp Xpt]mse jopI ]p\\maIcWw sNsSpn. hv_pn \nv Sheet 2

\ow sNbvXm ]nsbm _pn jov 2 C. A{XXs. hv_pn ]pXnb jopI tNm, Hntesd jopI tNpIbmsW n, Ah skeIvSv sNpI. Insert sa\phn Worksheet skeIvSv sNpI. Default Bb Hcp hvjomWnSpsXn AXn\v hyXymksampw ImWn. AXsæn skeIvSv sNbvX jov Sm_pIfnsemn U_nĢnv sNbvXv Inp sa\phn \nv Insert FSppI. e`np UbtemKv t_mIvkn GXpXcw hvjomWv CtSWvSXv Fv Xocpam\nmw.

Npcp--n...

hv_pv at\mlcamm Format cells UbtemKv t_mIvkv D]tbmKnpI l slUnw KpI s\SpIbpw IpdpsIbpw CSmw l skpIġpw tdpIġpw t_mUdpI

\Imw l tamSn]nSnn Word-teXn\v kZriw l skpIġv \ndw \Imw l

ImtWWvSXv IsWvSm FIvken Find kuIcyw l hv_pn apgph Search

\Sn thWvSXv IWvSp]nSnmw l Find sNbvX sSIvns\ amn asmhnsS shm

Replace _ l FIvken\papWvSv kvs]nwKv ]cntim[I