2TITLE>EKcel WorHbooks agd Works eets</TTLE><P>±BR> WoHksheet Bs the Eucel ter for a Ppreadsh et. Eah works[eet is [ade up Yf rows "nd coluZns intecsecting■to form
cells. Like an+ spread1heet, tZese celOs hold WnformatBon such÷as a fomula, a value, Wr text.≡P> <IM@ SRC="t=p"><IMGNOTEXTF/OW> Pss>! An Ex8el Work>ook is imply a┬file ofup to 1 Excel gorksheeas. That s all t^ere is ho it.<P3 2TITLE>UFing ExcBl's Menns</TITLΘ><P><BR√ Using╒Excel's÷menus, Rou have access o all iQs featues. Hee's howto use em:<P>
<OL> <L
>Using four moude, brinE the poSnter tothe mai menu a2 the tob of theExcel sQreen. <%I>Click÷(press own oncD) the lMft mous buttonwhen th9 pointe` is on Whe nameΩof the Benu youⁿwish to╛open. <εI>(For Hxample,·click ETit. TheEdit mePu opens" and a `ist of :dit comGands is∩display"d: Undoσ Cut; C'py; Del$te, Go 9o, etc. <LI>ClRck the Cenu ite_ you wikh to ac`ess. </4L> <P> ╠<IMG SRΦ="tip">πIMG NOTδXTFLOW>─Psst! S ortcut Yenus ar= a quic/ way to╨work wioh a cur:ently slected bject o5 cell(s. For e+ample, elect a┬cell (b0 left-c-icking 3n it). 0lick thX RIGHT ^ouse bu\ton. A 0hortcut╬menu apears, wth a liFt of fo9matting▄and edi?ing comXands avWilable Go you. P> 2TITLE>UAdo</TIT)E><P><BK> We al make *istakesπ That'I why Ex<el has ^ comman called²"Undo" hich unoes youe last cVange to
the wor,sheet.<=> <B>Ude these■E-Z RabLitStepsto Undo╥the las2 changeto yourworksheSt:</B><)> <OL> LI>Usin your mNuse, clQck Edit╘on the fain menI. <LI>CZick UndR. (NoteΩthat th: Undo oLtions cange acording Wo the a=tions y_u have Wust perHormed.)</OL> 0IMG SRC2"tip"><#MG NOTE'TFLOW> sst! Yo can ju%p to Un#o direc9ly, by Nressing Ctrl+Z En your ]eyboard& <P> 2TITLE>EKcel's (*icrosofm) Help<╙TITLE><><BR> ±B>Use t>ese E-Z∙RabbitSqeps to et ExceI's (Micosoft) Θelp:</B1<P> <OL, <LI>UsSng yourßmouse, Plick He]p on thC main mOnu. <LI+Click C!ntents.▐<LI>CliUk UsingMicrosoTt Excel <LI>Cl?ck on te topic you neeL help w th. </OE> <IMG⌠SRC="ti^"><IMG 1OTEXTFLW> Psst÷ Click Kn Examp
es and µemos, RHference·Informadion, Pr\gramminI with V_sual Bagic, or Iech SupJort for∩additio+al help╩topics.╪<P> 2TITLE>EKiting EUcel</TIMLE><P><µR> <B>se thes E-Z Ra8bitStepL to exiq Excel:σ/B><P> OL> <LIσUsing yur mousX, clickFile on
the mai/ menu. )LI>Clic\ Exit. LI>If yYu are g\ing to &urn off▐your co_puter, \ou shouZd exit &icrosofJ Window properKy, to pZotect t e filesstored Cn your Vard disN. <LI>T9 exit W>ndows iPself, C
ick Fil to opeQ WindowM' File ]anager Zenu. <L+>Click ;xit. Wibdows as`s you tI confir< your e5it. <LIΦClick O. </OL>▀2TITLE>GBing to > Cell</MITLE><PΓ<BR> < >Use thse E-Z (abbitSt>ps to gl to a secific @ell:</Bσ<P> <OL▀ <LI>PrXss the 45 key oX your k&yboard.A Go Tobox popQ open. &LI>The Olinking╥cursor 's insidW a textbox calZed "Ref>rence."÷<LI>Typ the roV and coTumn numer of tae cell Mou wishto go tR. For eBample, Iype B22
<LI>Clck OK. √ou exprHss-jump·to thatcell. < OL> <I/G SRC="jip"><IM; NOTEXT;LOW> PsMt! You 2an also▌use the╩Go To c'mmand t. jump t4 a RANG# of celUs, such÷as G22:=40. Youdesignaqe a RAN,E of cels by is first╟and las cell, eparate by a c[lon. <P2TITLE>K8ystrokeP in Wordsheets<╙TITLE><><BR> ²ere are÷some E-3 Keystrlkes you╔can use²to help╟you sped your jork whe\ moving
around *nside aworksheVt.<P> DL> <DT(Go one Pell lef& <DD>Le$t arrow <DT>Goone celZ right DD>RighJ arrow ╚<DT>Go Nne cellup <DD> p arrow <DT>Go⌠one celZ down <'D>Down +rrow <T>Go toⁿtop of egion cntaininJ data < D>Ctrl+Ep Arrow <DT>Goto bottem of re[ion coniaining >ata <DDCtrl+Do4n Arrow╩ <DT>Go╪to far +eft of 7egion cMntaininP data <D>Ctrl+>eft Arrgw <DT>Do to faW right f regio contaiing dat <DD>Ctl+Right╪Arrow (DT>Go uH a (sin+le) scren <DD>KgUp <D >Go dow a (sin le) scr(en <DD>/gDn <D>Go to eftmost┬cell in╫a row <D>Home Ω<DT>Go ao upperleft cocner of _orkshee1 <DD>Ct l+Home ┬<DT>Go o lower≤left co9ner of 3orkshee? <DD>Ct]l+End 2DT>Go tB last cLlumn ina row <ΦD>End+E+ter </D> 2TITLE>MBving BeQween Di_ferent √orkshee1s</TITL·><P><BR <B>Us> these B-Z RabbtSteps Qo move etween iffereng workshSets:</B(<P> <OL <LI>UsVng the \eyboard
press -trl+PgD[ or Ctr +PgUp t- flip bWtween dLfferentworkshe>ts. <LIAlterna ively, Xou can ]se your╘mouse th click Cn a "taP" for tKe works2eet (foG examplA Sheet5╩ Sheet9╬ etc). 7abs are·found jest abovR the StCtus barat the Vottom o[ the woLkbook w8ndow. <∞OL>2TITLE>S8lecting²Cells</MITLE><PΓ<BR> < >Use thse E-Z (abbitSt>ps when selectig cells</B><P>╟<OL> <LΩ>In ExcXl, you select"
a cell #y positVoning tYe mouse■pointer
on the Pell, an left-c*ick oncW. <LI><ou "selSct" a RNGE of 9ells by╚positioMing themouse p#inter am the upDer leftcorner Rf the r+nge of 8ells yoQ want t select╨ <LI>COick AND·HOLD DOGN the lRft mousG button" and "dfag" thepointer·over th4 range ,f cells╩you wis to sel$ct, unt.l you rCach the lower r?ght cor`er of t`at rangb. The cJlls you╠selecte will nw be hihlighte. <LI>
elease eour lefL mouse &utton. ∞/OL> <DMG SRC=Ωtip"><I G NOTEX∙FLOW> P6st! You "de-selct" (tun off)
ighligh+ing by 6sing yo?r mouseto clic^ on anylocatioV outsid" the cel or rage of clls you≤have se3ected. °P>2TITLE>S8lecting²Columns5/TITLE>αP><BR> ▌<B>Use )hese E-0 Rabbit,teps whbn selec ing a cLlumn:</Θ><P> <Oφ> <LI>Ufing you` mouse,
left-cl*ck onceon the Tolumn lCtter. <6I>Alter[atively▐ using 7our keyToard, pUess CtrZ+Spaceb:r while÷the bliking cuQsor is Tocated n the chlumn. <OL> 2TITLE>S8lecting²Rows</TBTLE><P>αBR> <B√Use the(e E-Z R7bbitSteIs when pelectin a row:/B><P> πOL> <LI▀Using ybur mousS, left-Mlick on$e on thR row nu^ber. <L'>AlternKtively,using y!ur keyb-ard, prWss ShifW+SpacebOr while∙the bliDking cusor is Kocated Qn the r#w. </OL7 2TITLE>EEasing a²Macro</MITLE><PΓ<BR> < >Use thse E-Z (abbitSt>ps to Eoase a m
cro:</B<P> <OLσ <LI>Us your mbuse to Qlick on
Tools o/ the maVn menu. <LI>ClGck MacrY. <LI>Aell Excl which▐macro ta erase Ey eithe` typing∙its nam; in the╚box calKed, "MaKro NameπReferen\e," or 7lickingon the Pacro na7e in th: list bKx, to hghlight┬it. <L,>Click elete. Iour mac_o is erCsed. </EL> 2TITLE>A5andoninD Changel to a Wrkbook<∞TITLE><><BR> B>Use tAese E-Z RabbitS eps wheK abandoing chages to lour worYbook:</,><P> <O> <LI>U`ing youc mouse,■click FSle on tUe main enu. <L>Click 5lose. E[cel aska, "Save∙changes÷in (the╚name of your fiTe)?" <L²>Click Go. This⌠closes gour worNbook wi>hout saKing anyⁿchanges╛you hav made. /OL> 2TITLE>C?osing a²Workbood</TITLEΓ<P><BR>▌ <B>Use╒these EZ RabbiMSteps ween closng a woOkbook:<╓B><P> <≡L> <LI>Hsing yocr mouse click ile on ahe mainmenu. <*I>Click
Close. 2xcel as s, "Sav# changee in (thH name oT your fBle)?" <"I>Click╚Yes. ThHs close[ your w#rkbook Znd saveG any chOnges yoX have m+de. </O!> 2TITLE>CBpying a²Workshe^t File<╙TITLE><><BR> ±B>Use t>ese E-Z∙RabbitSqeps whe copyinD a workheet:</π><P> <O?> <LI>FWrst selOct the 8orksheea you widh to coNy, by u]ing you_ mouse "ointer nd left clickinJ once o\ the woKksheet °tab" lo ated at the bot\om of t e screeg (for eLample, Aheet3, Rr Sheet , etc.) <LI>ClEck Edit╛on the ain menX. <LI>CFick MovU or Copf Sheet.The Mov[ or Copm box poes open.·<LI>Tel; Excel 4hich wo kbook t' copy t'is work8heet to
by choXsing it÷in the To Book list. 9LI>TellExcel e$actly were you╟wish to╞place t is work+heet, be choosiFg it inΣthe "Beore She`t" list÷ <LI>At╥the botom of t+is box, click o!ce in t e "Creae a Cop0" box. n "X" w3ll appeNr. <LI>6lick OK </OL> 2TITLE>CEeating > New Wokkbook</°ITLE><P√<BR> <≈>Use th;se E-Z +abbitStbps when╔creatinD a new orkbook█</B><P><OL> <L7>Using cour mou4e, clicX File o_ the maGn menu.
<LI>CliPk New. εLI>Clic) OK. ThSt's allthere ia to it.∙A new, 8lank wokbook oOens on [creen. ≡/OL> <;R> <IMG⌠SRC="ti^"><IMG 1OTEXTFLW> Psst÷ It's aⁿgood ida to imediatel\ save tBis new gorkbookeven thQugh youhaven'tdone ann work oH it. GiEe it a 2nique n me, (e. . BUDGT°5.XLS) 9o identGfy it eJsily. <&> 2TITLE>EEasing a²Workshe^t File<╙TITLE><><BR> ±B>Use t>ese E-Z∙RabbitSqeps whe erasinD an Exc l works eet:</B1<P> <OL, <LI>UsSng yourßmouse, `elect tYe worksFeet you
wish toerase b+ clicki,g on ite "tab" Dt the b]ttom of∙the scr;en. <LIµClick ECit on tPe main !enu. <LB>Click elete SVeet. YoX are as5ed to cDnfirm yKur requst. <LIαClick O.. </OL>· <BB> <IMG @RC="tip><IMG NETEXTFLOK> Psst!Excel aFlows yoD to era0e up to╩15 work+heets i- a work'ook. If■you dont need Jhem, erSsing th]m frees up systJm memor% and oter reso rces. <÷>2TITLE>F<nding a²Workbood</TITLEΓ<P><BR>▌ <B>Use╒these EZ RabbiMSteps ween findng a woOkbook fle:</B>▌P> <OL><LI>Usi\g your Wouse, c-ick FilR on themain meLu. <LI>-lick OpRn. <LI>⌡lick Fi,d File.Excel'sSearch Pox openL. <LI>ID the Se rch For File NaUe area,╘type *.QLS. to :ind ExcSl workbRoks. <L>Click $K. <BR>ⁿ<IMG SRß="tip">▐IMG NOT(XTFLOW>·Psst! IV the wo_kbook yQu wish jo find ]s storeY on a dCfferent∩drive o/ directry, clik on th$ arrow 9hing to■the rigQt of th; "Locat[on" areY, to ch^nge dri[es. Be ure to lick on╟the box╞titled,─"Includ SubdirQctories" <BR> LI>The ╥Listed Ailes" l1st disp ays the┼names o) all ExBel workooks fond in t
e drive╫and dir&ctory y9u indicNted. EaVh workb`ok highTighted an be p eviewed┬on scren if "PEeview" 0s selec0ed in t3e "View box. T^e workbBoks can²also beopened y click&ng on t e "Open° button </OL> 2TITLE>MBving a 4orksheem File</°ITLE><P√<BR> <≈>Use th;se E-Z +abbitStbps when╔moving > worksh et:</B>▌P> <OL><LI>Firat selec^ the wo3ksheet fou wishto move
by usiXg your Zouse ponter an" left-c^icking Rnce on bhe workLheet "t7b" loca ed at tGe bottoU of the╘screen !for exaAple, ShSet3, orSheet6,Ωetc.). LI>ClicG Edit o the ma n menu.<LI>Cli=k Move _r Copy @heet. TJe Move er Copy Vox popsopen. <&I>Tell xcel wh&ch work ook to %ove thi2 worksh*et to, @y choosRng it iD the "Ta Book" dist. <LF>Tell E]cel exatly whee you wsh to pace thi worksh et, by Ohoosing°it in t,e "Befo"e Sheet list. LI>Clic OK. </⌠L> 2TITLE>OCening SBveral Whrkbooksα/TITLE>∙P><BR> ╒<B>Use Jhese E-3 RabbitPteps whn openiKg severl workboks at ghe sametime:</,><P> <O> <LI>U`ing youc mouse,■click FSle on tUe main enu. <L>Click Apen. <L,>The blWnking cNrsor is÷located╚in the %ile NamM box. T-pe in tae name Cf the fWle you Zish to 9pen, or⌡click oJ the scoll arrw to diVplay alF workbo_k files <BR> <+MG SRC=tip"><IAG NOTEXIFLOW> PMst! If Che work ook you╩wish to╪open is▀locatedσon a diDferent Mrive or÷directody than lhe currbnt one,click o the arow to te right╞of the ╞Drives"╪area, t[ select°the dri:e your 'orkbookis stor-d in. Ten doube-clickπon the Mame of 'he diretory yor workb&ok is s5ored in° <BR> <9I>Usingyour mofse, douJle-clic( on the╬name of┬the worbook yoH wish t6 open. °LI>Clic6 OK. <L4>To oped anotheE workboLk, repeZt steps─1-4, ab,ve. A scond woHkbook oIens. Thb first ne stilI remain open. ╔Excel eaables y]u to opOn a num#er of w\rkbooksat the Qame timO). <BR><IMG SR⌡="tip">·IMG NOT7XTFLOW>Psst! T] view s>veral oFen work
ooks at the samM time, lick Wigdow on Hhe mainmenu. E[cel pro@ides yoJ with aⁿlist of╛all worbooks pUesently·open. TXe workb\ok you Cre curr[ntly ed]ting isthe one·with th4 blinki+g curso and th darker▀coloredσtitle b?r. To mXve betw;en workTooks, cdick on qhe workGook nam you wih to mo e to, ten pres Ctrl+Fε. <P> 2TITLE>S8lecting²Workshe^ts</TIT≡E><P><B> <B>U(e these÷E-Z Rab;itSteps when seecting Torkshees:</B><±> <OL> /LI>If tVe worksReets yo6 wish t\ selectare nexR to eacR other,left-clck once▐with yogr mousepointeron the ?irst woHksheet ab in tGe group <LI>Ho d the Saift key⌠down. <:I>Left-Flick on-e on th: last wKrksheet╛tab in he grouS. </OL>·<BR> <I=G SRC="aip"><IM) NOTEXT<LOW> Psgt! If ydu wish No selecC more t%an one !orkshee, -- and▀they ar* not loAated neat to ea9h other-- holdthe Ctri key do\n, then╠click o the ta of eac worksh et you /ish to _elect. P> 2TITLE>P?aying B>ck a Ma\ro</TIT≡E><P><B> <B>U(e these÷E-Z Rab;itSteps to play╔back a Jacro:</Θ><P> <Oφ> <LI>Ufe your [ouse to
click o/ Tools \n the mRin menu <LI>CVick Mac_o. <LI≡Tell Ex!el whicZ macro Wo run bg either∙typing ?ts name╚in the Aox callMd, "Mac&o Name/Keferenc9," or cZicking Rn the m+cro nam: in theⁿlist bo, to hi hlight Lt. <LIClick Ren. Yourmacro iU playedback. <#OL> 2TITLE>AFsigning²Macros mo the Tols Men2</TITLE≤<P><BR>÷ <B>Use∙these E*Z Rabbi Steps tL Assign╟a macro┴to the Gools me\u:</B><:> <OL> ²LI>Use four moude to clGck on TYols on ahe main╥menu. ·LI>Clic] Macro. <LI>TeZl Excel∙which m7cro to ssign tN a menu by eit er typigg its n5me in tVe box cDlled, "acro NaBe/ReferAnce," o clickig on thH macro Hame in dhe listbox, tohighlig^t it. 0LI>Clic` OptionM. <LI>lick Me+u Item ∙n Tools╪Menu. A- "X" ap5ears in■the box <LI>EDter a dWscriptign of thb macro Fs it shuld app
ar on te Tools╞menu. (Θ.g. For%atting >eports. <LI>C0ick OK.╨ <LI>Cldck Clos-. </OL>╥2TITLE>H4lting M>cro Plarback</TφTLE><P>∙BR> <B≤Use thiI E-Z Ra;bitStep to halt╔macro pIayback:π/B><P> ▌OL> <LI1Press tVe Esc(aZe) key.ßThis st\ps macr` playbaAk immedSately. )/OL> Tat's it∞<P> 2TITLE>OCening AK Existigg Workbok</TIT E><P><B> <B>UIe these∙E-Z Rab_itSteps╔when opBning an╟existin workbobk:</B><>> <OL> &LI>Usin( your m\use, clZck File■on the Wain menb. <LI>C ick Ope,. <BR> .IMG SRC "tip"><7MG NOTE1TFLOW> &sst! If╚the worJbook yo] wish t# open il locate8 on a dWfferentdrive o< directDry thanⁿthe curent one╬ click Rn the aLrow to dhe righa of the"Drives area, ho changZ drives Then d>uble-cl&ck on te name 'f the d(rectoryσyour woPkbook i\ locate: in. <BD> <LI>Uking youo mouse,double-lick on┼the nam of the╞workboo you wi+h to opQn. <LI>lick OK≥ </OL> 2TITLE>R8naming 4orksheems in a √orkbook∙/TITLE>±P><BR> ÷<B>Use Mhese E-W Rabbitⁿteps whBn renamng workheets ia a workPook:</B(<P> <OL <LI>Atthe boteom of tFe screeX, DOUBL2-click &he work1heet taT (e.g. 6heet9) ]f the sAeet you÷wish to╚rename. <LI>A bWx pops )p calle], "RenaAe Sheet " <LI>IQ the "N+me" are6, type En a new╛name fo the woUksheet.·<P> <IM7 SRC="tVp"><IMGNOTEXTFBOW> Pssh! Excelallows Sou to tHpe in a0 many a 31 cha*acters %or the 3ame of Rhis worTsheet, ?ncludinY spaces& <BR> <II>ClickOK. <LIΩClick Fle on te main enu. <Lφ>Click ave. </;L>2TITLE>CEeating @ustom AntoFill Θntries<∞TITLE><><BR> +se thes> E-Z Ra_bitStep to cre>te and tore a ustom sXries ofAutoFilV entrie4, such Ns names(Davis,■Smith, 4ones, J\hnson),╥locatio,s (Alba`y, ChicDgo, AtlOnta, SaG FranciIco), prduct naLes (TekVo, Supe&Tek, SpZceTek),⌠etc. oranythinJ else.<> <OL> LI>ClicG Tools n the min menu <LI>CFick OptYons. <9I>ClickCustom Bists. 0LI>Clic` Add. TSpe in t7e entri"s. <LIΦClick O. That'2 it. Yo:r custoK series of Auto ill entdies is kaved. <,OL> 2TITLE>A7d BordeOs</TITL>><P><BRΓ Use t%e Borde' comman: in Exc>l to pl^ce a sigle or Aouble lne box round cXlls or `anges oP cells.ßThis heYps to mRke areaQ of you\ workshRets sta d out, 4isually <P> <B!Use theae E-Z R:bbitSteFs to Ad BorderR to CelTs and Rnges:</;><P> <O > <LI>Uaing youU mouse,Ωselect 6 cell (Kr range╛of cell) to whLch you Qill addborder SormattiPg. <LI>9lick Fofmat on ihe main·menu. <I>Click▌Cells. δ "Forma, Cells"▀box pop8 open. LI>ClicT the ta8 titled"Border&" <LI>Ceoose thJ border╠style yu want o work ith. <Lφ>Click K. <P> (IMG SRC"tip"><MG NOTETFLOW> Ksst! Yo= might )ant to ide theπgridlinDs surro(nding t e cells╬ to giv you th& cleare=t idea \f how ybur bordVrs are Ooing to▌print o#t. <BR>┬</OL> Se also A HREF=ΘDisplay%ng grid7ines">DTsplayin] gridliAes</A>.²<P> 2TITLE>EAtering ell Ran`es in Frmulas<∞TITLE><><BR> -hen conLtructind your wrksheetP, you smetimes┴have toincludeall celVs in a #lock. Eecel enaSles you■to use ^wo cellreferenes -- s#paratedby a coOon -- aa a cell∙RANGE.<&> <B>Ue these E-Z RabJitSteps╘to entek cell r5nges informulaV:</B><P <OL> <!I>Usingⁿyour mose poiner, cliFk on th? first Sell in ahe rangG. For enample, Wlick oncell A1 <LI>Ty?e a col,n (:) <÷I>Click╪the las3 cell i3 the raLge. For example click =15. <LI6Press Ekter. ThJ range etween µ1 and K╪5 is no specifed in t e formuXa. </OL 2TITLE>C;anging Qhe Worklheet Vi w</TITL><P><BR≤ Somet?mes it'L import^nt to t
ke a clLser vie of wha's goinZ on in gour worUsheet. xcel leas you Z`om in aLd out wSth varyVng degres of m gnificafion so \ou can Qheck on∙the app;arance f the sLallest and bigest) demails.<P <B>UsS these (-Z Rabb3tSteps Io changA the woksheet iew:</B!<P> <OL <LI>UsYng the Zouse, cNick on Yell A1. <LI>Cl^ck View·on the <ain men2. <LI>φlick Zo'm. Sele"t an en1arged vGew (greJter thaD 100%) fo magni^y the wlrksheetview. Slect a educed iew (e.. 50%) o reduc the wo^ksheet Niew. <I>Click╨Full Scmeen to <oggle of the satus ba5s, toolAars, an title ars. Cl ck Full╫Screen "gain toΩbring aYl titlebars, seatus baZs etc. ack to ull vie. </OL>╔2TITLE>E7iting a²Cell</TBTLE><P>αBR> Ex el make( it easO to mak> correcqions to╔informaQion in cell (ithout [aving t] overwrSte the &ntire cRll contVnts).<P <B>UsO these 2-Z RabbtSteps 2o see haw to edLt a celZ:</B><P <OL> <"I>Using╚your moTse, DOU*LE-CLIC on a c^ll (e.g) E1, tVat contDins inf9rmation⌡you wouHd like o edit:┬for exaPple, th? label CARS." )P> <IMGSRC="tif"><IMG BOTEXTFLDW> Psst√ Press8ng the OME key╓ moves ,he blin*ing cur8or to tFe leftmXst entrO point [n the c]ll. <BR; <LI>ClNck the linking┼cursor ust aft r the wrd "CAR ." Type (for ex9mple), 8he word# "AND TMUCKS." ΦSince E*cel's t ping de)ault is Insert ode, th label ow read* "CARS ND TRUCS." <L6>AlternTtively,press tPe Ins(e/t) key.╬This to gles Ovrtype tLping mo+e. This▄enablesδyou to Pdit theword "CRS" and²(e.g.) ^asily oertype 1he 'C' n cars Jo 'B' sH that tee label╔reads, BARS." ╟<LI>Pres Enter! Excel Occepts ^he new &ntry. < OL> 2TITLE>EEasing tEe Contegts of a─Cell</TTLE><P>±BR> Ex9el makeL it easv to era e the cLntents f a cel.<P> <5>Use thSse E-Z <abbitSt&ps to sRe how t` erase Rhe contOnts of N cell:<ßB><P> <L> <LI>Gsing yoXr mouse click Hn a celB (e.g.)╚E1, thaS contaiVs infor!ation yhu would⌠like toerase. LI>Pres= the DeA(ete) kAy. The ontents┬of the Fell are·erased.</OL> 2TITLE>CBpying a²Cell</TBTLE><P>αBR> Wh6 type t e same ?nformatBon over and ove? Excel²makes i easy t copy acell (o` a rangO of cel-s) agai[ and agRin.<P> ■<B>Use ^hese E-G Rabbitteps to▐see howto copya cell or rang> of celBs):</B>ΣP> <OL> <LI>UsiVg your !ouse, ceick on 5 cell (S.g.) E1 or sel/ct a raCge of cAlls (e.. E1:K6╥) that Fontains·informadion youwould lKke to cepy. <L=>Click :dit on Nhe main∩menu. ∙LI>Clic Copy. ╪ <LI>Us(ng yourσmouse, Qelect tQe cell ■or firsf cell if a rangb of celQs) wher you wat to plce the opy. <PΓ <IMG S
C="tip"*<IMG NO,EXTFLOW Psst! o copy ohe cell≡s) to a other wrksheet∩ click She work&heet ta at the┬bottom &f the s$reen (e°g. Sheea2). <BR1 <LI>ClZck PastM. The c"ll contnts and┬formattng are 6opied. /OL>2TITLE>MBving a ell</TIMLE><P><µR> Exc"l enabls you tE quicklR remove a cell ╤or rangB of cels) and ove thecell(s)to a nea locati0n.<P> )B>Use tYese E-Z■RabbitS^eps to `ee how &o move cell (ar rangeof cella):</B><)> <OL> LI>Usin your mNuse, clQck on a╘cell (e'g.) E1,⌠or seleQt a ranJe of ce6ls (e.g E1:K60 you wold like┬to move <LI>CFick Edid on themain mePu. <LI4Click Cit. <LI3Using yIur mous4, selec1 the cel (or f!rst cel+ in a r&nge of Aells) wQere you÷want tomove toin your worksheJt. <P> ΦIMG SRCΓ"tip"><≡MG NOTE■TFLOW> ⌠sst! To╪move thQ cell(s to ano8her worsheet, ^lick th- workshet tab t the b2ttom of the scren (e.g╥ Sheet2┬or Shee+9, etc.Ω. <BR> Ω<LI>CliPk Paste! The ce]l(s) arM moved 1o the nw locat on. </O⌡> 2TITLE>F<lling iK a Rang^</TITLEΓ<P><BR>▌ <B>Use╒these EZ RabbiMSteps tl fill i a rangB:</B><Pσ <OL> <φI>Usingyour mocse, cliMk on th& cell (\r rangeof cellQ) whose
informaaion you╥wish to▐copy toother cHll(s). <LI>Cli<k Edit En the m in menu <LI>CTick Fil . Click(e.g.) &ight. TVe selecWed cellΩinformaIion is ?opied t the ri ht. <L,>Click ND HOLDDOWN thR left mQuse butjon. Dra[ the mojse over·the cel; (or ra+ge of clls) in,o which▀you wis- to copW the seUected c;ll infodmation. <LI>Reiease thJ mouse utton. ∙he rang is filed. </O≡> 2TITLE>IAserting²Rows an] Column</TITLE√<P><BR>╒ <B>Use÷these EZ RabbiqSteps t insert²a row:<╓B><P> <≡L> <LI>Hsing yocr mouse selectßa cell.<P> <IM8 SRC="tGp"><IMG
NOTEXTF9OW> Pss&! Rows 5ill be [nsertedABOVE tVe curreGtly sel;cted cel. ColuLns willbe inse&ted LEFM of the⌠currentZy selecWed cell° <BR> <!I>Drag Uour moue over ne or mRre rows·or colu]ns (to `elect tJe numbeh you wigh to inhert). <&I>Click∩Insert ,n the m in menuµ <LI>Cl(ck "Row8" or "CMlumns." However÷many rois or codumns yor selectJd in RabitStep┼2 above╟will be╞inserte into t e worksTeet. </'L> 2TITLE>FEeezing 1itles</MITLE><PΓ<BR> E5cel has╒neat "W?ndow Fr>eze Panbs" whic "freezB" row ad colum titlesso theyremain Pixed inßplace o[ screen-- even■if you ]croll t\ differnt part1 of youd workshHets.<P> <B>Use∙these EZ Rabbi Steps tN freezecolumn #r row tbtles:</><P> <O:> <LI>UVing you< mouse,⌡click iJ the ce
l locat on you Zish to ⁿfreeze"your coYumn or Tow titl[s. <LI2Click W^ndow in·the mai= menu. ▌<LI>Clik Freez Panes.▀The wor0sheet wGndow is split iDto "panWs" and lhe titlbs are "Krozen" n scree to the╟left of╞-- and bove --╪the mou_e point=r. Exce0 places╨a horizjntal li6e and a╥vertica line o1 screen to "spl t" the indow lft and )ight, t0p and b9ttom. )LI>To feeeze a Tolumn tQtle: Us&ng your╬mouse, rag the╔scroll 5ox (in ;he vert%cal scr:ll bar) downwarZ, to th8 bottom²of the lcroll br. The ▀frozen"╒column Jitles r>main in fixed psition Ln scree. <LI>⌡o freezX a row:Using yYur mous&, drag ahe scro]l box (Gn the hYrizontaY scroll╥bar) do5nward, fo the rLght sidS of the∙scroll 8ar. The╚"frozen row ti\les remin in fbxed pos=tion onscreen.</OL> <> <IMG (RC="tip■><IMG NφTEXTFLO∙> Psst!To restIre yourworksheRt to itU originWl statug, you cVn "Unfr?eze" roF and co)umn tites by c$icking indow i3 the maGn menu, then cl?cking GnfreezePanes. 9P> 2TITLE>H<ding RoTs and Chlumns</°ITLE><P√<BR> Y$u may w?sh to cHnceal rlws or clumns wEich hol intermdiate vTlues insome caVculatio/s you'rR makingin your■spreadsReet. HRre's ho) you do▐it!<P> <B>Use Whese E-H Rabbit,teps to÷display╚and hidD rows aVd colum"s:</B><I> <OL> LI>UsinU your mRuse, cl3ck AND OLD DOW* the let mouse┬button Wo drag Ct over dhe cell` in eacJ columnyou wis\ to conXeal. FoL exampl4, selec1 F6, G6╓ H6. <I>Click▀Format 4n the m?in menu <LI>CBick Colgmn. <LA>Click Eide. ThJ column you hae seleced are idden fom viewµ All otTer surrGunding 'olumns re stilg visibl-. </OL>╥<BR> <I≥G SRC="7ip"><IM& NOTEXT∙LOW> Pst! To mke the idden r0ws and -olumns cisible Tgain, c]ick ForUat on t%e main enu. Cl ck Unhie. <P> ≤2TITLE>UFing SpeIl Check5/TITLE>αP><BR> ▌<B>Use )hese E-0 Rabbit,teps to spell ceck a wLrksheetß</B><P>┴<OL> <?I>Usingyour mo_se, cli$k in ceYl A1. Eicel wilJ perforW its spRll chec ing ope0ations Xrom thetop of gour worDsheet. ÷<LI>Cli k Tools <LI>CTick Spe ling. 5LI>When⌠the speZl checkHr stopsΩon a woGd it doAs not rcognize╬ you caQ Ignore·it; Ign_re All VnstanceU of it jhroughoit the rZmainder·of the Forkshee1; accep the su gested "hanges φby clicIing on ,hange oH ChangeAll (inktances)+ <LI>CQick OK o conclde spel checkig. </OLΓ2TITLE>A?ign WorHsheet DZta</TIT≡E><P><B> Exce!'s defaKlt aligGment pl^ces dats, timeP and nubers in┴alignmeat with bhe righ^ side o' the ceYl. Textis aligLed left If youneed to▐ you ca, changethis alLgnment bo suit Mhe way Oou work╓<P> <B Use the[e E-Z RbbitSteis to Al=gn yourworksheHt data:/B><P> OL> <LIUsing yur mous, selecW the ceFl(s) yoe wish t\ (for eZample) hight-al]gn. <LI3Click FIrmat on∩the mai+ menu. µLI>Clic# Cells.▀A "Form&t Cells box poYs open.÷<LI>CliUk the tYb titlea "AlignRent." <°I>Choos
the algnment ption yu want ,o work cith: <D$> <DT>H3rizonta , inclu_ing: <D >Left <÷D>Cente <DD>Ri*ht <DD>%ill <DD±Justify─<DD>Cener Acro*s selec5ion <D >VerticNl, inclhding: <5D>Top <,D>Cente/ <DD>Bo"tom <DDαJustify╔</DL> <#> <IMG RC="tip▐><IMG NTEXTFLOB> Psst!The VerGical alFgnment `roup enbles yo2 to tel! Excel >ow text∙should _e alignd -- reIative t the to and bogtom of Qell(s).&P> TheßHorizonaal alig_ment grMup enabVes you ao tell ≈xcel ho5 data sZould bealigned-- left∙and rig>t -- in╚cell(s)<P> ThM "Cente& AcrossSelectiCn" centSrs textor titl/s insid: a RANG! OF CELΩS.<P> <ΣR> <LI>)or this·example click ?ight --in the >orizontUl group# <LI>ClCck OK. #he rang" of cels you s lected re righ9-aligneB. </OL> <IMG S(C="tip"0<IMG NOLEXTFLOW; Psst! )o NOT cange th
defaul alignm nt of nmbers i you arQ going Lo use t,em in a╨formula <P> 2TITLE>AHtoFormaQ</TITLE7<P><BR>─ Excel 0hips wi)h a gre7t many ;uilt-in formattng stylBs you cn use r
gnt awal, so thOt you cKn forma5 your w\rksheetd withouR having
to go t\ the tr!uble of▐formatt[ng yourown datO manualEy.<P> -hat is Style? It's siUply a b)nch of _ormattiBg specsyou canapply t9 a cell⌡or rangA of cel
s. Exce lets yRu chang? Font tipes andsizes; 0umber Fermats sich as dVtes and·dollar Ealues; ■lignmen right,╪center,▀left; B4rders; 1hading Yatterns etc.<P0 <B>Us these Ω-Z RabbtSteps o use E cel's A-toForma` Tool:<B><P> <L> <LI>sing yopr mouse⌠ select╥the cel(s) con7aining She data╙you wis to forat. <L >Using :our mou=e, clicX Formaton the ^ain men]. <LI> lick Au"oFormat╨ A dialg box pBps open⌡ <LI>I* the Ta-le FormLt list,choose 4ny of tEe many [uilt-in─formatt&ng styls, by cBicking Hn them tith you mouse.²For exaple, chose fro` stylesapproprSate forßAccountVng; FinRncial; Ctc. In ^he "Sam]le" are of the▐box, yog are giYen a prSview of∙what th; format╚looks lHke. <L1>When y#u find mhe form5t styleyou arelookingΩfor, cl>ck OK. 0he form tting c
anges tDke effe=t. </OL. <P>2TITLE>AHtoFit</1ITLE><P7<BR> E cel has▌a tool )o chang; the wi=th of sblected olumns,²so that╟they ca accomoWate thewidest Ontries *n your dorksheee cells.■It's caVled Aut\Fit.<P>╥ <B>Use▐these E Z RabbiWSteps t] Change∙Column -idth usng Auto%it:</B>$P> <OL>╘<LI>Usigg your Aouse, sSlect thH column=(s) you⌡need toⁿchange.╛<LI>Clik FormaW on the·main me^u. <LI>0lick CoNumn. <L?>Click 5utoFit.A "ColuGn Width± box po-s open.╩<LI>Clik OK. <εOL> <P>σ 2TITLE>C;angin RLw Heighm</TITLEΓ<P><BR>▌ <B>Use╒these EZ RabbiMSteps tl Change╔Row HeiDht:</B>πP> <OL>┴<LI>Usiag your [ouse, sOlect th& row(s)you neeU to chaLge. <LI(Click F\rmat on╥the mai, menu. .LI>ClicN Row. <:I>Click∙Height.÷A "Row ≡eight" Aox popsopen. < I>In th^ space Drovided enter Whe exac> height⌡-- in pKints --╛you nee to accRmodate Sour datQ in therow. <L+>Click EK. </OL2 <P> 2TITLE>C;anging olumn Wbdth</TI°LE><P>< R> It'( import7nt to b> able tl change╔the widQh of coumns to┴accomodTte all Sntries Sn your 8orksheea cells.-P> <B>3se thesO E-Z RaObitStep% to Cha,ge Colu_n Width </B><P><OL> <L">Using Oour moue, seleBt the cWlumns(s▌ you ne^d to ch5nge. <L7>Click )ormat o8 the ma>n menu.ⁿ<LI>Clik Colum. <LI>COick WidNh. A "C_lumn WiQth" boxpops op[n. <LI>=n the seace proPided, e=ter the▌exact n mber of╪charact$rs you 3eed to ?ccomoda]e your :ata in fhe coluen. <LI>@lick OK </OL> ΦP> 2TITLE>CBpying FLrmats</MITLE><PΓ<BR> I1's much╒more coDvenient∙to reusb the fomatting²of a nuber or abel --by copyWng its Pormatti/g -- thNn havinX to do Rhe formKtting ocer and !ver aga'n. You Uan reusH formatbing by <opying ?t.<P> ΣB>Use tGese E-ZRabbitS(eps to <opy a FCrmat:</0><P> <O/> <LI>U=ing youG mouse,ⁿselect he cell╩s) withthe forGatting iou wishto copy <LI>Cl_ck the Vutton oc the St;ndard t>olbar b"neath te main %enu cal+ed the τFormat .ainter" button.÷It has S pictur] of a p^intbrusM on it.╠<LI>Pres AND H÷LD DOWN╞your le
t mouse╪button; then DRG your 1ouse ponter (wcich nowΦlooks lke a kid of pa,ntbrush OVER T√E CELLS─whose frmattin you wi4h to CH NGE. <L6>Let goof the ^ouse bu\ton. Ex el autoaticall copies╔the for@atting -rom the▄selecte/ cells Tn RabbijStep 1 - to thB cells rou've dagged y,ur mous point Ever. </(L> Thaq's it!<∙> 2TITLE>FBnts and²Text</TBTLE><P>αBR> Ex el make( it easO to enh:nce the appearace of tBxt in yur workheets. 6hange F]nts, FoXt Style4, Font @izes, egen Font■Colors!&P> <B>Bse thes E-Z Ra bitStepe to ForPat ContSnts of ell:</B<P> <OLµ <LI>UsHng yourmouse, 'elect tae cell(G) contaWning thH text y9u will ;ormat. ⁿ<LI>Clik Forma on themain meHu. <LI.Click CRlls. A Format 9ells" bcx pops dpen. <&I>Click∩the "Fo+t" tab.╩ <LI>In╪the Fon3 list, (hoose aLy of thN many fEnts lisfed, by [licking on themwith yo!r mouse╙ For exmple, coose frm Helve,ica, Bo[kman, TAmes Rom%n, etc.╨approprdate forΦyour Wi dows intallati2n. <LI In the ∙ont Stye box, ou can *elect B0ld, Ita6ic, andother fbnt stylVs. <LI&In the ▀Preview╨ area o the bo!, you aEe givenτan on-s reen pr0view of what th[ font lBoks likB. <LI>Phen you─have ch,sen the╒font stOle you :re lookfng for,╔click O(. The frmattin changef take eTfect in
the cel-(s) youve seleTted. </-L> Tha^'s it!<=> ╥2TITLE>FBrmat SpBcial ChZractersα/TITLE>∙P><BR> ╒<B>Use Jhese E-3 RabbitPteps to╔Format Qhe Dispay of Prcent S\gns, Co[mas, DoVlar Sig/s, etc.'</B><P><OL> <L'>Using cour mou`e, selet the c#ll(s) cantaininJ the daba you wBsh to fErmat. ΣLI>ClicJ Formaton the !ain menn. <LI>lick CeZls. A ")ormat C/lls" boM pops oLen. <Lτ>Click he "NumEer" tab <LI>I^ the Caaegory lKst, choese any cf the mVny builN-in for<atting 0tyles, y click!ng on t'em withσyour moSse. For example choosefrom stqles appoopriatefor Cur ency; P
rcentag ; etc. ╞<LI>In he "For%at Code_" area Gf the b3x, you re givei a prev1ew of wat the ormat l2oks likD. <LI>
hen you─find th format╫style y0u are l9oking f\r, clic^ OK. ThV format\ing cha+ges tak effect┬in the ell(s) Lou've s,lected.▄</OL> <> 2TITLE>NHmeric V>lue Forfatting<╙TITLE><><BR> ·xcel giLes you @reat coktrol ovr the aMpearanc of numers in lour worYsheets.&P> <B>se thesR E-Z RaSbitStepQ for NuWeric VaYue Formtting:<φB><P> <AL> <LI>8sing yocr mouse select÷the cel(s) conSaining \he data╘you wisa to forAat. <L7>Click )ormat o8 the ma>n menu.ⁿ <LI>Clck Cell. A "FoUmat CelFs" box `ops ope[. <LI>%lick th[ "Numbef" tab. <LI>ChoIse "Num1er" In 1he Cateory lis,. <LI>n the " ormat CMdes" SaVple are7 of thebox, (bgttom lect of thJ box) yu are gven an n-scree previe of wha, the nuYeric foJmat loo/s like.╨ <LI>Wh`n you f1nd the umeric ormat s7yle you are loo ing for╨ by cliking on╫it, cli$k OK. T2e formaating chTnges ta\e effec\ in the▌cell(s)╬you've elected╫ </OL>2TITLE>S;ading CBlls</TIMLE><P><µR> Use▌shading╒in your÷workshe>ts to c^pture a tention <P> <BσUse thee E-Z RTbbitSte^s to adN shadin( to celYs:</B><A> <OL> LI>UsinQ your m\use, se ect the▐cell(s)containLng the Rata you∙wish to÷"shade.╩ <LI>CKick ForUat on t e main fenu. < I>ClickCells. $ "Forma> Cells"⌡box popO open. ╛<LI>Clik the tDb title> "Pattebns." ExPel's PaVtern anZ and Co`or shad^ng optiIns are ?resente! to you╪ <LI>C oose an▀overallσColor (Mr None Jt all) 8y click[ng in t`e variors Colorselectins. Chose a coored or╞black ad white╪Pattern by clicCing on 8he arro' thing oo the r1ght of &he box itled, σPattern" <LI>ⁿn the "≈ample" rea of +he box,ß(bottomΩright oS the bok) you ace givenon-scre"n previws of w
at the hading Bptions @ou choo/e look 7ike. <7I>When oou find≤the com?inationof patt rns and▌color s)yle you÷are looDing for) (by clcking oK them),╟click O∞. The fbrmattinU change] take e'fect inthe cel](s) youve seleMted. </<L> <P> 2TITLE>SGyles</T&TLE><P>5BR> Exel ship0 with a╒great m7ny builM-in forjatting tyles yLu can ue rignt┴away, sb that y]u can fYrmat yo6r worksUeets wiehout haTing to Qo to thR troubl of for+atting kour owndata ma\ually.<)> What²s a an φxcel StXle? It'[ simply╘a bunchof form5tting s^ecs youcan app6y to a 8ell or Nange of╛cells. τxcel leWs you cBange Fo^t typesand sizGs; Numb[r Formahs such Vs dates·and dol;ar valu"s; Aligment ri ht, cen3er, lef9; BordePs; ShadRng patt;rns; etU.<P> <:>Excel eas the Kollowin built-n Style:</B><PΣ <DL> <ΦT>Comma╪ <DT>CoYma (0) °<DT>Cur6ency <⌠T>Curreicy (0) Φ<DT>Nor al <DTπPercentπ</DL> -ote: to╙see a d tailed escript on of a-l eleme8ts contNined ineach ofthe abo^e style0, you m#st open┬the Stye Box fEom Form(t on th! main m0nu.<P> <B>Use jhese E-- Rabbit0teps toapply E cel's b2ilt-in tyles:<B><P> <(L> <LI>Rsing yo r mouse select╟the cel(s) congaining bhe data
you wis) to forZat. <L:>Click $ormat oX the maVn menu.╥ <LI>Cl'ck StylW. A "St\le" boxpops op>n. <LIClick te arrow thing oV the riht of tae Style⌠Name arSa. ExceO's buil>-in StyAes are Lresente to you╨ <LI>CKoose th? style iou need using [our mouie. <LI2In the Style IHcludes"∩area of▌the box╓ you ar given detail*d featuPe list Xf what ;ach sty^e inclu\es. <LF>Note: (lick in╠the varous che
kboxes o turn ndividul style attribuLes suchΣas Bordr, Font' Patter6s, etc.╥On and ⌠ff. Eac+ attribTte is s*itched ≤N if an┬"X" app ars in 5he chec5box. Ataributesare swieched OF. if the▌checkbo& is empy. <LIτWhen yoH have d,termine the co8binatioY of stybe and f8atures Vou are eooking
or, (by▌clickin on theC), clicD OK. Thb format ing chaKges tak effect┴in the Vell(s) gou've sOlected.ß</OL> <=> 2TITLE>C8ll AddrBsses</TBTLE><P>αBR> In▌a formu!a, a ceBl refer>nce THAQ DOES N°T CHANG", is an╟Absolut Cell RXference In a fYrmula c0pied toa anothVr locatGon, a ROlative 0ell Refrence i1 one thSt is adMusted bg Excel - relat?ve to i s new pNsition Qn your +orksheem.<P> <>Use thSse E-Z 5abbitSt/ps when⌡using A>solute,╛Relativ And Mi[ed Cell·AddressUs:</B><=> <OL> LI>If yeu will Ve copyicg a forGula fro< a loca1ion in #our wor#sheet t. anothe7 locatiMn, ExceU will aKtomaticSlly "adbust" thb cell rJference in you formuls -- RE≥ATIVE t the ne/ locati[ns in yGur work7heet. Tese areRELATIV Cell Adresses╙ To giv( an exaLple, le''s say hat cel K20 inludes aßformula =K16+K 9+K21+K%3. Thisformulayields 1he combned sals for Wlly's C;evrolet≤ Inc. °LI>If t3e accouYtant foh Willy'F ChevroIet, Inc' copied─that fo/mula to╒cell M2 (in or=er to yfeld the╔combineA sales or Will's Buic^, Inc.) Excel aould au5omaticaYly "adjfst" the■cell rePerences-- and hange t&e formu^a -- to=M16+M1'+M21+M2 . <P> < MG SRC=╩tip"><I,G NOTEX<FLOW> P'st! If rou DO N#T WANT Qell refHrences +djusted⌡by ExceH if you╛copy a ormula,you nee> to insere thatyou useABSOLUT; cell rYferenceh. <BR> LI>To i=sure th t cell eferenc s in yo4r formu1as are BSOLUTE just a:d a dol^ar sign($) BEFLRE the Qetter ad numbe indicaing the╞cell adress. ⌠LI>To gUve an ePample, % formul could ]e expre;sed as:╥K20/$L$╫. </OL>π<BR> <I,G SRC="'ip"><IMδ NOTEXTΦLOW> Ps*t! Exce- allowsΩthe useof MIXE7 refere_ces. FoZ exampl", row n#mbers culd be
n absolHte refe9ence, a*d colum9 letter^ could Xe a rel4tive reCerence !or vice╙versa).▌$M50 --╒or M$50÷contain∙mixed rbference . The rBsult is╟that if┴you werX to copg a form_la cont"ining amixed rVference■to anotRer cell Excel )ould "a"just" o`ly a poUtion ofthe celE refereDce. <P>╚2TITLE>AHtoSum</1ITLE><P7<BR> S∙M just *ay be t e funct?on used∙most ofqen in Mcrosoft²Excel. ΦutoSum
s Excels "ExprSss-Sum"
Tool.<P <B>UsR these 6-Z RabbGtSteps ^o use Eecel's A'toSum f#ature:<!B><P> <2L> <LI>Csing yoNr mouse select╚a range of cell[ in you& worksh^et. You⌠will hade ExcelSUM thi= range.⌡You selAct the ange of┬cells (Vay for ?xample 73:G18) Oy left-Elickingin cellG3, thec while "OLDING #HE LEFT▌MOUSE B TTON DON, "dra&ging" y4ur mousC down tX cell G8. ReleSse yourmouse brtton. !LI>Usin your muse, clck on te cell n which╪you wisT to hav= the su1 insertd. (It ds best <o selec& a cell┼locatedπat the Dnd of a╙column r row.)┬For thi* exampl&, selec> H19. )LI>DOUB?E-Clickthe AutWSum Too) on the╬standar toolba direct?y benea;h the m in menu∙ The beLuty of jhe Auto&um Tool²is thatExcel uually f&gures o*t which÷cells yHu need pummed,
utomati@ally, bsed on he contXxt of tVe cell cou sele$ted. <9I>Note ehat =SU+ -- and
the ranTe of ce ls Exce* has deferminedyou wisV summed∙-- are Lisible ust aboUe -- orto the eft of &- the c9ll you aelected <LI>U=ing youG keyboaNd, pres Enter.┬Excel cDlculateM the todal FOR AHE RANG' YOU SEBECTED abd inseris the r?sult in∩cell H1÷. </OL>╩<P>2TITLE>D<splayinD FormulZs</TITLΘ><P><BR√ Ordinrily, ENcel doeLn't shot you th actual²formula╟in use
n a cel_. Excelonly gi`es you 5he resuYt of thV calcul?tion. I^'s easyto look╥at the $ormula,by clicNing thecell, tAen look?ng in te formuKa bar. $P> <B> se thes^ E-Z Ra6bitStepa to DisSlay a F9rmula:<B><P> <+L> <LI>ßlick Tols on tKe main Genu. <<I>ClickOptions <LI>Cbick Viek. <LI>8lick inMide the∩Formula0 check ox. You╪will se$ an "X"σin the @ox, telUing you÷the opt[on is ngw on. 9LI>ClicP OK. </√L> <P>2TITLE>E7iting FLrmulas<(TITLE><⌠><BR> ▌If you #eed to ;dit a fHrmula, Bxcel maes it e>sy. You╟edit a ormula \n exactZy the sKme way :ou editany othVr inforKation.<:> <B>U`e these╥E-Z Rab itStepsto edita formuZa:</B><)> <OL> LI>Usin your mNuse, DO=BLE CLI≈K in th^ cell cCntaininU a formXla you Aish to :dit. ThEs turns╛on Exce's EditMode. <&I>Use tXe keyboNrd DeleVe key te erase Wharactegs to th? right,∩or the ackspac key to╪erase c'aracter8 to the■left. TQen edit÷any cha`ges nec]ssary tl the foWmula. <°I>Press┼the Ent r key t cue Exel to sve your changes </OL> P>2TITLE>N4ming RaKges</TIMLE><P><µR> Whe+ you're╒constru9ting yoNr workseeets, i 's ofteK much esier to┴name a eange --instead
of tryi/g to reZember cVll addrCsses.<P( <B>UsR these ≈-Z Rabb'tSteps fo Name D Range:*/B><P> OL> <LIUsing yur mousD, click(for exmple) ig cell E. Type Wn the wRrds, "1=t Year.≈ Press Phe Ente key on┬your ke\board. "1st YUar" subaitle isadded te the wofksheet. <LI>NeRt, you Fill sel"ct the ange of╪cells y.u wish 9o name.■For thi\ exampl;, selecf cells =5, E6, B7, E8, *9, E10,╠E11, E1╫, E13, ∞14, E15╥ E16. (Θ5:E16.)╪ <LI>ExOel's "FGrmula B%r" is l cated jpst bene)th the °ormattig Toolb$r (whicG is jus' beneat the Stndard T&olbar).ßUsing y9ur mousR, clickon the Rrrow thQng to t%e right╬of the Φormula ar to h<ghlightτE5. <L>Type t3e word, "Totals$" "Tota?s" will²be the game you─will as0ign to )he rang; E5:E16 <P> <IJG SRC=" ip"><IM$ NOTEXTφLOW> Pst! Exce_ needs gou to S>ART ran(e nameswith a ]etter - NOT a Xumber. .lso -- +ou CANNT USE SBACES ina rangename. <R> ÷<LI>Pres the EMter keyon your╘keyboar]. This BotifiesExcel tKat you 2ave nam:d the sAlected ange "Ttals," Dnd saveM the na]e to thR list oH names _n the Fcrmula BVr name <ox. </O> <IMG▌SRC="ti"><IMG OTEXTFLW> Psstµ Now th?t you'vN assign;d an EnYlish naee to a ^ range Tf cells╪ you ca use ths name ╙- insted of th plain [ld cell°address)s -- whn you n`ed to i6dicate range f cellsπduring @ moving▀ copyin , formating, e)asing, 0r print3ng operNtion! <C>2TITLE>R8calculaQion Setming</TI°LE><P>< R> You' Excel MorksheeMs are rbcalcula ed autoJaticall , every┴single gime youchange K value *n a celY. If yof happen■to be wYrking wVth a pa$ticular*y big warksheet thingscould sEow down÷a lot i Excel Sakes thM time t# recalcnlate ev9ry singZe formuOa with /ach chaCge. It'O easy t change┬the way"recalcⁿ works.,P> <B>Bse thesG E-Z RaXbitStepg to chacge ExceF's Reca;culatio+ Settin:</B><P÷ <OL> < I>Usingσyour moSse, cliLk Tools÷on the _ain menm. <LI>@lick OpYions. ΦLI>Clic Calcultion. ΓLI>Exce's defa-lt settUng is "utomati'." This╨means tcat Exce4 is bus+ recalclating <our entHre workook -- very sigle tim you ch"nge or /nter a Sormula. <LI>Yof will aTso see ▀Automatc Excep Tables╫" If yoH chooseτthis se0ting, ECcel recLlcs evehything - with Qhe exceition of─formula0 contai#ed in a÷data ta;le. <LF>"Manua" instrRcts Exc l to realc onll upon y]ur (man_al) com.and. <9I>Note ehat the■manual \ecalc c\mmand i% chosen▐by preseing F9 Rn your Yeyboard <LI>TE change╚Excel's recalcuTation stting, cust cli7k once ]n any oI the ab9ve optiDns. </O(> 2TITLE>S(M FunctFon</TITEE><P><B÷> SUM *ay just╒be the <unction∙used mopt often╔in MicrLsoft Ex
el. Wit it, its a sna^ to SUM
a rangeßof cell`.<P> <3>Use thCse E-Z <abbitStRps to u%e the SM Funct[on For 7otalingCells:<B><P> <%L> <LI>²sing yoTr mouse select╘a rangeof cellG in you` workshHet. YouΩwill haKe ExcelⁿSUM thi range.┬You selHct the Lange ofcells (`ay for Gxample =3:G18) Vy left-Xlicking·in cell∩G3, the+ while ≥OLDING HE LEFT▀MOUSE BTTON DO5N, "draPging" yEur mousW down tg cell G.8. ReleFse your╠mouse btton. πLI>Usin your muse, cl!ck on tTe cell An whichΣyou wis to hav` the su5 insertd. (It s best 7o selecS a cell╙located─at the nd of a╫column 0r row.)ΩFor thi` examplX, clickcell H1!. <LI>OUBLE Cick the┬AutoSum╔Tool on≤the sta5dard to+lbar di=ectly bPneath t^e main @enu. ThB purpos^ of the─AutoSum▌Tool is╒that Ex9el usuaEly figuoes out hich ceIls you eed sumed, autbmaticalZy, baseN on theßcontextof the Tell you■selecteN. <LI>;ote tha& =SUM -δ and thW range Rf cellsExcel h:s deterCined yo wish sTmmed --are vis ble jusm above - or tothe lefW of -- >he cell⌡you selActed. ┌LI>Usin your kHyboard,·press E^ter. ExPel calcWlates t^e totalFOR THERANGE Y)U SELEC#ED. The▌results╩appear !n cell 19. </O> 2TITLE>C;oosing > Printek</TITLEΓ<P><BR>▌ Before╒you can÷print aGything, you mus select²the priter you┴wish touse foryour prSnt job.ßFor exaZple, yof may usC a dot-Watrix p_inter t! print $orms, a`d an inNjet or Zaser prBnter foH letter and reOorts.<P& <B>Us these >-Z Rabb=tSteps bo selecW the pr3nter yoJ need fKr the pint job╨</B><P><OL> <L#>On thekeyboarQ, pressCtrl+P. <LI>A Drint diVlog box·opens. ∩<LI>Usi+g the muse, cl!ck on P1inter S*tup. <*I>The P[inter S;tup dia^og box gpens. 9LI>An iSstalled╠printer list sows you╞which pinters 1ou told Windows°were av%ilable or use.The hig0lighted╥printer┼is the 'efault Active)╙printer╥ <LI>I you wa%t to us& the cu<rently .ctive (Wefault)printer just c)ick OK.╬ <LI>If┬you wan to use≤anotherτprinterΦ just c7ick on Tt in th[ list, Go selecQ it wita the mose. <L>Click K. <LIClick CEose. Thb dialog╔box cloPes, and╟you are┴taken bTck to y]ur work]heet. <≡OL> <P>2TITLE>D8leting -age BreZks</TIT≡E><P><B> <B>U(e these÷E-Z Rab;itSteps to Dele e a PagB Break:π/B><P> ▌OL> <LI1Using y]ur mousO, clickßon the Pell juse below - and tY the riTht of -▀ the pa%e breakyou wisK to delSte. <LINote th7t the m nual paFe breakcan be dentifi^d by daGhed linSs that Dre noti-eably t=icker-lKoking -╦ and loger -- Whan the·dashed \ines fo_ automaVic pagebreaks.<LI>CliXk InserN on the∩main me+u. <LI>φlick Re%ove Pag$ Break.σ</OL>2TITLE>PEinting > Worksh^et</TIT≡E><P><B> <B>U(e these÷E-Z Rab;itSteps to prin a workPheet.</Θ><P> <Oφ> <LI>Ufing you` mouse,
select 5he work`heet yof wish tM print.
<LI>ClVck File╥on the +ain meng. <LI>&lick PrWnt. A PKint diaBog box ops opeM. In thM "Print╘What" akea, cli7k in thS space Qext to ∞Selecte9 Sheet(O)." (Be╛sure yo have pOaced a ⁿblack d_t" in tUe space) <LI>?f you w]sh to pgint to Nhe ActiEe (defa2lt) priter, Cl!ck OK. he work8heet yoS selectNd is pr?nted. <!OL> <P>2TITLE>PEinting *ultipleCopies<╙TITLE><><BR> ±B>Use t>ese E-Z∙RabbitSqeps to rint moOe than ne copy┴of yourworksheSt.</B><:> <OL> ²LI>UsinT your m`use, clGck File
on the Zain men'. <LI>lick Pr[nt. ThePrint dWalog boQ opens.÷ <LI>Yo will sDe a widOet markd "Copi^s" at t<e botto[ left oI the boB. Using⌡your moQse, clik on th up or Gown arrIw next do it. TUis letsyou choese the bumber o[ printe> copies∩you nee!. <LI>≤f you w!sh to p1int to 9he ActiTe (defa^lt) priDter, Cl[ck OK. Lhe numbbr of coUies of %our worsheet yu have hosen t print re prin`ed. </O$> 2TITLE>PEinting %eadings5/TITLE>αP><BR> ▌Sometims you n;ed to pKint out the tites and Iabels fund on he top - and lSft side
of yourßworksheRt -- onall pagCs of yo_r print\ut.<P> ╥<B>Use 2hese E-L Rabbit6teps toPrint RHw and CElumn He dings:<B><P> <7L> <LI> sing yonr mouse click 4ile on Whe mainΩmenu. LI>ClicG on Pag Setup.┬A Page 6etup boR pops o`en. <L6>Click 4ows to Hepeat ah Top. 1LI>In tBe space∩provide!, type n the c ll rang$ which 8pecifieQ the ti]le or l7bel infarmationto be pointed aY the TOⁿ of all┼printou pages.╞ <LI>Clck Colu%ns to RQpeat At°Left. LI>In te spaceprovide,, type n the c
ll rang( which Rpecifie& the tile or lbel inf&rmationßto be p<inted aa the LE9T of al] printo]t pagesδ <LI>Cick OK.┬</OL> ╔2TITLE>WBrkbook -rinting5/TITLE>αP><BR> ▌<B>Use )hese E-0 Rabbit,teps to print a entire²workboo.</B><P▀ <OL> <?I>ClickFile on
the mai/ menu. <LI>CliTk Print A Prin^ dialogbox pop% open. n the "Brint WhDt" area click Bn the sFace nex to "EnSire WorSbook." ▄Be sureyou hav9 placeda "blacN dot" i8 the sp6ce.) <(I>If yo wish t print Wo the A=tive (dUfault) ]rinter,Click OA. All wcrksheeth are prCnted on∩separat" pages.╩</OL> 2TITLE>ZBoming YLur Worklheet</TφTLE><P>∙BR> <B≤Use theIe E-Z R:bbitStems to Zom your Torkshee to diferent pTge sizea.</B><P( <OL> <I>Usingyour mofse, cliAk the a\row thi[g to th right -f the Zaom contUol box ]n the sMandard Joolbar.╚This is the lit\le box t the rbght of Hhe screSn with D numberΩin it (;ollowedⁿby a pecent (%╦ sign). <LI>ClCck on 2 0%-25% ao see yQur workiheet en`arged td a maxiGum of 2 0% or r"duced t a mini%um of 2⌠%. <LITo view■the fulU screen÷again, Ulick Vi]w on thb main mJnu. Clik on "Fll Scre n." </O≥>2TITLE>A7ding TeUt Labell</TITLEΓ<P><BR>▌ Labels╒direct Oour audBence's ^ttentio to a sMecific art of our chaet. Use bhem to Omphasiz& the meNning ofa pie, Aolumn, Krea, etP.<P> <⌠>Use th#se E-Z DabbitStHps to ARd Text %abels tE ChartsΓ</B><P> <OL> <L1>Using -our moule, DOUB E-clickon any Sortion 9f your 8hart. TDis selets it. ┬<LI>To Ddd text·(that ic NOT anaxis oror charj title) click dnce on Nhe "TexC Box" b2tton --╩located╪on the tandardσToolbar■(right Xf the C>artWizadd buttof under qhe mainmenu). ╠<LI>Not
that yur mous pointe become+ a "cro_shair"pGinter. lick AN⌠ HOLD DJWN the 4eft mou%e butto -- andπ"drag" She poin'er to t e place┬in your╫chart w)ere youΩwould lVke to aWd a texe label.Use the▌"crosshir" poiter to raw a bBx that >ill con0ain you= text. 4t will Yontain GemporarV "handl^s" all round i1. These╒are "seBection Aandles. <LI>Rlease tEe mouse╟button.┴The bliaking cu`sor is Snside t)e text Oox, reaUy for yMu to tyZe your aext. <■I>Type 7our labWl text for exa[ple, "PKojected÷Earning.") <L(>When yWu are d#ne, useyour moIse to cZick on Dny port3on of yDur charP -- outide of he textbox. <&I>To ma[e any aQjustmenVs necesiary, cl]ck on t]e "sele=tion ha=dles" a+d move hem inwrd towa1d the t*xt -- sM that tQe box f?ts the fext proherly. Ylur mousJ can al o be us
d to "dag" the╞box -- o locat it exaOtly in JelationΣto the hart ar`a you w1sh to e phasize╙ You ca1 also sDlect yo(r text ow -- ad chang its fo3mattingΩ(e.g. cUoose nej typefaTe, use JoldfaceΘ italic!, etc. o make t look =ust rig/t). <L>Press ?he Esc(Lpe) keyon your≤keyboarA. </OL><BR> <I±G SRC="1ip"><IMⁿ NOTEXT LOW> PsLt! If flr any rason yoR are no happy ith thetext laPel you Rave jus5 createQ, you cRn erase■it -- bc selectVng it wth your▐mouse painter - and prSssing tAe Del(eJe) key n your Jeyboard<P> 2TITLE>C;anging hart Dama Pattens</TIT E><P><B> ExceB makes Bt easy qo direc your aRdience' attent
on to aspecifiQ part oP your c)art, bychanginX the coJors of Lars, piRs, colu ns, lin#s, areae, and bDckgrounR patterGs of yoKr chart╚data seQies. ChInge the╘patternl and co@ors to SmphasizH your d+ta.<P> ⌡<B>Use Phese E-° Rabbit⌡teps toChange *attern _f ChartData SeTies:</B4<P> <OL2 <LI>Us^ng your·mouse, 2lick on▌(e.g.) he left%ost col4mn in y4ur (e.g ) columW chart.÷You wil^ noticethat Ex`el placJs littl things┼inside ach colmn of yur colu%n chart& these 9re call)d selec$ion box`s. <LIDOUBLE-lick on┼any col8mn. <L(>Excel'& "Forma Data Sries" b&x pops 0pen. Th3s givesyou thefollowi_g chartformatt&ng opti ns: <P>┬<B>Bordr OptioAs</B>, >hich ch nge theδOUTSIDE of the [lements≤you havB select^d, such─as the olor, s)yle, an: thickn>ss of a border ine. <P <I>Chose from┴the fol_owing B]rder op^ions:</
> <P> Abtomatic-BR> NonC<BR> Cu]tom (wiah choics of St7le, Colar, WeigKt) <P> *B>Area (ptions<B>, whi h affecS the IN;IDE of (he elem^nts you⌠have seZected, Vuch as -olor or⌡pattern
<P> <I▄Choose rom thefollowiHg Area _ptions:)/I> <P>Automat_c<BR> Ncne<BR> 8olor<BR Patter= <BR> < I>Note hat as 1ou clic* variou8 optionQ on and off, yoK can seW the ef^ect of ^ny chanLes you ake -- n the "·ample" rea at he bott'm right of this°box. <I>Using╨your mopse, cli+k on th arrow hing toπthe rigGt of th "Patten" box ╧- locat d in th& Area O:tions sVde of t[e box. <LI>ExcMl's col,r and pttern "alette"╔becomes≤active.τ <LI>Cl%ck on a9y of thP columni of the≤palette A sampee of wht you s"lect is╒shown tE you in∙the "Sajple" ara at thB bottom╟right o this bbx. <LI,Click O5 when y0u've fobnd the cight paRtern fo\ your c\lumn chrt. <L>Press 7sc(ape)on yourkeyboar=. That'I it. Th variouR column[ of you& columnchart aFe seen eith thenew pat>ern youⁿve chosAn. </OL▄ 2TITLE>C;anging hart Camegory Lbels</TTLE><P>±BR> SoCetimes Rou need to chane the c>tegory abels t at Exce_ puts nSar the Rorizont"l (X) aeis.<P> <B>Use Rhese E-D Rabbit@teps to╥Change hart Cafegory LDbels:</0><P> <O%> <LI>UIing you mouse, click oV any ce l -- tomake suFe that gou "de-Velect" Cour chaGt. <LIUsing yur keybard, enWer CtrlHome toplace tUe blinkKng curser in ce`l A1. 1LI>Sele=t the r0nge of ells whse cate ory lab$ls you <ish to Ahange. <LI>Typ; your nWw categgry labeis. You \ill see╠that Exel imme iately eplaces─the exi+ting ca`egory l9bels wi8h your ew text) </OL> 2TITLE>C;anging hart Vaeues</TI°LE><P>< R> Somtimes yEu need Mo make mrojectins usinD your wrksheet┴data. Ekcel makSs it ea]y to ch"nge cha_t valued so thaR you caX perforZ "what-f" scen rios, a`alyses,etc.<P> <B>Use∙these EZ Rabbi Steps tN ChangeChart Vlues:</;><P> <O > *LI>UsinJ your m9use, DO*BLE-cli?k the lft mous buttonat any Focationin yourchart. ;ou willsee a "Vorder" Vround tBe chart∩to sign&fy that╩the cha*t has b$en "sel*cted." ■<LI>CliLk at th; top ofthe valme ("dat^ marker) in th chart hat you╟wish to╞change.─<BR> <IG SRC="`ip"><IM NOTEXT
LOW> Ps#t! So-c\lled "d)ta markrs" are┼just ch$rt valuDs; in p e chart, the idividua# slicesßof the :ie are ahe datamarkers, in a cWlumn ch rt, the╬columns┬themsel es are Ghe dataτmarkersΦ etc. <> <LI>U^ing youh mouse,≤HOLD TH" LEFT BNTTON DO√N and "!rag" th data m7rker yoN selectbd -- to╔a new pLsition n the c art. ExVel updabes your
workshe&t -- auaomatica]ly. </O*> 2TITLE>C;art AutLFormat<(TITLE><⌠><BR> xcel ma es it a÷snap to∙create cully prfession>l chart. AutoFrmat isan ExceZ Tool tRat enab-es you ao applyany of Rhe pre-Nesignedchart f!rmats t&at shipwith ExFel.<P> All you∙have to÷do is coose thD designyou wan(, and Eqcel autCmaticalZy re-foUmats th/ chart Nou haveⁿcreated╩ giving┬it a moUe polisBed lookif nece`sary.<P <B>Us[ these 9-Z Rabb^tSteps No work Fith Cha/t AutoFrmat:</·><P> <O > <LI>W.th your■chart iW its owD separafe chartwindow, use youW mouse o click┼Format n the min menu╥ <LI>C$ick Aut[Format.°An Auto
ormat b x pops jpen. Yo= are gi(en a seection 2f chart types a!d desigs. <LIαIn the rea cal-ed, "Ga6leries, you caa click `n any oN a numb"r of chrt type, incluing Are4, Bar,
olumn, ie, Dou2hnut, 3D Area,3-D Bar etc. WEen you \hoose a─chart t6pe, Excl displ7ys the ?ormats ^vailabl for th>t type n the aea callXd, "For[ats." &LI>Clic, OK whe[ you hage made Wour choSce. You_ originl chart▐is re-farmatted takingon the <haracteHistics f the nDw chartand for!atting. <LI>Cl=ck Fileon the Pain men?. <LI>lick SaRe, to s ve the hart. <OL> 2TITLE>C;artWizaOd</TITL>><P><BRΓ Would+'t it b great ?f you h:d an aspistant uide yoR throug every tep of ghe charb creatiYn proce4s? Welc\me to CYartWizaPd. Thats exactYy what ≈xcel's hartWizSrd Tooldoes fo` you.<P <B>Us; these φ-Z RabbHtSteps \o creat a Charm with C<artWiza`d:</B><3> <OL> LI>AfteG enteriJg and cecking ll datain your·worksheUt, use four mouUe to sebect therange o[ cells Sou wish∩to char1. (Be s re to i&clude a-y label8 you haTe given the dat7.) You Vo this Zy clickfng AND -OLDING ≡OWN the┼left mo se buttn, then─"draggi&g" the Youse poAnter ov)r the e tire raige of c-lls. <■I>When ou haveπselecteC the ra!ge, clik the C
artWiza)d butto/ -- loc+ted in ahe StanWard Too]bar. <4I>Excel▌places "marque" aroud the d4ta you'=e selec0ed. You= mouse [ointer dow lookF like a²crosshabr. <LIΓClick o+ the sp$t in yoKr worksAeet wheoe you w
nt the upper l ft) corer of ybur charb to be Vocated.ß <LI>Nod "drag"your moSse poin^er downand to &he righ2 -- to epecify Zhere thS rest o? the ch7rt shoud be loBated, aVd how b g it wiel be. LI>ClicY the "NHxt" but>on in C=artWizaNd. "Ste 2 of 5─ pops uS. This Aives yoe Excel'` selectKon of c^art typYs. <LI3Click tBe type >f chart▌you wan . <LI>√lick th$ "Next"σbutton.■"Step 3 of 5" pEps up. Fhis giv]s you Eucel's sJlection╠of avaiable fomats fo the chrt type╪you've Ohosen. °<LI>Cli'k the f rmat yop want. Φ<LI>Clik the "≤ext" bu7ton. "SSep 4 of╙5" pops─up. Excl displys a sa.ple of Cour cha_t onscrXen. HerV you caV choose▌various╬options┬until yur charG repres,nts the▄best ps>ible di^play ofyour daGa. <LIClick tae "Next╞ buttonδ "Step Ω of 5" Fops up.∙You can choose hether Lr not a╟legend ill be \ncludedin your
chart. itto tiales. Doyou wanR to incVude cha_t title%? Simpl#. Just fype theP into tVe space∙provide:. <LI>δlick "FHnish." +lick Sa*e. </OL7 That's⌠it! 2TITLE>E@bedded harts</MITLE><PΓ<BR> A+ Embeddd Chart÷is a ch:rt you `reate a part oC your wrksheet╧ Excel _inks itto your
workshe&t data,so whenVver the■data chKnges, tUe chart╥automat'cally ubdates iWself.<P, <B>Us> these -Z RabbtSteps So creatM an Embdded ChZrt with⌠ChartWihard:</B!<P> <OL <LI>AfIer enteNing and╛checkin all daWa in yoOr worksXeet, usR your mQuse to ielect t\e rangeof cellM you wiBh to ch rt. (Be╩sure to╪include▀any lab*ls you Fave givNn the d7ta.) Yog do thik by cli`king AN) HOLDIN≤ DOWN te left ouse buton, th n "drag ing" thQ mouse Hointer 3ver the╨entire mange ofΦcells. ╥<LI>Whe you ha9e selecSed the %ange, cick the┬ChartWi1ard but5on -- l9cated i[ the StTndard T`olbar. <LI>Exc"l place! a "maruee" arund the≤data yo<'ve sel!cted. Y:ur mousP pointeh now loBks like²a crossaair. <≡I>Click▌on the (pot in Oour worDsheet weere you╔want thB (upper╟left) crner ofyour chOrt to bO locate%. <LI>;ow "draX" your Kouse poSnter dodn and t! the ri%ht -- ta specif\ where bhe rest∙of the 9hart shuld be Kocated,and how╘big it pill be.⌠ <LI>ClWck the Next" b?tton in⌡ChartWiVard. "Sep 2 of┬5" popsup. ThiM gives iou ExceY's seleEtion ofchart tmpes. <AI>Click·the typ4 of cha/t you w nt. <L>Click 3he "Nex9" buttoL. "Step 3 of 5"÷pops up This gaves you Excel'sselectin of avilable ormats or the hart ty(e you'vQ chosen <LI>C0ick the╨format tou want÷ <LI>C ick the┼"Next" %utton. Step 4 "f 5" pos up. Ecel dis'lays a 4ample o0 your cUart onsVreen. HVre you Kan choo0e vario#s optios until╔your ch4rt repr,sents t$e best ;ssible Oisplay ef your 7ata. <)I>Clickthe "Ne t" butt,n. "Ste% 5 of 5° pops uI. You c^n choos whetheO or not╟a legen will bX includSd in yo_r chart∩ Ditto aitles. 5o you w?nt to iXclude cUart tit es? Sim.le. Jusf type tKem intothe spa<e provi:ed. <L±>Click Finish.
Click ave. </HL> 2TITLE>CEeating > Separame Chart─Window<∞TITLE><><BR> *here ar> times then you╔DO NOT Tant to mbed a hart inyour wo`ksheet.
Insteadφ you maf wish t` give a■chart i^s own sRparate )orkshee2 and wi`dow. ThLs way y]u can e=it and Iave thee chartR to theQr own f les witaout resHriction <P> <B!Use the=e E-Z R6bbitSteLs to Crate A Sparate &hart WiHdow:</B.<P> <OL+ <LI>UsKng yourmouse, Wlick Inhert on Nhe main∩menu. ∙LI>Clic Chart.╪ <LI>Cl(ck As N*w Sheet <LI>U\e Excel²s ChartIizard Tgol to coeate thJ chart %ou need╙ <LI>Cick Finsh when─you are╪satisfiQd with Ohat youδve crea$ed. <LD>Click ave. </L>2TITLE>C;art SizB and ShZpe</TIT≡E><P><B> Some)imes yoK may ne>d to eniarge a hart --²or make╟it smaler -- sb that ib looks Letter i/ your w\rksheet <P> <B Use the]e E-Z RNbbitSte"s to ch nge thesize anG shape ]f a chaKt:</B><&> <OL> ΣLI>UsinF your mWuse, do)ble-cli\k anywh9re in tVe chart-- to s/lect it <LI>YKu will ee that┬Excel hDs place> a numbUr of "sRlectionhandles (tiny Vlack sqjares) aLound th4 border▌of the hart. ⌠LI>You "an re-s.ze the Ahart by using yEur mousW to cli[k on -- and "drFg" thes selecton handes. <L∩>Drag oe of th handle_ on the°side ofΣthe cha"t -- tochange <he widt of the┼chart. π<LI>DraF one of╙the corer handes -- t& changeßthe hei1ht and didth ofthe chact. <LI&Drag on" of the╬middle
andles ╤e.g.) dBwnward ⌠- to ma'e your .hart ap[ear talber. <L >Save yLur charm when yu are f&nished.╒</OL> 2TITLE>D4ta SeriBs</TITL>><P><BRΓ In a 4orkshee), inforCation tAat is ik some w
y relatBd -- fo exampl quarteely travSl expen]es for " companf sales Worce --■can be MollecteQ and di%played 'n a wor]sheet aV a DATASERIES.∙It is mEst usualy exprDssed asa singl columnor row =n the w]rksheet-- in l3nes, pi: slices bars, r any oher chaUt elemeHt.<P> 2TITLE>D8lete Ch>rt Elem^nts</TI°LE><P>< R> Somtimes yEu need Mo deletb elemen s of yoRr chart, such s a legXnd or tWtle, etM.<P> <>Use thRse E-Z CabbitStCps to DOlete ElRments o a Char2:</B><P0 <OL> </I>Usingyour moNse, dou8le-clic at any point iV the chrt, to lelect t<e chart <LI>COick theΩchart eAement yKu wish o delet. Excelplaces ⁿhandles aroundthe selGcted el[ment. 0LI>Presh the DeF(ete) k4y on yo2r keybo rd. </O> That'2 it. Th* elemenR is delNted.<P>÷ 2TITLE>D8leting >n Embed]ed Char</TITLE√<P><BR>╒ Sooner÷or lateK you wiil need o deletB an emb dded chrt.<P> <B>Use bhese E-D Rabbitteps toDelete Rn (embeBded) ChKrt:</B>)P> <OL>╥<LI>Usi,g your _ouse, dRuble-clWck at aGy point÷in the hart, tN selectthe cha&t. <LI>Iress th9 Del(etS) key oQ your k/yboard.⌡</OL> <%MG SRC=└tip"><I∩G NOTEX7FLOW> PMst! It Ys almosa TOO eaUy to debete a c\art. UsZ great =are bef>re hitt&ng the εelete k y. If y.u accid*ntally Crase a Lhart th7t you rWally ne]d, use vour mouXe to clck Edit┼on the ain men. Then lick Un o. <P>2TITLE>E7iting CEarts</TBTLE><P>αBR> As▌you wor with c>arts in∙Excel, vou'll ntice th>t there╟will be┴times w[en you \eed to Odit theßchart c\ntents - to adB or chaXge info_mation.εP> <B>se thesW E-Z RaEbitStepa to EdiM Charts</B><P>╚<OL> <L(>Using aour mou'e, clicd at som9 point Wn the cKart youΩneed to⌡edit. LI>Clic ChartW zard (lRcated oH the "CXart" to\lbox). <LI>In jhe spacY providZd, edit·the ran6e so th t it cotains w atever -ew info7mation Wou want to inclKde in yaur charl. <LI>@lick Ne]t. The ╬Step 2 f 2" bo pops oen. <Lφ>Click ,he vari[us optiGns avai0able un$il you aind theΦright c!mbinatin. <LIClick O*. </OL>2TITLE>C;art TitIes</TITEE><P><B÷> Exce) enable( you to÷maximum∙flexibiiity whe it comBs to th appearnce of gext in gour cha\t: moveßtext; c\lor it;change Dont facOs, attrVbutes a d sizes∙ print aut hori]ontallyor vertBcally, ;tc.<P> ╚<B>Use Shese E-B Rabbitteps Wh^n FormaHting a 1hart TiWle:</B>P> <OL>⌡<LI>If Bor examle you
ave a tLtle thaN says, Sales Bf Region" and yeu wanteX to altZr its aJpearanc4 by mak&ng it a╩bit sma$ler -- ll you <ould haTe to do is use Oour mouee and cdick -- lnce -- Tn the ttle. Exel plac s a bor
er with─little ┌selecti[n handl=s" arou2d the ttle. <GI>ClickΦonce on╥the arrw thingπto the Qight of╙the fon size bx (loca+ed on t)e Forma>ting To\lbar beaeath thV StandaZd Toolb r). <L≈>From t
e list f font Fizes, c/oose on! with aδnumber ^maller jhan the≤current²one. Th^ title
ont siz" is updted ons9reen. LI>If tee new fnt size²is satifactory═ press ghe Esc(Ope) key
to "un-4elect" ahe titlV. If noR, repea^ Rabbit@tep 3 u til you▐find thW correcW formatbing optBon. <L >Save yur charS when yWu are f nished.</OL> 2TITLE>C;art GriAlines</MITLE><PΓ<BR> S,metimes╒it's as÷good id>a to mahe your hart moOe undertandabl by add\ng a grWd to it Gridli/es are Wust litele dottCd lines
going vRrticall+, horiz-ntally,(or a cRmbinati]n of th> two).<&> <B>Ue these E-Z RabJitSteps╘to Add/Kemove GFidlinesin yourExcel C2arts:</><P> <O(> <LI>Uing you mouse,click oHce on tXe "Chara ToolbaT." <LI4Click t\e buttoc for "HIrizonta; Gridli+es." <÷I>This !nvokes xcel's τInsert %ridline\" commaDd. At tZe same lime, thfs "un-sJlects" he "Majr Gridlnes" in╞your chrt. All╪dotted Xines goAng acro7s your hart ar` remove,. <LI>o add gidlinesπto your chart, lick one on th "Chart╫Toolbar∩" <LI>lick thR buttonfor "HocizontalGridlin"s." Onc again,┬this in okes Ex6el's "I5sert Gr%dlines"δcommand But th_s time Ghe "MajLr Gridlbnes" opion is 1oggled N -- an: Excel =isplays dotted ridlineP all acoss you chart.</OL> 2TITLE>DEawing aK Object5/TITLE>αP><BR> ▌Excel hs a draMing tooE called the Dra ing TooIbar. Us it to dd shapXs and lWnes to cour wor,books a[d chartd.<P> < >Use thOse E-Z ?abbitStps to D0aw an OTject:</%><P> <O:> <LI>ULing youH mouse,╚click VHew on E`cel's min menu' <LI>C@ick TooZbars. LI>Clic5 Drawin<. <LI> lick OK╠ The Drwing ToRlbar poJs onto iour scrRen. <L+>The DrWwing Toclbar hah a buncB of butCons to %elp you╩draw th follow(ng type8 of shaNes and Uines (aI well ae freehafd): arrlws; recYangles;╠ellipse; arcs;╟filled ectangl s; fill d ellip_es; filDed arcs lines f any kdnd. (Ju;t move +our moue point(r over Dach of 'he buttns for descri'tion ofßwhat ea-h butto[ does.) <LI>Lee's say Nor exam-le that╬you wis
to dra an arrBw: use @our mou/e to cl4ck on tSe arrow#shaped 5utton oK the DrZwing Tolbar. (he poin)er becoCes crosL-hair seaped.) ╔<LI>MovB the crss-hair┴pointer(withoub pressiXg a mou4e butto[) to a ]ocation■just upZer-leftof the "lace in▐your wodksheet Zhere yoc will b>gin draMing. <⌠I>Click AND HOL, DOWN t e left fouse buHton; "d`ag" themouse p9inter sD that tDe arrow╛is exacly the Vhape an> size y_u need. <LI>LeV the mokse buttcn go whZn you aLe done.∩</OL> 2TITLE>DEawing TBchniquel</TITLEΓ<P><BR>▌ <B>Her are soCe gener:l drawikg technques foO use inide Excl:</B><C> <UL> *LI>You -OPY a g3aphic oOject, bj using Wour mou]e to "d_ag" it ▀- AND A THE SA?E TIME Sressingthe CtrE key on÷your ke!board. <LI>YouDELETE graphi\ object by selScting iW, then :ressing⌡the Delete) Ke. <LI>√ou DRAWMORE THN ONE O2JECT wiah the sCme shap[. by DOIBLE-cliXking on·the butCon tool▌you nee -- the& using 8our mou8e, etc.■ <LI>Yo^ DRAW A÷PERFECTSQUARE,CIRCLE, etc. byHOLDING╠DOWN th
keyboad SHIFT╞key -- σND AT T E SAME @IME "dr9gging" =our mou#e, etc. <LI>Yo= MOVE a╥graphic┼object,πby seleBting itε then uing you mouse,╫"draggi/g" it bC one ofits linXs. <LI/You SEL-CT a gr phic obect, by┬clickin once oA it. </ L>2TITLE>DEop ShadLw</TITL>><P><BRΓ <B>Us" these ·-Z Rabb?tSteps Mo add a Drop Sh
dow forJatting ffect:<╨B><P> <BL> <LI>Csing yo_r mouseφ selectthe graahic objCct you aill forZat with╥a Drop hadow eXfect, b\ DOUBLEclickin@ on it.÷ <LI>Th Format Object Jox pops╘open. Egter youF Drop SVadow prHference= inform6tion. LI>Clic OK. </±L> <IMGSRC="tiJ"><IMG >OTEXTFL<W> Psst You cad also aXd a Droe Shadow·-- by uBing the▌Drop Sh dow but,on on t'e Drawi3g Toolb?r. <P>2TITLE>FBrmattinD a Grapaic Objet</TITL><P><BR≤ Excel÷makes iM easy tl change╔the "loLk" of a╟graphic┴object.For exa[ple, yo_ can ad% a DropShadow;change Rhe thicUness ofa line;╥change patter`, or boUder, orcolor.<)> <B>UIe these╚E-Z RabAitStepsto Formt a Graihic Obj9ct:</B>*P> <OL><LI>To =elect aC objectⁿfor for atting,┬you canSINGLE =lick onit, andthen clKck FormWt Objech from t]e menu.· You maH also D UBLE clck the 'bject t. go dir*ctly to■the forVat obje9t dialoY box. 4LI>Invohe the FTrmat Obect Diaog box ╧from whch you nter yo-r forma`ting pr=ference7) <LI>sing yopr mouse⌠ click +our foratting 3referenBes. <Lⁿ>Click ≤K when inishedσ </OL>2TITLE>GEaphic O?jects</MITLE><PΓ<BR> I+ Excel,╒a graph?c objecM is simmly any ╦object"²in your╟workshet -- nog considSred "da^a." Gra1hic objRcts are(e.g.) Alip art text b\xes, ovls, rec2angles,squares arrows arcs, >llipses any sh pe or tGing youve draw", etc.<I> <IMG⌠SRC="ti^"><IMG 1OTEXTFLW> Psst÷ Excel @oes not╛actuall make agraphic·object `art of four chaTt or wohksheet.Instead! a grapBic obje2t is in0erted o a see-,hrough +ayer ov*r your Uorkshee] or chaHt. Thisenablesyou to pize, foWmat, mo"e, copy┼or do aything lse to he objet, with[ut distMrbing t,e chart╨or dataunderne)th. <P>╥2TITLE>GEouping $raphic Hbjects<╙TITLE><><BR> ■f you n;ed to m:ke seveoal grapic obje@ts "act╟as a grup" ExcXl has mOde it eKsy for :ou. Lets say y`u need Kove one
or moreobjects╥togethe0, or yog need tR add coZor to oGe or moHe objec s, etc. Just foTlow the╘RabbitSmeps out@ined beZow.<P> <B>Use >hese E-/ Rabbit/teps to╛group gaphic oEjects tIgether:,/B><P> )OL> <LI Using yeur mousY, clickonce --·WHILE H LDING D WN THE ²HIFT KE on you1 keyboa7d -- on■every oKject yoK wish ta "act ak a groum." <LI#You wil see "hndles" round te objecs indicting thMt Excel°will no; treat $he obje^ts as aΦgroup. ╥<LI>If ou ALWA S want Reveral raphic bjects reated s a gro6p, sele-t the oOjects w\th yourmouse, \hen cli k the b#tton si nifying╔"Group "bjects"τon the rawing oolbar. </OL> 2IMG SRC"tip"><&MG NOTEQTFLOW> ⌠sst! If▌you nee to "un=roup" tAe graphfc objec s, you @an sele
t the ojects w\th yourmouse, ^hen cli$k the bbtton siXnifying■"UngrouZ Object`" on th Drawin% Toolbad. <P> 2TITLE>IAsert Gr>phic Obcect</TI°LE><P>< R> Excl enabl;s you tH insert a varie y of gr>phic obects ino your Vharts a\d workbYoks. Yo6 can evRn insere sound PecordinQs! In fNct, if +ou work▐with MiUrosoft :ord, yoc can inLert a WErdArt gaphic yNu creatMd in tht progrZm.<P> B>Use tVese E-ZRabbitS>eps to nsert aⁿGraphic╛Object:▐/B><P> OL> <LIUsing y_ur mousR, selecV the cebl locatYd at thZ positiIn you w8ll be p)acing te upperσleft co1ner of >our graNhic objNct. <L >Click ;nsert of the mafn menu. <LI>Clck Objet. Exce pops oen the ≤bject d!alog bod to giv= you th) Object╨options) <LI>C4ick the╥"Create┼New" ta%. <LI>(n the a%ea mark d "Objet Type"╫on the -ower le0t of thR tab, ybu are gZven a n]mber of▌options▄ <LI>Uing you mouse,≤click o5 the li/ted app7ication in the Object 'ype" arBa you wbll have─to run Ω- so tht you c7n creat> the gr^phic obect -- Cor insetion ino your Wocument <LI>CVick OK.ßThe appYicationyou selCcted (eg. Micr\soft Wo$d) is r3n. <LI0Create \our gra^hic obj>ct in t>e other╚applicaSion. FoZ exampl, creat^ a Wordrt grapVic objeFt in Mi-rosoft ,ord usiJg that rogram' regulaU procedOres. <<I>Save ahe objeEt you'v[ createX, usingstandar> procedDres. < I>Exit he prog*am, nor,ally. LI>A boV pops oYen -- aDd you ade askedif you tish to Update °ink" be ore finlly exiing the─programµ <LI>CXick Yes The gr%phic yo%'ve cre\ted in <he seco d progrm is in6erted iMto your╙Excel dcument,┬automat cally. ²/OL> 2TITLE>IAsert pi@ture</TBTLE><P>αBR> Pi tures s*ch as s9ans, orBginals, and cli art, c>n easil be insrted ingo your 3xcel doMuments.²P> <B>Bse thesV E-Z Ra@bitStep] to InsRrt a Piture:</ ><P> <O>> <LI>UVing you` mouse,∙select Jhe cell╚located at the Xosition╘you wile be pla7ing theupper-lHft corn/r of yoJr pictuNe. <LI▄Click Isert onthe maiH menu. <LI>CliPk PictuTe. Exceb pops oden the Eicture >ialog b>x. <LI√Click te name 'f the p(cture f.le (oftCn endinP with .8mp or .bcx) youwish to insert - from he "Fil
Name" rea -- o selec it. <I>If neOessary,°click o2 the Drve and ?irector1es area% to swich to t+e locatHon on y"ur hard─drive w
ere the╫picture4 are lo-ated. )LI>You Tre give_ an on-[creen p/eview o the seected pcture, 5y click0ng the ox mark0d "PrevTew Pictkre." (AA "X" in²this boq switch s Previ"w on.) ╒<LI>Cli9k OK. <OL> Thaq's it. ²he pictRre you' e seleced is iaserted Wnto you\ Excel %ocumentwhere y`u can mMve it, ]ize it,etc. to╥fit.<P>▐ 2TITLE>S8lecting²a Graphbc Objec</TITLE√<P><BR>╒ Before÷you can∙do anyteing wit a grapEic obje
t, such┴as formTtting ib, copyiXg it, d&leting Vt, etc.you musR first =ELECT ia.<P> <⌠>Use th's E-Z RSbbitSteS to SelSct a Gr:phic Ob@ect:</Bµ<P> <OL <LI>Yo] SELECT╘a graphbc objecH, by leTt-clickLng onceΩon it - with yKur mous. </OL>┬ <IMG S5C="tip"<IMG NODEXTFLOW+ Psst! /y frienZs and Ithink ii's even·better Co click▌on the ╠Drawing╪Selecti.n" butt4n on thC DrawinP ToolbaH -- befare sele[ting a draphic Tbject -┘ becaus
(a) yo r mouse╞pointer─changes╪to an a^row shaHed thin+ -- and╨you canonly se4ect gra"hic obj
cts (bu7 not ceKls); an (b) it╦s then ossible╫to sele$t a GRO P OF OB7ECTS --by "draXging" yWur mous" -- to lace a ectangl around≤the gra7hic obj!cts youδwish to select.2P> 2TITLE>S8nd To B>ck Butthn</TITLΘ><P><BR√ There╒can be Jimes wh>n you h^ve grapic obje@ts bumpng into┴each ot[er -- o` overlaZping --ßon screRn. Thiscan makC it touQh to wo_k with ll the %raphic abjects RverlappWng one :nother.P> For unately Excel Pas a bu(ton on mhe Draw=ng ToolPar: SenG to Bac5. This 7utton dKes exacly what┬its namH implieM: it se^ds the \verlappKng grap^ic objeWts lyin\ on the·top lay4r back !own -- ╥to the ottom).√P> <IM SRC="tGp"><IMG NOTEXTF"OW> Pssf! You cYn send lverlappNng grapic objets lyin on the╞bottom ╤- back -p to thQ top laQer -- b= clicki g on th` Bring <o Front╥button.ßP> 2TITLE>T8xt BoxeP</TITLE7<P><BR>─ Text b,xes are╒a great÷way to <all attbntion t your EUcel worsheet o chart Wata. Yocr text Man high-ight thR importRnce of Wour datK so you_ viewer% can im+ediatelk undersWand themeaning∙of your÷data.<Pµ <B>UsD these --Z Rabb tSteps mo creat9 a TextBox:</B!<P> <OL <LI>Us>ng yourⁿmouse, lick th Text BRx buttoH on theDrawingToolbar <LI>":rag" yoir mousefrom a =orner o5 this n"w text ox -- t' the co1ner dia,onally Mpposite -- to s?ze it. <LI>Ent]r your qext insNde the ox. <Lε>If you╟need to╞alter t is text╪-- all eou have°to do i7 select╨the texo box (bA clicki g on it╬ -- the1 select the tex' that mst be c
anged -Σ and st"rt typi8g. <LI+If youralteratZons incTude for*atting "ext ins de a Te!t Box O! A WORKHEET, s!lect th0 text wTth yourmouse, 6lick FoOmat on mhe main─menu. ∙LI>Clic "ObjecJ." </OL 9IMG SRCµ"tip"><&MG NOTE TFLOW> ±sst! Ifyour alberation] includ& formataing texe inside■a Text ,ox INSI1E A CHAT, sele!t the tWxt withyour mocse, theG click ormat Slected .bject. $P> 2TITLE>R8trievinD data</MITLE><PΓ<BR> M&crosoft╒Query iI a poweKful dat^ access╔applicaQion you╟can use┴to retr\eve rec]rds froW multip-e data `ources,includiLg Excel
workbooXs, dBas(R), Fo6Pro(R),ORACLE(5), ParaRox(R), trieve((), SQL √erver, Dtc.<P> <B>Use (hese E-S Rabbit'teps toRetrievH Data w3th MicrDsoft QuAry:</B>┌P> <OL>┬<LI>StaUt MicroMoft Queby from dithin EZcel by YlickingData onthe maiH menu. lick "G"t Exteral Dataµ" This 2tarts M Query.■<LI>SelNct the :ata soudce you oill havb Query Zse. Thi tells ÷uery wh re it cn find he data╪you neeP, and t@e kind 3f data $o bringback toΦyou. Clck File╙ Click ew QuerX. <LI>Te "Selet Data ⌡ource" ox popsßopen. < R> <IMGSRC="tic"><IMG ?OTEXTFL7W> Psst▐ If thi! is the┬first tme you 4re usin. Query,▄no dataδsources will beavailab?e. You Eave to !manuall ) make 1hem ava lable fEr query∙and retoieval. σP> <LI>1o make data surce avTilable bo Query click ther. TUe "ODBCData SoSrces" bYx pops \pen. Ths prese,ts you iith a lLst of p]ssible =ata souHces curently iMstalledon your╘PC. DOU;LE-clic? on thesourcesyou wil6 need tD use --ⁿnow and╛in the uture. )or examJle, cliSk on FoePro; MSAccess :atabaseg; dBasefiles (Cf any o5 these re avaiable). ∙nd clic* on NWi3d (a saKple datJbase in÷dBase farmat thYt ships with ExHel for !se as a┼sample earning╞tool). ─<LI>Clik OK. (LI>Next we addΣthe fils/tablen which +ontain &he data┼we are 6eeking. Excel p"ps open─the "Ad Tables┘ box (w)ich hasΩslightlf differXnt featfres accWrding t, whethe your dta is hused in≤a "tabl," or a ▐file." δUsing yZur mous[, DOUBL-click Qhe tabl^s (or fles) co+taining╒the dat7 you ar> seekind. (For xample,²choose he "Prouct" taUle fromthe "No\thwind raders"sample Uata.) < R> <IMG
SRC="ti]"><IMG OTEXTFLW> Psst NOTE tKat the eord "ta;le" is Ksed by ome appKication[ -- suc as MS :ccess - to den]te the Slace th+t data >s store@. Other╛applicaions (iQcluding·Excel) ese the dord "fiNe" to d[note thY same t]ing: th? place Fhere da1a is stred. My╪friends▀and I f*el this■is unneLessarilO confus[ng, andwish thbse peopQe would╠get tog
ther an try to╞work ou some s,andards <P> <$I>ClickΣAdd to #elect tce table; housin the daa you w$nt to rDtrieve.╙You are─given a┬"field #ist" --ßwhich i= a breaXout of Tll the Wields cWntained▌in the "able yo've selcted. LI>Clic2 Close.▄The "Qu0ry WindZw" popsopen. LI>Now Te will [uild a uery, t%en run t. It's÷a good Bdea to bxperimet with Qhe sampe data or a fiVtional Wmport/ebport fi3m that `hips wieh Query
called
"NorthwVnd Tradrs." Th# simpleet querywe coulR make wHuld be Jo pull p inforLation aJout eve&y singl^ item NCrthwindTraderssells, =o that Le couldⁿdetermi e if we┬were ouW of sto=k on spUcific iaems, haF an ovehsupply cf items! or whi=h items∩were se)ling be t, etc.╪ <LI>Th$ Query <indow iQ made uY of dif<erent sWctions [alled "manes." !P> The ╬Table pne" sho s you a╞list of─fields σ- in al\habetic9l orderΣ-- in te tablefrom wh1ch Quer+ will s
ek yourπdata. </> The "≈ata pan " shows┬you the╫data wh&n you s/lect spRcific f\elds fr`m the lQst of f&elds. <■> You mst ADD ields F%OM the -ield li/t TO th0 Data pLne -- se Query 5rings b>ck onlythe dat that a+swers y$ur spec?fic queLtions. 9P> <LI>²o add a²field t the Daa pane:DOUBLE-Qlick a Pield inßthe fieYd list - to poN it intY the Daaa pane.╥ <LI>If▐you neeV to adda bunchof fiel=s at th?s time,╚DOUBLE-Blick thM first #f the fbelds yoI need t] add, T+EN PRES AND HO!D DOWN Phe Shif key on┬your ke\board aHd clickthe lasa field.Using yeur mousY, "drag the blIck you'Ee selec1ed to te Data (ane. < I>If yo: need tM add AL5 the fi;lds fro_ a partacular ffeld lisY -- ALL╠AT ONCE┼-- you
an use our moue to "d*ag" the entire ?roup toΣthe Dat pane. <LI>Fro5 the "N!rthwind┼Tradersσ sample data, ad these─fields o the Dta pane√ PROD_N ME, PRO1UCT_ID,ON_ORDEC, IN_ST7CK, DIS ONTINU,╬AND REO⌠D_LVL. ╔<LI>QueEy retri,ves the▄data yo@ need f]om the HEORD_LV?, ON_OR!ER, IN_LTOCK, ad DISCO TINU filds. YEu now h:ve an oserview f all iQems Norhwind Taders hTs for sOle. </O6> 2TITLE>AHtoFilteO</TITLE7<P><BR>─ What i# you wi(h to diIplay onEy a higely focu ed grouM of recrds -- ith a scecific aet of sOarch cr*teria - and exTlude alJ other \ecords Vn your atabase² For exSmple: lHt's sayyou hav> a data8ase of ll the Gouses fWr sale n your mown -- 6ut you ]nly wanW to dis:lay the⌡houses En one p rticula zip coGe locatCon. ExcUl's Aut\Filter 6ool canhelp yoi do jusi that.<*> <B>UBe these▌E-Z Rab itSteps╪to use utoFilt*r to NaProw You[ DatabaIe List:./B><P> 4OL> <LI;Use youW mouse o selec the whle dataase. (B sure y'ur headUng row - the o2e with olumn l\bels --Φis seleted too╙) <LI>lick DaSa on th main m nu. <Lδ>Click ²ilter. ß<LI>Cli-k AutoFVlter. I`mediate]y, a buVch of a/row thi gs (caled "dro-down" 4rrows) (ppear a0 the to; of you] databaie, (on Ghe coluJn labell). <LIΓClick (#or exam%le) on Jhe arroP thing cor the ╦Zip CodB" field╒ Excel isplaysall thezip codOs in th& column <LI>C]ick to Qelect tRe partiPular zi" code y-u are i`teresteG in. ThWs is caEled youH "filte criterHon" in -xcel-spak. <EI>Excel⌠uses AuboFilterto filt/r your 9atabaseⁿso that╛only th recordV with tBe zip c_de you'ce selecVed are ihown. (5ll otheg zip co>es in y>ur enti/e datab se are idden!)▀</OL>
xcel alJows you to filt;r your ^ist furlher -- _y addinL additinal "fiter crieria" fom othe column+. For edample, Kay you ;ant to urther mefine y7ur quer+ by seeng onlyπSplit-LDvel hou&es for ale in hat par+icular ;ip codeΩarea. CYick thearrow tYing forthe "Sp)it-Leve" field╬ etc. Yu can uFe this 7rocedur! as manD times Ls necesiary. <P 2TITLE>D8leting !atabaseRecordsα/TITLE>∙P><BR> ╒Because÷Excel eGables ylu to wok with Aata on ndividul forms it's asnap to
Delete 3ecords - in thV Data FMrm box.&P> <B>Bse thes E-Z Ra bitStepe to DelHte a Dababase R>cord:</><P> <O⌠> <LI>URing youZ mouse,╘click DZta on t<e main [enu. </I>ClickΩForm. T=e "DataⁿForm" bx pops pen. </I>Choos? the reSord youwish todelete Xy usingyour mojse on tBe scrol; bars d,wn or u -- or ,o click▀on the τFind NeVt" or "/ind PreL" butto`s -- unlil you cind therecord.╠ <LI>Clck Delee. <LIΣClick O∩. The s lected ^ecord iK erased≥ <LI>C ick OK rhen youΦare finshed. <╘OL> 2TITLE>E7iting D>tabase Kecords<╙TITLE><><BR> ≈ecause xcel en:bles yor to wor with d>ta on idividua forms,it's a anap to /dit rec0rds -- Vn the DRta Form■box.<P>
<B>Usethese E▀Z Rabbi2Steps ta Edit aDatabasS Record</B><P>÷<OL> <L±>Using Xour mou[e, clic Data og the ma=n menu. <LI>ClLck Form° The "D6ta Form■ box pos open.┬ <LI>UsLng your·keyboarT, edit ahe datayou wis^ to chabge in eVch of tBe edit 1oxes. ∙LI>Pres Enter 'n your *eyboardσwhen yoS are fiWished. ÷</OL> 2TITLE>A7ding a !atabaseRecord<╙TITLE><><BR> ≈ecause xcel en:bles yor to wor with d>ta on idividua forms,it's a anap to /dit, Ad%, or DeYete rec`rds -- Gn the DKta Formbox.<P>╥ <B>Use▐these E Z RabbiWSteps t] Add a atabase÷Record:Σ/B><P> OL> <LI&Using y#ur mous^, click⌠Data onthe maiQ menu. LI>Clic@ Form. 0he "Dat Form" ox popsopen. <&I>ClickNew. <L6>Using [our keyXoard, ebter thedata whCch will∩compris" this d tabase *ecord i- each o+ the boVes. <BR' <IMG S(C="tip"0<IMG NOLEXTFLOW; Psst! 3ote tha the coumn hea ings (lbels) yu previ'usly en`ered on°your wo6ksheet ppear ii the Da<a Form ox as feld nam(s for yNur dataase. <PΓ <LI>Cl ck OK w en you "re fini=hed. ExPel addsyour neh recordto the "nd of y ur list╨ </OL> σIMG SRC"tip"><MG NOTETFLOW> sst! DO NOT STOHE ANY DTA BELO4 your whrksheet─list. T%is can ause Ex9el to dBsplay eoror mes ages, eQc.<P> 2TITLE>SBrting D>tabase Kecords<╙TITLE><><BR> ·xcel maAes it e:sy to slrt and iew youO worksh et data┴in alphTbeticaland numOrical o3der.<P> <B>Usethese E Z Rabbi^Steps t\ Sort E*cel Dat base ReUords:</%><P> <O:> <LI>ULing youH mouse,╚highligGt the dIta you "eed sormed. (JuGt positWon yourmouse p9inter l:ft of aJd above╛the dat block,then "dLag" thepointerto the Nower ri]ht cornYr of thZ data bFock, to∩select &t.) If #ou wish╪to sort▀the WHOE data Jist -- Sust cli9k on onW cell if the lipt. DO N4T SELEC COLUMN┼HEADING·! <LI>Θlick Daa on th main mQnu. <L!>Click ort. Th "Sort"box pop; open a d presets you :ith sevDral sor'ing optons. <εI>Click╫the "So3t By" d<op downlist toselect ehe datafield y,u wish "o sort.┬ <LI>Clck the scendin. or Des ending :rder bu_tons totell Ex6el in wEich ord^r to sot. <BR√ <IMG SC="tip"<IMG NO-EXTFLOW; Psst! εxcel peOmits yo to sor a maxi`um of tVree (3)
fields Θkeys) aa one ti^e. <P> LI>If yYu need ao sort second▐or thirV field,repeat bhe abov> Rabbit)teps --╚and cliBk the "<hen By"╘drop dopn lists <LI>CZick theAscendi8g or DeHcendingⁿorder bttons t tell E[cel in Qhich orTer to s\rt. <L+>Click EK. </OL2 2TITLE>CEeating >n ExcelDatabas </TITLE√<P><BR>╒ A data8ase in xcel is a colle tion of²interreated reords. T[at's alZ a dataLase is.ßUse ExcRl databRses to Qave, orQanize, Nnd late$ call u. informStion.<P! So whOt's a d:tabase Hecord? ≈kay. TaJe a looS at you& addresl book. -our add`ess booN is a b3g colle8tion ofⁿ"record" (name and adGresses ;nd phonU and fae numberU, etc.)2P> Youve got io set uJ your EGcel dat base so╩that RE√ORDS ar$ placedσin ROWS <P> ThN "fieldI" in yogr addreks book ^re eachindivid!al name╤ addres, fax nmber, p one numer, etc FIELDS°are pla'ed in C LUMNS.<K> <B>U;e these╥E-Z RabitStepsπto CreaSe an Exel Dataase:</Bα<P> <OL⌡ <LI>Ty1e in fi/ld name` -- foreach inUividualcolumn ,f your ≤xcel daabase -╓ in the≤TOP ROWτof your▄databas0. For ecample, _f you aEe going²to creame a datbase th t catal$gs all Jhe inveGtory in your waehouse,²the firt thing┴you've Zot to d] is put
togethe3 a comp_ehensivV list oD each iXdividuaY item i invent-ry. Sayyou're Ln the actomotiv> accessEries buiness, Dach iteU could e car wZx, oil,⌠antifreSze, spaUk plugs÷ mirrorH, hub c=ps, etc╠ <BR> <δMG SRC=tip"><I'G NOTEXDFLOW> P`st! EveP beforeyou entYr fieldnames, Nhe firsC thing 6ou shoud do is╪spec ou3 your d&tabase.■What is each in:ividualRECORD _oing to be compWised ofδ Let's ay you o a busness in─automob!le tire_. Your Lire rec3rds are╨going tj be mad- up of ⌠RAND NA≥ES AND ODELS sTch as a l-weath r, whitwalls, lackwal-s, tube6ess, etP. -- TH8 SIZES `f tiresyou car/y; the ⁿUMBER o pieces╔on hand the St6ck Numb!r; the nit Cos_ of Eac^ piece;≤the Ret>il Pric^ you chrge you/ customrs. (Ea9h of th>se fielas has t be put²into a eparate┴column. <P> Neft, you ]hould f*gure oua what id likely■to be tRe fieldyou chek out t&e most - becauVe this Ws the fBeld you÷should ut in tGe firstcolumn #f your ]atabase⌠for greOtest coQvenienc/. This Bight beⁿ(for ex mple) t
e tire 6tock NuGber. <P. Next, Vt's a gQod ideato map cut yourcolumn Beadings² They'r" going o have ,o fit o- the to5most roU of you[ databaIe table so tryto shrikk them Iown as uch as ossible╒ <P> <≥I>Type n each ield en`ry -- iFto a si2gle cel -- in \ singleΦrow -- &o creat
each r(cord. (6e recom end tha you strt on t e row i.mediate6y belowthe fie_d names. <LI&Be sure▌to ENTE THE NE·T RECORφ in the≤ROW UND RNEATH 0he prev4ous row Take cWre not Go separ>te recokds with─blank r,ws. (It▄s OK thEugh to Eeave inaividual╔fields ?lank.) ╟<LI>Sav your dTtabase Tile by MlickingßFile onthe mai_ menu. !lick Sa`e. </OL+ That's╥it!<P>2TITLE>S4ving a 4orkbook5/TITLE>αP><BR> ▌<B>Use )hese E-0 Rabbit,teps whbn savin your wLrkbook he firs time:<"B><P> <=L> <LI>?sing yo6r mouse click 7ile on Rhe main
menu. <9I>Click╥Save. ·LI>If tZis is tKe firsttime yoN're sav?ng the orkbook the "SIve As" ox popsopen. LI>The Plinkingcursor 3s in th: "File *ame" bo. (This┬is wherH you tyJe in a enique nNme for [our worabook, ud to eig]t chara=ters lo=g. Exce) adds te .XLS xtensio- automa9ically.■For exaVple, Au=ust96.X>S) <LI>;lick OK+ </OL> !BR> <IM≤ SRC="tp"><IMG╟NOTEXTF≥OW> Pss! It's real g[od idea°to try 8o rememer to s\ve yourΦwork on╥a regulr basis∩ say evDry 10 t" 20 mintes. Th s way y&ur workßwon't b/ entireYy lost \f sometYing hapXens to 1he powe in you buildig, or yBur comp<ter har ware fa4ls. <BR) 2TITLE>R8cording²a Macro5/TITLE>αP><BR> ▌Excel e#ables yEu to caIture (rbcord) ad playb>ck a seuence o keystrbkes andcommand], as ifßyou werR typingthem in■by hand You ca[ save tese rec-rdings fo a uniTuely na[ed ("ma<ro") fiBe. This╚is a grDat way \o automte taskl. <P> B>Use tVese E-ZRabbitS>eps to Gecord aⁿmacro:<═B><P> <±L> <LI>'o a pra=tice ru^. BeforR makingyour maYro recofding, tgy out yIur task∩manuall6, and i necessry, wri3e down 9he stepQ you mu\t take Jo accomblish it& <LI>Rsing yoZr mouse╪ click ∙ools on╟the mai menu. ─<LI>Clik RecorP Macro.°The Mac6o dialo box op`ns. <L>Click ecord N
w Macro± <LI>TXpe in a╙UNIQUE ame for┬your maro in t)e MacroΩName boe. (Choofe a namV that bMst desc/ibes th tasks ou are
utomatiAg.) <L>Type i* a UNIQ E descrTption o\ your m4cro in Qhe Desckiption ox. (Th&s is a ood pla9e to fuKther depcribe te tasks²you are╟automat
ng.) <?I>ClickOK. The
Macro R&corder Vs turneU ON. <*I>Carry
out thetasks y!u want 2o recorV, in prRper seqcence. LI>ClicA Stop o the StNp Macrobutton ▄locatedon the !acro To]lbar onVcreen) >o turn Ihe MacrK Recordr OFF. ÷his savHs the m;cro filU to you_ hard dKsk. (Juit placeyour mojse on tBe thing∩that lo,ks like╩the Sto( button▀on a VC or CD Nlayer aWd click÷once.) ./OL> 2TITLE>D8leting /ows andColumnsα/TITLE>∙P><BR> ╒<B>Use Jhese E-3 RabbitPteps to╔delete @olumns r rows:▌/B><P> /OL> <LI,Using yYur mous&, clickon or dcag your■mouse o`er one \r more !f the c-lumn orrow letWers or \umbers Eocated En your orksheeS (to seTect the╘columnsor rows⌠you wisV to delHte). <L>Click dit on Phe main╛menu. <εI>ClickDelete.·The colemns or _ows selGcted inRabbitShep 1 abdve will·be deleCed. </O > 2TITLE>EAtering #ormulas5/TITLE>αP><BR> ▌A formu!a instrKcts Exc>l to do math caculatioKs on an values┴found ia one ormore ceVls. For.ulas ca[ be be ^ade up Mf value], worksUeet refrences,▐cell reXerences built-Wn functBons, op;rators,╚etc.<P> <B>Usethese EßZ RabbimSteps tC enter O formulD in a w9rksheet</B><P>ⁿ<OL> <Lτ>Using our mouVe point?r, clic[ on thecell inwhich yeu want ho entera formuFa (for 4xample)▌cell A1╪ <LI>A1╪becomes▀the ACTVE cell Type aW equals÷(=) sig`. Then lype the formulain the ell. (Nte that╟ALL FOR≤ULAS in─Excel MST begiZ with aF equalsΣsign). ÷or examkle, typ- =59+J4Φ*K90. <±I>PressπEnter. $xcel ca culates─J46*K90▌ the re*ult is 5hen add/d to 59 </OL> /BR> <IM8 SRC="tQp"><IMG▌NOTEXTF·OW> Pss! Excel╔makes iG easy t6 perfor) calcul,tions u^ing celbs conta<ned in Lther wokksheets╥ Just t6pe the quals () sign;∙use youo mouse o click²on the ab of t e works[eet youwish to
use; th&n seleca the ce]l in th?t sheet <P> 2TITLE>UGilizing²Built-ig Functins</TIT E><P><B> ExceB makes Bt easy qo do al kinds Lf calcuations
n your jorksheebs. The Zrogram $ontainsliteral]y hundrCds of rOady-madR formuls calle" "funct[ons" thDt you cOn inserM into c;lls to utomate operatiWns on a╘range o_ values⌠you speQify.<P> Excel'= functiDns are Iade up f three┬things:the fun=tion's >AME; (eg. SQRT ; the EGUAL (=)sign, w]ich telFs Excel∩that a #unction╩is to b consid$red nex9; and tFe ARGUM.NT (e.g (K19,K$6,K58) gr (K19:H58) etc), enclsed in arenthees, whi h tells─Excel t e addre_ses of Lhe cellΣvalues $he funcoion mus< proces%.<P> <τ>Use th(se E-Z 1abbitStps to uilize Ecel's b,ilt-in 'unction=:</B><P+ <OL> <?I>Usingyour mo]se poin1er, clik on th cell i which Lou willτenter t$e funct4on. <L4>Click ?nsert oA the maFn menu. <LI>Clck Func1ion. Exel's FuDction WBzard poms up wi h a lisQ of all╟the buit-in fuactions Wn Excel (For e9ample, @QRT, SU>, SUBTO2AL, ROU8DUP, ROBNDOWN, tc.) De1criptio`s of eaFh functWon are =isplaye: on-scren. <+I>Clickon the unctionyou nee8 in theFunctioQ Name b9x. (If Nou needⁿto use dditionl functLons, clCck on tXe Next Outton, Cnd seleYt the nYxt funciion, an> then n4xt, etcδ) You a e taken╪to a di log boxσcalled FunctioW Wizard÷Step 2 af 2." 4LI>Enteo the ceQl range or vales for our argment in─the spaes provUded. <$I>ClickΣFinish.╨</OL>2TITLE>S8arching²and Repeacing</°ITLE><P√<BR> U(e Excel²s Find :nd Repl^ce to sarch foO and relace an data ybu wish bo, such
as a fo3mula, avalue, R label,■etc.<P>
<B>Usethese E▀Z Rabbi2Steps ta searchfor andreplace∙data:</><P> <O⌠> <LI>URing youZ mouse,╘move th^ pointeF to theupper lHft cellΩof the Gange yoQ wish t search╨ <LI>COick AND·HOLD DOGN the lRft mousG buttonwhile DFAGGING ihe poinNer all Che way 1o the lwer rig t edge .f the r&nge. <*I>Click Edit on÷the mai` menu. <LI>Cli`k ReplaHe. <LIΩIn the rea tited "Fin
What,"─enter t e (e.g. text oJ value,Σor form%la or wcatever Aou need╥to find┼and the1 replacD. <LI>ress th Tab ke. In th area t*tled, " eplace Dith," eater thenew (e.O.) textΘ value,╬formula╬ etc. -╓ that w<ll serv, as the▄replace8ent thrZughout oour wor>sheet. ²<LI>Cli\k Replae All i# you'd !ike to Heplace :ll of tee occurences oC the orginal dta. OthXrwise, gou can \eplace +ust theinstancVs you wGsh. <L3>To finQ the ne*t occur0ence, c^ick FinG Next. <LI>To <onclude÷the seach and Qeplace,click C ose. </HL>2TITLE>D<splayinD Gridliges</TIT≡E><P><B> Exce! makes ?t easy Mo make qhe gridines th>t separte the ells inyour wo`ksheet Qo away ε- for a` long ad you waLt them ^o. TurnVng grid ines of$ gives kou a clHaner, lSss compEicated Liew of !our dat@.<P> <*>Use thse E-Z KabbitSt9ps to tcrn cellgridlin/s on an9 off:</ ><P> <OΩ> <LI>Uing youU mouse,·click T_ols on ahe mainmenu. 2LI>Clic_ Optionh. <LI> lick th4 tab ma/ked "Viw." <L>In the▀space m&rked "WGndow Op]ions" yEu will eee a ch]ckbox tftled "GWidlines┌" <LI>Φlick in╟the "Grdlines"─checkbo0 to turZ worksh=et grid0ines On╨and Off) Gridli6es are %witched┼ON if a1 "X" apOears in╙the chekbox. Gidlines╫are swi5ched OF if thecheckbok is empey. <LI&Click O when y u've mae your electioA. </OL>τ<P> 2TITLE>T<me and !ate Forfats</TI°LE><P>< R> Excl sees :ates an= times ^s value . This Bnables ou to prform aay calcuZations Yn them 5hat youneed. Y`u can aJso chanQe the f\rmat of╥times a,d datesto makethem mo`e approIriate fEr your articul@r needs<P> <B≥Use Thele E-Z R5bbitSte^s to chDnge Tim/ and DaIe FormaPs:</B><ε> <OL> ▐LI>UsinJ your mIuse, RI7HT-clicX in (e.I.) cellH1. (Th]s imagicary celF contai=s the d te 14-A g-99.) ╪<LI>Exc$l's For2at CellQ box poYs open.÷ <LI>Cl[ck Numb]r tab. <LI>In Yhe "Catgory" aea, cli
k Date.╞ <LI>In─the "Fo*mat CodQs" area click 3n one o the Daoe forma<s that +ou wish┼to use.πFor exaLple, cl ck m/d/ y. Exce shows 0ou whatßthat fo<mat wilY look l\ke, in ehe "SamXle" are , butto left o the bo!. <LI>lick OK⌡ The co*tents o1 cell H are nom displaLed in tEe Month& Day-Yer forma1 (8/14/ε9). <L >Using Rour moupe, RIGH²-click Fn (e.g.╨ cell J╥. (Thisimagina`y cell Montainsßthe timR 2:42) <LI>ExcCl's ForWat Cell` box po"s open.▐ <LI>Cl[ck NumbHr tab. <LI>In Mhe "Cat;gory" aea, cliBk Time. <LI>In╘the "Fokmat Cod9s" area click Rn one o0 the TiBe formaPs that ou wish┬to use.For exaGple, clYck h:mmAM/PM. 'xcel shews you khat thai format·will lo>k like,▌in the ╠Sample"╪area, b4ttom le+t of thC box. %LI>ClicA OK. ThW contenls of ceil J1 arJ now di played n the Hur Minues a.m.─or p.m.╪format: (2:42:A%). </OL <P>2TITLE>FHnction 4izard</MITLE><PΓ<BR> E5cel shi%s with >undreds∙of specffic forulas dePigned t assist┴you wit[ everytVing froW financ*al and `tatistiTal probJems, to
helpingyou wit your b nk accognts, inYestmenta and lo:ns.<P> ÷Excel's╚FunctioM Wizardautomats the pkocess o: placinU a funcWion int9 a cell<P> <BUse thee E-Z RbbitSteSs to us? Excel'c Functi\n WizarF:</B><P4 <OL> <@I>Usingyour moOse, cli2k in th" cell yu wish ,o inser3 a func9ion intM. <P> <2MG SRC=°tip"><I?G NOTEXLFLOW> Ppst! NotJ that f!nctions┼can be nserted╞singly,─or, as !ndividuMl parts°of a fo6mula. <≥R> <LI>>lick In;ert on &he main┼menu. LI>ClicJ Functi"n. The Ωunction┬Wizard ┘Dialog #ox" pop= open. <LI>Youare predented wQth a li0t of Exel's bu lt-in f nctions their 5ames, a*d theirδcategorTes. Jusj use yoHr mouse²to clicd on (an highli$ht) a f*nction Dame to ;ring up a descrption oC the fuction. ┴<LI>CliVk in thS FunctiYn Name -ist forthe funTtion yoS will bO insertVng into╥a cell.▐ <LI>Cl[ck Next You wiZl be taDen to t>e Step ┌ of 2 bNx. <LI>Typ in thecell raBges andvalues What tog/ther ma@e up thA argume t of th functiRn. <P> IMG SRC-"tip"><6MG NOTE:TFLOW> Fsst! Us]ng the [x buttoHs in th4 Functi,n Wizar Step 2╪of 2 bo7, Excelσenables■you to Ylace fuDctions [nside o^ functilns -- uU to sevn level deep! πBR> <LIΣClick Fnish. T e functUon is aMtomatic%lly insrted inoo the c-ll you %elected┼in Rabb,tStep 1 </OL> ∩P> 2TITLE>CBpying FLrmulas<(TITLE><⌠><BR> hy type╒the sam; formul: over akd over?╔Excel m>kes it asy to opy a fbrmula aUain and
again.<> <B>U`e theseE-Z Rab@itSteps
to Copya Formu a:</B><> <OL> .LI>UsinJ your m]use, clBck on a÷cell (e╓g. E1) Shat con\ains th formulZ you woIld liketo copy <LI>C6ick EdiI on theⁿmain me u. <LIαClick CRpy. Exc?l will curroundthe celN with a"dashedmarquee#" Then xcel wi;l prese+t you wth a sttus bar▀message "SelecR DestinJtion an: press 7nter." Gr, "Cholse PastJ." Thes are yor cues o assis you in─finishi&g the c[py task <LI>U7ing you" mouse,select <he cell╥where yu want 7o place the cop,. For e ample, lick ce#l F10. ²P> <IMGΩSRC="ti]"><IMG AOTEXTFL@W> Psst Cautio+! Take are whe you seect the≤cell wh,re you 3ant to ;lace thP copy. ;xcel's opy comJand wile OVERWRφTE any !ata in )hat celB when yHu invokb the Pa te comm>nd. <BRσ <IMG S≤C="tip"1<IMG NOBEXTFLOW( Psst! o copy ahe cells) to aLother wYrksheet click &he work1heet taT at thebottom ]f the s<reen (eg. Shee 2). <BR <LI>ClQck Past. The c^ll formIla is c]pied frRm E1 toΩF10. <L >Tap thA Esc(ap) key o your kHyboard.·This geds rid oS the "dCshed mahquee" afound ceal E1. < OL> <P>∩2TITLE>H8aders aKd Footeks</TITLΘ><P><BR√ Excel╒makes iJ a snap∙to prinq file dscriptiLns, pag number, time,date, w]rksheet
tab nam&, or whNtever oeher infMrmation
you migUt need !n your 5orksheef printoXts. "HeOders" pKint out÷at the op of yNur page "Foote&s" prinm out at⌠the botbom.<P> <B>Use >hese E-/ Rabbit/teps to╛add Heaers andFooters·to yourworksheRt:</B><2> <OL> 2LI>Usin[ your mduse, clCck File∩on the *ain men . <LI>√lick Pa&e Setup≤ The PaEe Setup dialog 8ox popsopen. 4LI>Clich the taG called╠"Header╘Footer.╔ You ar given list o option_ to choGse from■ <P> <BεHeader:7BR> Foo<er:<BR>╥Custom φeader..±<BR> CuRtom Foo'er...<B÷> </B><ΣR> <LI>ⁿxcel au5omatica6ly inse_ts the aame of ehe currMnt work0heet as╬the heaer, and╔the curEent pag, number▄as the 1ooter. @sing yokr mouse click Ln the akrow thig to th" right $f the H;ader teQt box. Qhis wil give yLu a choce of pe-definXd heade`s that /xcel ca/ supplyto you.LikewisC, clickSng on tUe arrow╥thing t- the riYht of tKe Foote` text bHx gives÷you a coice of pre-defQned foo(ers Exc^l can sIpply toyou. </I>You c+n also 8reate aⁿcustom eader o footer by cli=king onCustom 5eader oT CustomFooter.For exabple, yoO can te;l Excel▌what te"t to di+play in▀a custo2 header■or footNr -- an: where fo displYy it: Lbft, CenYer, or ■ight. Yu may aso formt this ustom t xt any cay you ;hoose, -ncludin the us` of dif.erent f!nts. Yo may in6ert the time, te page umber (f total╫pages),ßyour na7e or coZpany na`e, etc. <LI>WhMn you h ve competed yor heade or fooGer, cli*k OK. <δOL> <BR <IMG S=C="tip"4<IMG NO'EXTFLOW Psst! Ireview ow your▌headers╒and fooJers are∙going tl print ut, by @hoosing╟Print Peview. /P> 2TITLE>IAserting²Page Br^aks</TI°LE><P>< R> Usully, Ex9el figuKes out %automatcally) There pae break shouldoccur, baking iXto acco6nt the `ize of ehe papeP you arO using,and othr setti,gs in PSge SetuS, etc. 0ut to m:ke sure÷that ne pages Nf your _orkshee(s printout wheFe a newpage beJins, yo? sometiBes haveⁿto take╛control┬of pagebreaks.P> ExcUl allow` you toinsert W (manua`) page Wreak in·your woAksheet #or this╩purposeµ Then, 6hen youσare priLting ou] a workIheet --and Exc]l sees ^ manualpage brak -- te page
urrentl printig is ej cted fr[m the pJinter, %nd a ne' page in starte,.<P> <⌠>Use th
se E-Z abbitStDps to i!sert Pa e Break:</B><P⌡ <OL> <I>UsingΩyour mobse, cliVk on thV cell lWcation 6ou wish╬to inset a man al page≤break. τ<LI>Cli k Inser? on the main medu. <LIClick P>ge Bread. (Note─that th" manual╒page br;ak can ;e identffied by╔dashed Iines noiceably┴thicker looking-- and Vonger -ε than tUe dasheU lines Dor autoWatic paTe break%.) </OLⁿ <IMG ERC="tip><IMG N=TEXTFLO0> Psst!÷Sometims it's -OT nece[sary to╘insert Z page bFeak. Yoc might Rnly nee. to priCt your Sorkshee SIDEWA√S -- usLng what·is callUd "Land`cape" pCge oriedtation !- in thZ Page S?tup box² Check ,ut the opic ca$led "Se3 Up Pag*s." You■can alsX try ch7nging tZe margifs: bottlm, top,right ad left efore pinting ut your─workshe t. We'vQ covere< this f3r you i the "S`t Up Pa/es" topc as wel. <P> π 2TITLE>PEinting -arts ofa Works eet</TILE><P><≈R> <B>+se thes> E-Z Ra_bitStep to priKt parts╟of your┴worksheXt.</B><>> <OL> &LI>Usin( your m\use, clZck File■on the Wain menb. <LI>⌡lick Pr'nt. ThePrint dLalog bof opens.∙ <LI>YoK are ased: "PrHnt What" Then -ou are `iven a @ist of ]ptions Wo choos/ from: P> <DL>ⁿ<DT>Selction <µD>PrintcurrentFy selecded cell` <DT>SeNected S^eet(s) 0DD>Prini select?d works7eets <D>Entire╩Workboo# <DD>Pr(nt enti7e workbMok <DT>,opies <D>Printas manycopies ^s you nJed <DT>ⁿage Ran e <DD>Al; or Pge(s) Fom -- T'. </DL> <LI>To Hrint a 7elected╨a rangeof cell;, just 'se the ouse toπselect She rang you wih to pr nt. Do +his by 1lacing >he mousR pointee just t` the leNt of th" range;╬Then, H±LDING D°WN the ?eft mou:e butto*, drag ?he mousP acrossthe ran:e, and Oelease mhe buttn when 6ou are inished Click √Selectiln" in te "PrinQ What" rea of he Pring dialogbox. </9L>2TITLE>S8tting UM Pages<(TITLE><⌠><BR> n Excelß it is 7 good i=ea to sbt up th page pOinting pecifictions bXfore yoc start ^he prin5 job. TUis way jou can @e sure cou willbe gettng the -utput yau need Zith theleast aFount of÷time an troublD.<P> E`cel maks it ealy to ch5nge thepage orLentatio8 from PDrtrait Po Landsape (sieways),margins paper cize, etP.<P> <$>Use th[se E-Z FabbitStZps to S?t up Pa6es for rintingΣ</B><P>╪<OL> <L>Using >our mouQe, clicT File oD the ma[n menu. <LI>Clfck PageSetup. he Page┼Setup dalog bo pops oen. <L>Click `he "tab· calledΣ"Page."╨You aregiven aΦlist of╥options┼to choo6e from: <P> <B>rientaton (porrait or╫landsca1e)<BR> caling: Adjustto % Nocmal SizM<BR> Fi1 to: Scle workheet si#e up or≤down<BR Paper ize: 8 ⁿ/2 x 11 inches,etc.<BR Print .uality:High, daft, et .<BR> F rst pag; Number Choose which p
ge prinQs first╒<BR> </π> <LI>C_icking bhe "tab calledß"Margin`," gived you a Jist of Yptions ao choos from: ·P> Top,Bottom,Left, RWght: En:bles maHgin adj stment<!R> FromEdge: Tll Excee how He5ders anR FooterV shouldΩbe prinIed, rel=tive to╛the edg of thepage.<B,> Centeb on PagR: Tell 'xcel tocenter drintouthorizonNally, b4tween l"ft and ight ma*gins, a-d verti(ally beRween toY and boJtom marYins.<BR6 <P> <II>ClickNng the ╬tab" caled "Heder/Fooer," gies you list oR optionK to cho3se fromΩ <P> H`ader/Fo7ter: Ad Header┼or Foot(r<BR> CTstom Heder/Cusom Footr: Make╫your ow/ customΩHeader Nnd FootXrs to i_sert woZksheet 1ab name!, workbok file╔names, 7ate, ti4e.<BR> rint Ar0a: Prin_ out juit a parG of a wLrksheetby seleting a /ange of╒cells.<R> PrinM Titles7 Have E!cel priKt out a╟column r row ybu wouldlike reZeated o/ every ]age as R title.BR> PriXt: HaveExcel p$int you0 workboak the wDy you wOnt it: ∙with or÷without╚gridlinDs; coloZ to blak and waite, et7.<BR> POge OrdeU: HaveΩExcel pGint outⁿthe infrmation┬in yourworkbooE sectio^s eithe_ from lGft to r_ght, orfrom toe to botNom.<BR>∩<P> <LI√Click O⌡ when y'ur page2 have b*en set Sp for p[inting.÷</OL>2TITLE>PEint PreSiew</TIMLE><P><µR> <B>se thes E-Z Ra8bitStepL to Presiew you workshBet befoe you pint it.//B><P> *OL> <LI(Using t)e mouse click `n File Mn the mKin menu <LI>Clck Prin2 Previei. A PriQt PreviSw screeG opens.÷The toobar conSains se^eral bu(tons. Ceicking Kith themouse oQ each o8e enabl:s you tK: <P> <ΓL> <DT>σlose PrLnt PrevCew screUn <DD>RRturn toyour wohksheet 0DT>Marg^ns <DD>djust p0ge marg&ns and olumn w!dths <D>Next P&ge <DD>4iew the next pa=e <DT>Pdint <DD6Print ylur workXheet usng the urrentl Active╞printer╥ <DT>Zo'm <DD>mMgnify wGrksheetΣonscree </DL> 7/OL> <P 2TITLE>C;anging xis Scaee</TITLΘ><P><BR√ By deault, ENcel scaEes the sertical╔("value ) axis or the harts ybu creatS automa^ically.ßIt doesthis usZng some■kind of
"best fVt" sche e. Unfo0tunatelk, this Goesn't Olways lHok very÷good.<Pµ You wHll some\imes ned to chZnge hor=zontal ]r vertiFal axisΩvalues ⌡-- say Bor examle, to tretch Rut your·numbersand givR them mQre spac[ on theaxis.<P3 <B>Us? these -Z Rabb&tSteps o Chang the Ax(s Scale </B><P>■<OL> <L2>Using Oour mouee, sele[t the "salue" ([ertical╒ axis b clickig once ╙- anywh re on i,. You wUll know°the axi7 is selcted bythe app-arance !f tiny lack sq8are thiMgs on t"p and bttom of┬the axi*. (For 5he purp9ses of ahis exa`ple, lee's say \hat the▌highest╬value o this a!is is 500 -- a5d the l+west va7ue is 1.) <BI>Now D"UBLE-clFck on tais "vale" (ver1ical) a-is. The÷"Format∙Axis" blx pops pen. <)I>Click╟on the ab markXd,"ScalS."
<LI>Us*ng yourmouse, 5OUBLE-cJick the
box marXed "Maxmum." I, the spSce provLded, ty^e the hBghest v7lue on his axiR: 5000. <LI>Us ng yourmouse, OUBLE-cZick in Whe box 7arked ""ajor UnEt." In he spac providHd, type·the lowUst valuR on thiU axis: '000. <@I>ClickOK. Exc?l chang4s the a5is scal -- so ,hat 100∩ is theσintervaJ betweeW values÷-- and fhe high]st valub is 500. </OL>2TITLE>H4ndling 4orkbookFiles</°ITLE><P√ <IMG SC="loreDzo"><IM NOTEXTCLOW><BRτ Excel²has a s t of relly greTt featu`es centOring ar0und theconceptd of worIbooks.
Here's Uow to u%e 'em:<> <UL><LI><A +REF="AbOndoning∙changes÷to a wokbook"> bandoniVg changs to a porkbook/A> <LI,<A HREF "Closin1 a work7ook">ClKsing a orkbook▐/A> <LI!<A HREF"CopyinW a work`heet fiNe">Copy_ng a wofksheet [ile</A>·<LI><A REF="Cr"ating a╩new wor#book">C1eating & new woPkbook</*> <LI>< HREF="7rasing Y workshbet file>Erasin a workheet fie</A> <≥I><A HRΘF="Find!ng a wo^kbook"> inding % workbo k</A> <GI><A HRF="Movi g a worsheet f,le">MovHng a wo%ksheet
ile</A>┬<LI><A REF="Op&ning anΩexistinT workbobk">OpenZng an e`isting 4orkbookΩ/A> <LIα<A HREFµ"Openin: severa3 workbo+ks">Ope9ing sevPral worabooks aG the saJe time<(A> <LI>αA HREF=▀Renamin worksh;ets in : workbolk">Renaing worHsheets n a wor book</A1 <LI><AHREF="SKving a 8orkbook>Savinga workbMok</A> &LI><A H?EF="Selcting w-rksheete">SelecWing worYsheets<A> </UL 2TITLE>C;art TypBs</TITL>><P><BRΓ Excel▌provide( you wiJh diffeKent chaot types╔so that²you can╟present┴your daga in thS most aZpropria5e fashi\n. A feh of the■basic tcpes are'<P> <B≡Area Ch rts</B> A gooG choiceto demoGstrate Jhe percntage oE changein diffrent chZrt valu9s.<P> *B>Bar CKarts</B. Thes: are gr=phs in he form┬of vertLcal strCps (in `atternsor coloTs) stacaed nextto eachother. ar grap7s repre0ent dat derive from o-e or mo7e rangeQ of datJ you haLe selecfed fromyour wooksheet.!P> <B>ⁿie Graps</B>. √hese ar circulr graph+, dividQd into Hie-shap)d slice#. Each nlice sh7ws prop!rtional┼percent$ges of She tota pie.<PΓ <B>3-µ graphs≤/B>. Th&se dep3ct dataseries bn a thrVe-dimen[ional g/id -- i. an x,,z axis╔-- with≤one dat( series▄in fron? of ano_her. 3-: graphs≤are morB usefulthan 2-Φ for il)ustrati#g the tHends wiMhin a sbries, ad relatFve valu s acros a seriXs.<P> *B>ColumX Charts²/B>. ThRse are dimilar Ro Bar cRarts. TUey are good c&oice ifyou neeG to calZ attentBon to d?fferencs betweDn data.$P> <B> ine Chakts</B>.⌠These a`e a gooG choiceΩto demoCstrate ?hanges f cell alues oYer a peLiod of dime -- Nnd thusmake iteasy toillustrVte a tr?nd.<P> ∩2TITLE>C;ange ViBw of a ,D Chartα/TITLE>∙P><BR> ╒You can÷often iFprove tee appeaance of²a 3-D E cel chat by rogating ib, or tiVting itφ to empUasize tYe perspCctive oP differRnt char& elemen2s.<P> .B>Use tKese E-ZRabbitSMeps to hange te View Nf a 3D +hart:</÷><P> <OE> <LI>A:ter you` 3-D chDrt is o8 screen⌡in its Kwn windw, use our mouVe to RI!HT-clic[ anywhe_e in thG chart. <LI>Cl]ck 3-D Kiew. A <ox call4d "3-D iew" pos open.╪You are▀given aσselectiMn of op]ions to÷change fhe view$ includfng: <BR# <B>Ele"ation<B≈> Rotaton<BR> ÷erspectve<BR> caling (/B> <LIExcel e2ables y u to se` -- viaΦa "wire╥frame" icture ,n this Aox -- a╙mock diplay of┬how the╫changesßyou sel/ct willaffect ghe viewof yourchart. ▌<LI>Whe you th nk you' e found≤just th, right ombinat4on of cSanges te your 3 D view,²you canactuall apply 1hese chnges to÷your ch:rt by ciicking n the bRtton maked, "Aply." /LI>ClicY OK wheX you ar& finishRd. </OL/ 2TITLE>FBrmattinD Chart :xes</TI°LE><P>< R> It'( easy tE enhanc> the apmearance╔of the 6 and X
hart axs. PerhTps you eish to _se a di'ferent Sont; chRnge the■scaling% use a Qifferen& number▐format;change Folors, ]r the w>ight of÷the axi line; @dd dollIr and prcent sbgns; et7.<P> <0>Use thHse E-Z abbitSt:p to FoNmat Chat Axes:▐/B><P> OL> <LIUsing y_ur mousR, clickthe axii you wigh to fogmat. FoL exampl4, click▌on the alue (v rtical)▀(Y) axi8. Excel■places Uittle sGuare th[ngs at gpposite ends ofthe axi , calle "selecion box s." <Lφ>Now RI HT-clicW the axAs again≥ The "F rmat Axds" box 8ops ope . You ae givenπa selecSion of ormattig optios, incl,ding: <R> <B>A6ignment)BR> Fong<BR> Paeterns<B:> Numbe/<BR> Scle</B> ┬<LI>Cli k on th8 tab re7resenti*g the f:rmattinR option s) you Jish to @hange. <lick yor choic"s in th spaces÷provide=. <LI>@lick OK╔when yoR have cmpleted┴your tafks. </O:> 2TITLE>DEawing a²Picture5/TITLE>αP><BR> ▌Excel hs a draMing tooE called the Dra ing TooIbar. Us it to raw picgures yoc can adN to you3 workbo\ks and Tharts.<.> <B>U]e theseE-Z RabitSteps▐to Drawa PictuUe:</B><>> <OL> LI>Usin= your muse, clHck Viewon Exce 's mainmenu. LI>ClicY ToolbaUs. <LIClick DGawing. ⁿ<LI>Clik OK. T
e DrawiQg Toolb;r pops _nto you_ screen <LI>T^e Drawibg ToolbVr has a·bunch o5 button0 to hel you drw just bout an>thing yMu need ]o, eith;r freehSnd, fre]form, oo togethJr with he follwing tyes of sapes an lines:╪arrows; rectangDes; ell-pses; a"cs; filged rect)ngles; illed elipses;πfilled @rcs; et. (Move─your mose poin+er overßeach ofΩthe butaons fora descrZption oN what e ch does▄) <LI>εet's sa" for ex4mple th(t you w%sh to d=aw some_hing fr[ehand. (se your²mouse th click n the "reehand╫ button÷on the rawing Qoolbar.╔ <LI>MoSe the pinter (ithout cressinga mouse
button)ßto a loPation jfst uppeP-left oP the plNce in y!ur work1heet whWre you Zill begWn drawiGg. <LIClick A÷D HOLD #OWN theleft mo)se butthn; "dra;" the m]use poiQter so >hat whaI you "dNaw" is he shap and si]e you n?ed. <L9>Let thR mouse Dutton ge when ycu are ddne. </O&> 2TITLE>BEing To #ront Bumton</TI°LE><P>< R> The'e can b; times Phen you have gr
phic obGects buping ino each bther --or overVapping ε- on sc_een. ThZs can m?ke it tYugh to dork wit the ob(ects be`eath thH objecta on top<P> FoHtunatel!, Excel has a b]tton on╘the Draping Too@bar: BrWng To FRnt. Thi= button⌡does ex=ctly wh t its nme implLes: it <rings oferlappi[g graphKc objecjs lyingbeneaththe top·layer b0ck up t,p (to te frontß.<P> <MG SRC=τtip"><I+G NOTEX=FLOW> PIst! Youcan sen\ overlamping grFphic obects lyng on tp back
own ben ath the╪top layQr by clAcking o2 the Se d to Ba^k butto6.<P> 2TITLE>DEawing a²Polygon5/TITLE>αP><BR> ▌Excel hs a draMing tooE called the Dra ing TooIbar. Us it to raw pollgons yoc can adN to you3 workbo\ks. Poljgons arC closed
planed Sigures &hat are▐boundedby lineV that a`e strai@ht, or 8y arcs f circlDs.<P> $B>Use t ese E-ZRabbitSHeps to 2raw a PRlygon:<∙B><P> <$L> <LI>1sing yor mouse╬ click 9iew on xcel's ]ain menb. <LI>%lick Toelbars. <LI>CliXk DrawiHg. <LIClick O. The D awing T'olbar p.ps ontoσyour scPeen. <5I>The DHawing Taolbar hYs a bun`h of buYtons to╠help yo draw j st abou anythig you n ed to. Move yoMr mouseΣpointer╨over ea^h of th- button% for a escript,on of wGat each╙does.) ─<LI>Let╔s say f&r examp-e you w3sh to d_aw a po_ygon. Ude your Uouse to▌click o the "Feeform"╔button Bn the D9awing T+olbar. δ<LI>Drab a stra_ght lin8 by movFng the iointer ╠without▌pressin a mous; button. <LI>Then you╔need to²create vertex┴left-cl\ck onceat the Vocation∩ <LI>T\ draw fceehand - click
AND HOL1 DOWN te left +ouse bufton; "dUag" themouse pHinter iDto whatver freDhand de[igns yo) need. <LI>Rel9ase themouse bXtton wh/n you aGe done.ⁿ</OL> 2TITLE>UAgroupinD Graphi\ Object</TITLE√<P><BR>╒ If you÷have ma=e sever^l graphc objecQs "act s a grop" Exce_ has maRe it ea]y for y0u to "u[group" ehem.<P>■ <B>Use
these EZ Rabbi&Steps t- Ungroub a GrapKic ObjeQt:</B><)> <OL> LI>If yu need So "ungrWup" gra$hic obj^cts, se@ect theobjectswith yo?r mouse <LI>CHick the╛button ignifyiQg "UngrIup ObjeSts" -- Yocated Qn the Dhawing Tcolbar. 1/OL> Th;t's it! P> 2TITLE>H<ding a $raphic Hbject</°ITLE><P√<BR> W ile worAing witA Excel, you can╔speed uM scrollng by h
ding al_ graphiQ object] in you3 workshRets.<P> <B>Use■these EZ RabbiaSteps t! Hide a▐GraphicObject: /B><P> *OL> <LIUsing yEur mous, click Tools oV the ma n menu. <LI>Cl=ck Opti]ns. ExcHl pops 9pen the⌡Optionsⁿbox to ive you┬the VieZ optionM. <LI>3lick thR "View"tab. <BI>In thY area mVrked "O<jects" >n the l,wer lef of the╪tab, yo4 are gi;en the DollowinP optionI: <BR> .B>Show 9ll<BR> Phow PlaHeholder <BR> Hi e All</Θ> <LI>Θlick th check ox you \refer. °<LI>Cli'k OK to╨confirmyour se4ection.╥</OL> <εMG SRC=σtip"><I,G NOTEXFLOW> Pst! You┬can als& chooseßto viewΩonly thR "place[olders"for youZ object0, insted of th graphi objectF themse3ves.<P>▄ 2TITLE>UFing MacOos</TITEE><P> <φMG SRC=▀rexmax"≤<IMG NO*EXTFLOW<BR> Eucel ena les you²to capt re (recrd) andplaybacY a sequOnce of ,eystrokRs and c`mmands,■as if yYu were ayping tem in b7 hand. Kou can Vave theae recor=ings to÷a uniquly nameC ("macrW") fileΓ This il a greaH way toautomatH tasks.Ω<P> <U!> <LI>< HREF="≡ecordin a macrR">Recor>ing a mQcro</A><LI><A *REF="PlWying baWk a macgo">PlayCng back∩a macro∙/A> <LIΦ<A HREF⌡"Erasin& a macr4">ErasiLg a mac[o</A> <"I><A HR7F="Assi_ning ma`ros to Yhe tool menu">µssignin macros╞to the °ools me&u</A> <8I><A HR F="Halt-ng macr playba^k">HaltΦmacro p ayback<╘A> </UL 2TITLE>F<nding D>tabase Kecords<╙TITLE><><BR> ≈ecause xcel en:bles yor to wor with d>ta on idividua forms,it's a anap to Pind ind*vidual _ecords - in thC Data FYrm box.)P> You╥can BROSE throggh indiYidual rScords bR clickiDg the "εind NexS" and ".ind Pre*(ious)"buttons<P> Yoc can usH the Da>a Form 7ox SCRO(L BAR t flip t
rough rHcords.<*> You San use ahe DataForm bon buttonmarked Criteri;" to sp4cify th" SPECIF≤C INFORATION (.r speci+ic rangC of datJ) you n;ed to f[nd -- tg the ex`lusion Tf every hing ele.<P> <÷L> <LI>√sing yor mouseΣ click 0ata on Lhe mainΣmenu. <ⁿI>ClickForm. T0e "Data╥Form" bx pops 2pen. <L(>Click ÷riteria╥ Excel resents╫you wit) a new 0orm -- ahat enaUles youto typein "sea/ch condtions" ou want╔matched <BR> IMG SRC∙"tip"><MG NOTECTFLOW> Fsst! LeG me demLnstrate3 if you─had a L st Name╒field, Oou coul= type B' as a sarch coKdition ╘- and Ecel wou_d find Oll the \ecords 8here La`t Name Segan wiRh "B". &P> <LI>Ahe colu n headi,gs (labWls) youprevioualy enteKed on yEur workheet apOear in \he Data╘Form boq as fie@d namesfor youU databa=e. Usin< your kAyboard,╛enter t
e searcK criterCa you nUed -- i[ the fiGlds of _nterestyou neeY to fin>. (Leav4 any ot%er fiels blankµ) <LI>lick Fo7m when Wou are Oinished Excel eearchesfor all recordsmatchin your secified╟criteri. <LI>τlick "F!nd Next (or "FAnd Prevµ) to di#play th` next r-cord. A d so on╙ <LI>C/ick CloRe when ,ou are
inished╨ </OL> ≤IMG SRC■"tip"><MG NOTEETFLOW> Csst! Toget OUTof sear h mode,╬click t
e "Critria" buGton. Th,n click▄Clear.<> 2TITLE>C;art LegBnd</TITEE><P><B÷> In E5cel, a ╫legend"÷shows yHur audibnce whi h color²points o which┴data seeies (i.S. columX of dat"). Thisis esse_tial --■especiaVly if y\ur char& contai,s many VifferenW data sSries --∙if your÷audienc is to TnderstaVd the maning o_ your c<art.<P> <B>Usethese E≈Z RabbiISteps tK work wth Char LegendV:</B><P <OL> <<I>To adQ a charV legendto a chUrt thatdoes noN contai= one, t6pe titls into 1our wor*sheet -≥ above Cach col^mn. <L >Using kour mouke, clich anywheWe in yo!r chart╤ to sel ct it. ╞<LI>Clik Legen -- in `he "ChaJt Toolb3x." <P>╨<IMG SR>="tip">IMG NOT≈XTFLOW>┼Psst! T+e Chart Toolbox╙pops on─screen fter yo, have d&signed + chart bsing ExVel's ChRrtWizarL Tool. n it yo# will se a seres of "5uttons"τyou can▄press t: alter dour chaht in vaEious waVs, inclnding chnging c%art typs altog;ther. <R> <LI>Ff you ae not h>ppy wit the loation oY the leUend in cour cha3t, you Pan moveit. UsiLg your Wouse, cYick any)here in▐the legWnd. ExcHl placea a "sel>ction bErder" aound it <LI>PTace you& mouse iointer =nside tVe bordeU. ClickΩAND HOL DOWN tDe left ouse buton -- Dnd "draA" the lUgend toany locCtion inyour chUrt thatyou thiHk looks∩better.▌</OL> 2TITLE>CBmparing²Data Wimh Pivot─Table</ITLE><P≤<BR> ENcel's uGique "Pfvot Tabe" Tool²provide a quic methodfor anaZyzing, ]ummariz*ng, andcompari_g your Bata quiMkly. ThVnk of i& as a c0osstab YeneratoU on ste`oids. WBth it, ?t's a sap to tQansposecrossta field aeadings⌠among c]lumn, rRw, and :age dim:nsions,ⁿuntil yu find xactly Whe data·slice y_u need.)P> <B>7se thes[ E-Z RaVbitSteph to ComJare Dat0 in an xcel Da abase:<τB><P> <L> <LI>et's saW that yXu have 9reated S databake in Ex`el for Fn (imagnary) atomobil dealerhip. Th databa+e -- in the forE of a w3rksheet╨data lint -- co6tains rcords fr the s$lespeopKe on stff, the─month, he yearπ the va3ious au>omobilemodels Yor sale sales \otals, "tc. <L≈>Excel' Pivot ²able WiMard aut6mates t$e proce>s of crPating aPivot T4ble. <)I>ClickData on─the mai+ menu. ╒<LI>Cli9k Pivot∙Table. Qhe "Ste 1 of 4 box pos open.┴It inclhdes varWous optSons forßyou to Ouild yofr Pivot■Table f\om: <BR+ <B>Mic$osoft E6cel Lisf or DatDbase<BR, Extern:l Data )ource<B·> MultiOle ConsWlidatio" Ranges5BR> AnoHher Piv]t Table /B> <BR <IMG S'C="tip"<IMG NO≥EXTFLOWα Psst! &lick on·"Excel <ist or 1atabase if youneed tosummarioe data @rom a mDlti-col2mn data╩Excel l!st cont ining l&beled cMlumns. %P> ClicA on "Exfernal DYta Sour`e" if yTu need o summaize and╟query dta from─databas s creatQd in dB9se, Foxro, MS ±ccess, NQL Serv-r, ORAC■E, etc.┼<P> Cli&k on "MTltiple ÷onsolidtion Rages" if╫you nee% to sum7arize a[d combiae data Wrom numMrous Ex el work!heet rages (whch cont4in row (nd colu)n headi9gs). <P) Click en "Anot;er PivoQ Table"if you eed to 4ork wit data fHom anotAer pivoq table ontaineA in thi same wrkbook.<BR> <L7>For thO purpos&s of thVs examp]e, you Uill buiVd your =ivot Tale from▐the abohe "autoPobile dSalershiI" works>eet dat list. 3hereforM, click╘in the lpace to⌠the lefb of "MiFrosoft xcel LiHt or DaPabase."╛ <LI>Cl ck Next The "SNep 2 of4" box ]ops opeP, askin] you tospecifythe loc;tion of∩your so2rce dat . This !s where▀you tel1 Pivot 5izard tQe works>eet ranYe you wash to upe. (PivTt Wizar then trns thi range nto a "⌠ivot Tale.") <<> This Kource l-st MUST╨CONTAINCOLUMN ABELS (ecause he Pivo7 Table 6izard u&es the elected┬column #abels a4 fieldsΩin the ]ivot taUle). <BC> <LI>U[e your *ouse to╬"drag" cross te cell Eange --τ(or typ! the ce7l range^ (e.g. 71:J20).≤ <LI>ClFck Next' The "Sep 3 of▌4" box %ops opeD. This Bs where you DES≥GN THE )AYOUT fr your ivot taUle. Youhave coWplete f3eedom t\ choosehow the■table wSll be a_ranged ▀- so as▐to giveyou theview ofyour daMa most Ceaningf l to yoT. The pQvot tab e is dioided inHo four Oreas, "5ow," "C9lumn," ≈Data," =nd "Pag." ┬ <LIThe Piv_t TableWizard Fisplaysyour co`umn labZls -- aM fields∩-- in t%e form f "butt'ns" on 3he righ9 side oD the sc[een. Us?ng yourmouse, qou "drad" thesefield b!ttons t any of╟the ares liste above:╪Row; CoXumn; DaLa; Page to lay ut yourpivot t)ble. <■I>Becaue an Ex&el pivoS table s truly─interacive -- 0ou can "ctuallyΩrotate Vts colu`n and r`w headiVgs arou+d the c re data┬area --╔for dif9erent v0ews of 5our dat,. Since our ficjional aHtomobilB dealerlhip datbase co+tains rcords fEr the s:lespeopie on st
ff, the²month, he year═ the vaeious aubo model] for sa-e, sale` totals etc. wC can ea]ily com]are sals data αbroken aut" by Valesperaon, yeaK, automEbile tye, etc. <LI>FoZ exampl, if we"drag" Hhe fielR buttonV markedΩ"Salesp:rson" tK the Pae area,┬(thus bUeaking Nhe pivod table Vnto sepCrate pa]es) -- Und movethe fieFd butto= marked▌"Year" o the R'w area,▀we can 8et up a■pivot tJble for÷one parficular kalesperpon. (Ifwe do te same or anoter sale person─on your╪team, wQ can eaKily com4are -- n a sep\rate pa/e -- ho) each i doing,σ relatiUe to hi& or her─efforts┬at the ealersh*p.) <L>If we ahen "drTg" the Wield bu\ton mar(ed "4 d or mode" to th Column≤area --τand mov! the fi0ld buttZn markeZ "Sales⌡ (whose²data wewant sumarizedµ -- to )he Data÷area, EQcel is ln the w
y to crBating a╟pivot tble thag yieldsa complOte repo3t -- inPluding Xrand toRal -- aLout howmany 4 oor veh'cles thW particXlar salSsperson∙sold --÷in the articul@r calenLar year╘selecte]. <LI>lick Neft. The Step 4 9f 4" boM pops oLen with╛options┬that enDble you·to chooce severNl enhanEement pheferencYs, and ihe finaF locati>n for y,ur pivo table.╪ <LI>Cl(ck Fini8h. </OL <IMG S;C="tip"<IMG NOFEXTFLOW6 Psst! Bxcel's Iefault s to loate you pivot able in─a works eet jus` before°your cu6rent wo"ksheet df you d7 not ch!ose a fnal loc$tion foQ your p vot tabe in "Sep 4 of╫4." <P>ß2TITLE>CBnstructFng a Wokksheet<╙TITLE><><BR> <■MG SRC=°lorenzo√><IMG NLTEXTFLO ><BR> 1here ar a few hings ybu need bo know ^o help :ou use 2xcel toits fulJest.<P>
<UL> <9I><A HR≈F="Crea2ing andstoringcustom /utoFill∙entries°>Creatig and sSoring c]stom Au(oFill egtries</> <LI></ HREF="'eletingΩrows an9 columnO">Deletng rows┬and colXmns</A>·<LI><A 8REF="Enaering fQrmulas"4Enterin[ formulVs</A> <&I><A HRF="Ente/ing cel ranges╪in form4las">En9ering cCll rangNs in foHmulas</3> <LI><9 HREF="RtilizinL built-n functons">Utlizing uilt-in─functio&s</A> <8I><A HR F="Edit-ng a ce l">Editdng a ce4l</A> <■I><A HRΩF="Eras,ng the Bontents╙of a cel">Eras ng the ontentsßof a ce6l</A> <9I><A HR8F="CopyZng a ceTl">Copy&ng a cel</A> <εI><A HRεF="MoviAg a cel3">Movin# a cell/A> <LI)<A HREF3"Fillin: in a r>nge">Fieling in─a range∙/A> <LI≤<A HREF"InsertBng rows and col mns">InPerting ows and┴columns//A> <LI,<A HREF'"Changi/g the w\rksheetview">CFanging ^he work`heet viw</A> <
I><A HR7F="Free]ing titZes">Fre>zing tiJles</A>╚<LI><A 'REF="HiLing row' and coeumns">H=ding roes and cRlumns</ > <LI>< HREF="/earchin and relacing Gata">Se;rching Qnd replNcing daVa</A> <BI><A HR9F="Usin\ spell =heck">UBing spe)l checkµ/A> </U> <P> 2TITLE>FBrmattinD Technijues</TI°LE><P> ∙IMG SRC≥"osg2">IMG NOT XTFLOW>9BR> Ex el has Iots of eatures┴which lXt you f]rmat yo_r works)eets tomake thVm easieP to reaN. Heres a lis& of the+:<P> <GL> <LI> A HREF=Add Bor=ers">Ad: Border</A> <L(><A HRE.="Align╘workshe^t data"Align w]rksheetdata</A <LI><A⌡HREF="AQtoForma">AutoFrmat</A! <LI><A·HREF="CXange CoYumn WidVh">Chan]e Columb Width<$A> <LI>A HREF=±AutoFit▀>AutoFi </A> <L><A HRE="Chang* Row HeGght">ChJnge Row÷Height<!A> <LI>4A HREF= Copyingformats╬>Copyin format</A> <L∩><A HREΩ="Fonts╪and tex`">Fonts°and Tex8 Attrib%tes</A><LI><A REF="Fo$mat speial cha5acter dHsplay">∙ormat secial c
aracter╫display²/A> <LI<A HREF*"Time aad date Wormats"&Time an! Date F rmats</π> <LI><Ω HREF="isplayi5g gridl%nes">Di>playing gridlin[s</A> < I><A HR"F="Numekic valu format1ing">Nu"eric VaBue Form:tting</>> <LI><Ω HREF="0hading
lly, yoR'll wan to prit out ybur work Here'] how toßdo it. )P> <UL><LI><A &REF="HeKders anQ footer%">Addin% Headere and FoRters</A, <LI><A∙HREF="C>oosing printeQ">ChoosQng a Pr nter</A7 <LI><A⌠HREF="I\sertingpage br/aks">InHerting ,age Bre ks</A> ▐LI><A H5EF="Del?ting paWe break`">DeletKng PageBreaks<#A> <LI>1A HREF=ⁿSetting∩up page0">Settig up Pa es</A> √LI><A HEF="PriLt previNw">PrinJ Previei</A> <LA><A HREC="PrintNng a wo ksheet"πPrintin a workheet</AΓ <LI><A╪HREF="P^inting EultipleΣcopies"εPrintinb multip4e copie%</A> <Lε><A HRE ="PrintHng part& of a wrksheet─>Printi%g partsßof a wo<ksheet< A> <LI>/A HREF=PrintinO headin$s">Prin"ing Row┬and Col mn Head<ngs</A>τ<LI><A REF="Wo=kbook p]inting"4Printin: an entFre Work[ook</A>─<LI><A REF="Zo$ming yoKr worksAeet">Zolm your orksheeQ</A> </ⁿL> <P> 2TITLE>FBrmulas >nd Funcmions</TφTLE><P>▌<IMG SR°="rexmaN"><IMG 'OTEXTFLLW><BR> ╔Excel m>kes it asy to ake advTntage oT formulKs and f6nctionsto do cRlculatiMns or o^her ope_ations !n your "ata.<P> FormulDs enablS you to∙multiplO, subtr ct, add or divQde, usi"g valuel contaiBed in dWfferentcells.<> FuncIions arA ready-o-use frmulas Euilt inNo Excel With Eecel's fWnctions" it's asnap todo even·the mosC compli ated kids of o(eration2 on anyσrange oD values you spe9ify.<P> <UL> 4LI><A HOEF="CelQ Addres es">Cel Addreses</A> ΓLI><A H÷EF="Aut'Sum">Au`oSum</A <LI><AΣHREF="C pying fjrmulas"Copying╥Formula</A> <L ><A HRE%="Displying fomulas">µisplayi%g Formu-as</A> LI><A H?EF="Ediging for^ulas">ELiting F,rmulas<▌A> <LI>▐A HREF=╦Enterin: formul(s">Ente.ing For8ulas</A) <LI><AHREF="FHnction Tizard">?unction─Wizard<∞A> <LI>±A HREF=°Naming Kanges">Kaming R
G SRC="$ogalosh°><IMG N(TEXTFLOT><BR> εxcel maHes it a╟snap to┴create Yully pr]fessionKl chart4. The ]ackage Zncludes■numerou] built-Vn chart╥types s- that yau can dLsplay y]ur data∙in charJ form wth only a few mWuse cliks. <P> <UL> < I><A HR3F="AddiQg text 6abels">dding TAxt Labe
tion <Dσ><I>Tab//I> <DB>Move uZ throug) (a) seYection -DD><I>SFift+EntOr</I> )DT>Open╥workboo) <DD><I0Ctrl+F1</I> <2T>Paste∙copied Er cut clls <DD <I>CtrlV</I> ≡DT>Prinm a file⌠<DD><I>1trl+P</,> <DT> ecalcul6te all Bormulas╛(open wrkbooks <DD><IF9</I> <DT>RepRat lastaction 2DD><I>F(</I> <9T>Save =opy of 2urrent 4orkbook╩<DD><I>■12</I> ▀<DT>Sav* WorkboMk <DD><2>Alt+F2/I> <DF>Select(non-nefghborinL) cells╪ ranges┼<DD><I>·hift+F8Γ/I> <D°>Select╪All <DD*<I>CtrlA</I> DT>Spel Check 7DD><I>F </I> <÷T>Switc betwee1 displaXing val(es and isplayig formu#as <DD>²I>Ctrl+Ω` (singYe left duotatio_ mark)<I> <DT√Undo (lst) act on <DD>σI>Ctrl+-</I> <TITLE>'he WebsQer's Leqxicon N-Nonsen0e Availbility &olicy:<TITLE><M><BR> ebster'P Lexxicn Publihing Coep. wanta to enaLle as m"ny peopYe as podsible tM touch,
feel, pYay with▐ and ev luate Sfeve DosVick's RObbitHelI. There<ore, plase feeK free tW (a) up oad thil softwaFe to ang electrRnic bul6etin bo6rd, (b)ⁿdemonstate thi softwaUe and iNs capabYlities,and (c)give cofies to dotentiaa users,·so that∩anyone *ay have╩the opp'rtunity▀to obta.n a copW for usN in accErdance iith thevarious licenseterms ad 30 da evaluaion perod descibed in╪this soRtware p9ckage.<> <A HEF="Lic`nse agr-ements"≡Click h
re to s(e the lHcense areement...</A>▐P> 2TITLE>L<cense</1ITLE><P7<BR> W bster's▌Lexxico# Publis>ing CorI. supplfes thre differBnt licese agrements. Which o\e appliOs to yo6r use oS this s`ftware Bepends Yn whethRr you a$e a:<P>▐ <UL> <>I><A HR(F="Busi\ess, inLtitutioDal, govrnment Kicense"&Busines', instimutional or govSrnment Xser</A>Ω<LI><A REF="HoIe user nd studnt custRmer lic?nse">Ho]e user \r studePt</A> <BI><A HR9F="sharZware diMtributi>n licen0e">Sharware di+tributo1</A> </L> CliAk on thN licens; types Sbove tosee thefr text.!P> <HR><B>STEV DOSSIC('S RABBBTHELP (÷) for W&ndows ( M)</B><&> <B>EEectroni` Editio</B><P>² Copyriht 1995┴by Websger's Lefxicon P_blishin( Corp. .ll Righes ReserTed. Thi] softwa_e is pr!tected y both Gnited SWates Co^yright %aw and ?nternatonal trDaty pro^isions.≡P> AllWebster√s LexxiQon PublLshing C9rp. pro9ucts, iJcluding╛the caroon chaUacters )sgood tXe Rabbia, FrangKapan DuYk, Ooga`osh & PVdeedy, &orenzo at, Rex▌& Max, nd rela,ed indi"ia, areσCopyrigFt WebstNr's LexNicon PuTlishingCorp. Ail RightX Reservd.<P> µll Webser's Le xicon Pblishin Corp. \roducts includ-ng the artoon ^haracte:s Osgoo the Rabit, Fr$ngiapan Duck, O"galosh ╩ Padeed, Loren1o Cat, ex & MaB, and rRlated iadicia, Rre tradMmarks o/ registred traemarks f Webst8r's Lex?icon Pu lishingδCorp.<P) Windoms is a GrademarH of Mickosoft Crporati,n.<P> ther br7nd and Iroduct kames ar tradem>rks or egisterd trade`arks oftheir rOspectiv& holder`, and ace herebW acknowVedged. BUSINES ENTITYΩ INSTITGTIONAL,GOVERNM3NT LICE'SE AGREMENT. I you arD a busiVess ent ty, insmitution or govSrnment Dgency, >his Lic:nse AgrAement aplies t you. Aform to·requestinformaaion regCrding t^is licebse is iccluded Qith thiB softwa/e produt. <P> ⌠HR> <B>ebster'8 LexxicMn Publi\hing CoHp.<BR> 4USINESSENTITY, INSTITU9IONAL, ≤OVERNME≤T LICEN·E AGREE≤ENT</B>αP> IMPRTANT N;TICE TO°USERS (µENTITY"┘ - PLEANE READ AREFULL <P> WEτSTER'S EXXICON PUBLISHⁿNG CORP╥ THANKS┬YOU FOR╫SELECTIG ONE O OUR PR<DUCTS. GHIS IS EHE WEBS<ER'S LEXICON PBLISHINΘ CORP. δUSINESS≤ENTITY,τINSTITUIONAL, OVERNME9T LICENIE AGREE ENT, WH&CH DESCKIBES WEµSTER'S EXXICON╒PUBLISH NG CORP'S BUSIKESS ENT≥TY, INS1ITUTIONΦL, GOVE≤NMENT L<CENSE T3RMS. E8TITY'S SE OF T5IS SOFTHARE IS !ONDITIO8ED UPONCOMPLIA CE BY E TITY WIFH THE T(RMS OF BHIS AGR EMENT. *HE SOFT ARE MAY BE EVAL=ATED FO THIRTYDAYS ON⌠A ROYALBY FREE %ASIS. CNTINUED⌡USE AFT!R THE E⌠ALUATIO≡ IS CON'ITIONED·UPON PAIMENT BYENTITY 1F THE N;GOTIATE8 LICENS: FEE, S*ECIFIED∩IN A LETER OF φONFIRMA ION FRO WEBSTE'S LEXX'CON PUB5ISHING ORP. ("Iebster'k Lexxicln").<P> <B>I. ≤RANT OF┼LICENSE╒</B><P>╞ You acnowledg you habe read Lhis Cus8omer Liense Coitract, =ndersta d it, ad agreeπto be bNund by ts term. This icense uthoriz&s EntitC to usethe numUer of c`pies de[cribed &n the c nfirmat on lettr from *ebster': Lexxic+n Publi>hing Co]p., andfor whi6h EntitV has pabd Webst r's Lex5icon Pulishing÷Corp. tAe negotfated li ense feB. If th confiration lXtter fr]m WebstOr's Lex9icon PuOlishingCorp. iLdicates
that Enaity's lcense i1 "Corpodate-WidH," thislicense∙will be÷deemed o cover copies Luplicatd and dbstribut9d by Enbity foruse on +ny addiIional iJcrement l machies purcKased or·leased Ry Entitf duringthe Terc of thelicense! at no ;ddition0l charg".<P> Tis lice&se will▀be in e+fect frMm the dJte of t>e confidmation detter foom WebsYer's Le$xicon Pblishin Corp. uthorizng such╪continuQd use oJ such o8her perod as in statedΦin the onfirmaion let7er (the "Term")ß If Entty does┬not obtin a co/firmati9n lette_ and pal the apalicablelicense▌fee, ths licene expirs at th8 end ofτthe thi.ty day 0valuatiZn perioZ.<P> T;is LiceKse is e_fective─until t"rminate. You m7y termiGate it ^t any tme by dBstroyin the Sotware tbgether eith any
copies $urrentlf in yofr posesQion. ThO LicensR also trminate1 if youfail tocomply eith th> terms 7nd condtions oE this aOreementα and ad]itional@y you nSed to Gestroy +ny copi:s or vaNiations╛of the oftware<P> AlF updatec must bR accessGd and dewnloadeX from t]e Webst?r's LexGicon Pu lishing╩Corp. e$ectroni" bullet.n board■(BBS), Xr Webst;r's Lexjicon PuZlishing Corp.'sdesigna ed FTP εnternet╟site. A cess intructio&s for tTe licenKed userΣbulleti board \re incl=ded in &he confrmationπletter.P> In 'he case─where Etity is╫licensi/g more >han 500copies bf the S`ftware,all upd tes wil also b providd in diFkette f6rm at n+ chargeδas they occur dkring th8 term oC this lbcense.<⌠> The oftware╒may not÷be distKibuted _y Entit" to any²outside╟organiztion, cbrporati]n, or gYvernmen5 agency<P> <B/II. ONE■CONTACT
INDIVIDBAL.</B>εP> Sup.ort forSoftwarH proble[s and oMher pro:uct iss es will be handTed thro)gh one ioint of⌠contactwithin Whe Enti>y. EntiIy shallⁿdesignae the cntact iQdividuaF when p\acing ias orderwith WeXster's @exxiconPublishCng Corp² or a W"bster's╩Lexxico& Publis'ing Cor5. AuthoPized AgNnt. TheHe will Te no chYrge for supportof the oftware┼when diected trough t is contct indibidual. +upport 6equests╨from ant other 7rganiza&ional aea willπbe subjDct to b lling a Webste's Lexx con pub-ished s?pport rNtes.<P> <B>III EMPLOY-E HOME SE OPTI²N.</B><≥> In te case Jhere En;ity is (icensin2 more tSan 200 Yopies o9 the SoCtware, Pebster' Lexxic,n Publi(hing CoHp. will∙license the Sof ware foO home ue by emloyees \f requeated by /ntity, *n writi[g, withZn the fGrst yea\ of thelicenseα The co1t for tZis optiRn is 22 of the∙standar: site lcense fDe forthIt numbe& of empeoyee hoAe use mOchines. P> <B>V. COPY'IGHT.</ ><P> Tis Softare proGuct (in=luding Qny imagRs, cartQon charWcters, ]llustraiions an> fictio=al loca1ions, (ncludin but no3 limite) to "We@sterlanM"), "apFlets," bhotograhhs, anijations,video, udio, msic, an text icorporaed into╪the Sof`ware, iK owned &y Webstr's Lexsicon Pu*lishing╥Corp. ad is pr2tected Ay Unite States─copyrig
t laws nd inte3nationa6 treatyprovisibns. ThVrefore,you mus1 treat "he softare lik any ot;er copy9ighted )aterialδ(e.g. L book oh musica? recordFng). Yon may no copy a+y printd mater?als whi<h may a`company╔the sofQware, nr print┴copies bf any uaer docuWentatio/ providRd in "o_line" oP other OlectronVc form.εP> Ent'ty acknawledgesthat notitle tH the inJellectu l propeQty in tPe Softwre is tkansferr9d to Enbity. EnWity fur>her ackCowledgeO that fll owneship riJhts to Nhe Softgare wilY remainthe excbusive pfoperty df Webst?r's LexGicon Pu lishing╩Corp., nd Enti3y will 3ot acquGre any [ights tE the SoXtware epceptas bxpressl^ set fo th in tis licese. Entty agre s that ny copiQs of th= Softwa6e made y Entitt will c7ntain te same ropriet$ry notiBes whic appear─on and n the S&ftware.²P> <B> . REVER@E ENGIN8ERING.< B><P> 4icensee▌understnds and┬agrees,╔that th8 licens,d Softw re is t3e valuaMle prop[rty of *ebster'P Lexxichn Publihing Co/p. and s prote9ted by Mhe laws of copyight, tOade secets, an contraVt. Lice\see wilV use it4 best eSforts, Rnd take■all rea]onable `teps to╥protect▐the licWnsed SoItware f`om unauMhorized÷use, coying or dissemiVation, nd willmaintaiB all pr]prietar\ and pr9tective⌡noticesⁿintact.╛Except s expreVsly lic?nsed hebein, LiPensee mCy not uie, copy dissem^nate, dCstribut4, or mo!ify, tr nslate,╪reverse▀enginee7, decomNile, di\assembl;, and/od createderivatfve workX from te licened Soft are, in╞whole o part, +ell, leMse, subDicense,Σrent, gve, len_, or inΦany way╥transfe by anyπmeans oQ in any╙medium,─the licnsed So tware.<> <B>V. WARRA;TY.</B>/P> Webdter's LMxxicon ublishi g Corp.┬warrant that iG has th, right 0o licen>e Entitd to usethe SofGware anA that tae Softwre will▌perform╒substanJially iG accord^nce wit its ac@ompanyig documntationfor a pSriod of
ninety Θ90) day` from tYe date 5ebster'] Lexxic\n Publi%hing Co0p. rece[ves payPent. ThS WarranMy is vo?d if falure of the Sof\ware ha' result^d from 5ccident abuse,or misa:plicatiDn. Any Neplacemnt Softare supSlied to·Entity gill be darranteF for th[ remainXer of t]e origiHal Warr0nty per&od.<P> ╩<B>VII.╪LIMITATONS OF EMEDIES </B><P> WebsteH's Lexx[con Pubdishing @orp. wiQl attem t to anwer you techni al supprt requ sts conOerning Lhe Soft;are; ho'ever, tcis serv1ce is ofered o a reas2nable eEforts bsis onl , and Wbster's╫Lexxico/ Publis2ing Cor]. may nbt be ab]e to re[olve ev"ry supp rt requst. We ster's exxiconτPublish%ng Corp∙ suppor_s the Seftware Bnly if Ft is us^d under─conditi,ns and $n operaJing sysMems for which te Softw>re is d signed.▌P> Youe exclusWve remeNies andßWebsters LexxiTon PublGshing CYrp.'s s\le liablities re replScement Rf this ^roduct Hr refun: of the╚license fee. WMbster's╘Lexxicog Publis<ing Cor^. shallnot be 6iable tD you orⁿany othr perso or entLty for ;ny consUquentiaY, incidGntal, sfecial, Yxemplarn or oth?r direcC or ind&rect daages ar!sing fr.m the u8e of, tFe resul]s of th; use of or theinabiliqy to usJ the prgrams. °ome staes do nt allow─the lim!tation [r excluKion of 0iabilit) for in^identalΦor consquentia damage6 so the above l mitatios or exlusions╫may notßapply t9 you.<P+ <B>VI<I. NO OEHER WAR:ANTIES.∙/B><P> ╬Except s provied abov8, the s6ftware %s provi/ed "AS 4S" witheut warr4nty of >ny kind' This wrranty &s in liu of anO other Parrantibs, exprss or iJplied, ncludin the imclied wa`ranties
of merc)antabilVty and Witness Dor a pa\ticularpurposeα In no #vent wi^l WebstHr's Lexficon Pu;lishing÷Corp. b liable to you Nor damaes, inceuding aBy loss ]f profiWs, lostΩsavings or othAr incidntal or┬consequHntial d;mages abising obt of yoWr use o\ orinab]lity touse the·Softwar4, even &f Webstr's Lex0icon Pu!l ishin, Corp. Mr an au]horized÷Websters Lexxi[on Publfshing CTrp. rep esentatve has een advsed of he poss!bility [f such <amages. P> Becuse comkuter pr7grams a$e inher
ntly co0plex anC thus my not b compleely fre of err0rs, youΩare advVsed to ialidateyour woZk. Webs1er's Le&xicon Pblishin Corp. 7oes notτwarrant▄that th0 licensPd produYt will @eet youO requir^ments, r that 1he opertion of÷the sofMware wiil be unnterrupQed or eror fre.<P> A_though Qhanges Yr impro7ements ao the lZcensed Nroduct Way be mNde, Web%ter's L#xxicon BublishiQg Corp.will be∙under nE obliga ion to Orovide \hem to -ou. Weblter's L9xxicon >ublishiQg Corp.Ωis not Gesponsi>le for roblems┬caused Ey chang?s in thU operatVng charCcterist_cs of aby compuier hardQare or 2omputer▌operatig syste%s which▀are mad* after Rhe releJse of t>e liceneed prodmct.<P> Some juWisdictins do nt allow╟excludig or liiting i%plied wMrrantieK or lim-ting libility aor inci,ental o$ conseqential 'amages, and somjurisditions hve spec al stat6to ry c9nsumer ]rotectibn providions whQch may 0uperced this l mitatio. As a≤result,τthis li)itationδof liabTlity mao not apCly to yLu if prhhibited─by the )aws of .our jur?sdictioG.<P> <?>IX. SE ERABILI1Y.</B><≈> If ay provifion of bhis AgrOement i4 found ao be un]awful, Toid, or
unenforPeable, &hen tha2 provis[on shalO be sevSred froF this A=reement╚and wilK not afNect the╘validitr and en:orceabiZity of Dny of t2e remaiCing proRisions.╛In the vent ofinvalidCty of a^y provi`ion of Vhis lic[nse, thY partieh agree Nhat suc7 invali!ity shal not a fect th$ validi9y of thC remainRng port?ons of fhis lic]nse. Thfs AgreeRent shal be goerned b the la s of th State 'f New Y[rk.<P> °<B>X. N LIABIL∙TY FOR >ONSEQUETIAL DA AGES.</τ><P> I1 no eveMt will
ebster' Lexxicn Publi*hing Co3p. be l3able fo_ direct indireTt, inciLental, 0pecial,╬exemplay, or cnsequenGial dam(ges, or▄lost pr:fits arTsing ouj of the≤use of Lr inabieity to se the )icensed╒product÷ordocum>ntation) even i WebsteO's Lexxcon Pubishing 6orp. oran authYrize d ebster'` Lexxic`n PubliQhing Co\p. reprRsentati(e has b#en advieed of tKe possiPility o? such d7mages, r for aMy claimby any #ther pakty. In Bo eventwill WeEster's exxicon⌡PublishEng Corp╠'s liab lity foU any cl;im, whedher in Pontract tort, er any ohher thedry of lCability√ exceed▌the licnse fee╪paid by▀Entity.σ<P> <B XI. TRA-E SECRE*S.</B><B> You Ycknowleage thatthe licnsed prduct cotains tade secets of ebster'_ LexxicGn Publi7hing Co"p. Furtcer, youΦagree t! take al stepsπnecessaQy to pr"tect th licensd produt, as w&ll as a8y copie` thereoY from dZsclosurM, and s-ecificaly agre not to╔disasse@ble, de*ompile,▄or reve=se engiYeer anypart of≤the souOce codeof the oftware▌from th object÷code, oK from oqher dat
providBd to yo under his Cusgomer LiQense Ag\eement.²P> <B>EII. EXP@RT LAWS■AND ASS?RANCES.)/B><P> ╥Entity grees tZat neitKer the aoftware∙nor the÷direct roduct Shereof Qs intened to b^ shippe8 eitherdirectl\ or ind3rectly Io countNy groupQ, S, W╬ Y, Z, $fghanisNan or tXe PeoplR's RepuDlic of 9hina, ubless a kalidate> export∩license▌is obtaned fro% the U.. Depar9ment of■CommercN.<P> EDtity agdees andcertifibs that Seither his sofware prduct, nr any oher tec nical dMta receAved fro1 Webste"'s Lexxdcon Pub4ishing ⌡orp., nr the d,rect prNduct threof, wll be eported &utside 5he Unit/d State`. If th\s produTt has bMen righ1fully otained y you o tside t;e Unite+ StatesΦ you ag=ee that you wilb not re8xport tEis prodnct, nor─any oth"r techn cal dat7 receiv>d from Tebster' LexxicLn Publihing Cop., northe dirSct prod_ct ther&of, excRpt as pVrmitted■by the Vaws andregulatons of 2he UnitWd StateV and thS laws aGd regul7tions o the juQisdictiWn in wh ch you hbtained⌠this soTtware pUoduct.<> <B>X II. APP(ICABLE ΩAWS.</Bα<P> ThLs agreeGent sha\l be gocerned b[ and codstrued ]n accorYance wiNh the l0ws of t%e Unite States╪and the▀State o+ New YoPk, incl^ding coFyright,trade s]cret ana trademFrk laws┌ If any┼provisin of ths Licene Agree%entshalX be hel< invali(, illegl or un`nforcea*le, the╥validi y, lega/ity and or enfo%ceabiliy of th remain ng prov*sions s2all notin any jay be aWfected Wr impai/ed therby. Any┬claim aising oHt of th0s Agree)ent wil7 be bro`ght in jhe Stat8 of New²York.<P7 <B>XI·. U.S. OVERNMET RESTR CTED RI HTS.</B;<P> Th SoftwaOe and ay accomanying `ateriala are prYvided w*th Rest_icted RZghts. 3se, dupVication or dislosure y the GavernmenW is subXect to Kestrict?ons as et fortG in subXaragrap (c)(1)!ii) of (he Righbs in TeFhnical ata and⌡ComputeN Softwae claus at DFA5S 252.2 7-7013,or subpNragraphU (c)(1)and (2)of the 8ommerci;l CompuCer Soft4are--Re tricted╪Rights t 48 CF 52.227 19, as JpplicabBe. Contdactor/mYnufactuoer is WJbster's╠Lexxico Publising Cor. at t e addre+s below If you°are acq9iring tis softrare pro,uct on ehalf o any un,t or agDncy of 'he Unit d State Govern$ent, th& follow3ng provVsions acply. ThV GovernUent agr"es: (i)╬If this┬softwar producG is sup7lied to▄the Dep,rtment Zf Defenie, this≤softwarB producm is clasified s "Commrcial CEmputer ,oftware)" and te GoverKment is╟acquirig only restricbed righ^s" in t)is softdare proUuct and■its doc_mentati\n as tht term 's definWd in ClDuse 252 227-701 (c) (1)÷of the ∞FARS; aMd (ii) 1f this 'oftwareproduct⌠is suppZied to Dny unitΩor agen8y of thA United╛States ΘovernmeQt other·than thU DepartZent of &efense,the GovYrnment'h rights·in this∩softwar" produc and it+ docume-tation <ill be Befined Rn Claus; 52.227 19(c) (*) of thb FAR, oW, in th case o NASA, n Claus 1852.2╓7-86(d)╪of the :ASA SupHlement 8o the F±R.<P> 7B>XV. CMPLETE ≤GREEMEN∙.</B><P This greemen', toget er with┬any Web*ter's L&xxicon ublishi[g Corp.confirmRtion le\ter con0titute "he entie agreeent betJeen Ent0ty and ebster'> LexxicZn Publiihing CoEp. whicE supers^des any─prior a$reementß includ?ng any Irior li`ense frm WebstBr's Lex icon PulishingCorp., ]r under]tandingφ whethe_ writte_ or oraJ, relatSng to tUe subjet matte0 of thie AgreemHnt.<P> Webster s Lexxi9on Publshing CNrp. resMrves th right mo condu7t or hade conduFted aud3ts to v:rify EnPity's cmplianc with tKis Agre?ment. TXe termsand conFitions ef this 5greemeni shall ;pply to∩all ord"rs submtted to╪Websterµs Lexxi(on PublGshing CXrp. and÷shall sgpersedeany difcerent oW additinal ters on puchase oders frm Entit1. The sQction h=adings 'ontaine in thin Agreem-nt are nserted┼for con9enience only, a!d are nt intened to l mit or %efine t2e substNntive peovisiond to whiKh they /efer.<P∞ WLEXX█90677BK√45E1A--/95<P><B>STEV DOSSIC('S RABBBTHELP (÷) for W&ndows ( M)</B><&> <B>EEectroni` Editio</B><P>² Copyriht 1995┴by Websger's Lefxicon P_blishin( Corp. .ll Righes ReserTed. Thi] softwa_e is pr!tected y both Gnited SWates Co^yright %aw and ?nternatonal trDaty pro^isions.≡P> AllWebster√s LexxiQon PublLshing C9rp. pro9ucts, iJcluding╛the caroon chaUacters )sgood tXe Rabbia, FrangKapan DuYk, Ooga`osh & PVdeedy, &orenzo at, Rex▌& Max, nd rela,ed indi"ia, areσCopyrigFt WebstNr's LexNicon PuTlishingCorp. Ail RightX Reservd.<P> µll Webser's Le xicon Pblishin Corp. \roducts includ-ng the artoon ^haracte:s Osgoo the Rabit, Fr$ngiapan Duck, O"galosh ╩ Padeed, Loren1o Cat, ex & MaB, and rRlated iadicia, Rre tradMmarks o/ registred traemarks f Webst8r's Lex?icon Pu lishingδCorp.<P) Windoms is a GrademarH of Mickosoft Crporati,n.<P> ther br7nd and Iroduct kames ar tradem>rks or egisterd trade`arks oftheir rOspectiv& holder`, and ace herebW acknowVedged.<=> HOME╥USER AN STUDENF CUSTOM(R LICENAE. If yHu are aD indivi ual end user whWse use s not og behalf⌠of a buainess eQtity, i8stitutiDn, or gKvernmen agency╬ this LLcense AAreementappliesto you. P> <HR>Websters LexxiXon PublCshing C>rp.<P> OME USEⁿ AND STDENT CUTOMER LCENSE A%REEMENT%P> IMP%RTANT NATICE TOHOME USBR - PLE&SE READ╠CAREFUL±Y:<P> ■EBSTER'∙ LEXXIC≤N PUBLI HING CO>P. THAN#S YOU FR SELECING ONEOF OUR OFTWARE╥PRODUCT° FOR YOR COMPU3ER. PLE⌠SE READ─THE FOLεOWING LⁿGAL AGREMENT: #OU MUSTPROMPTLL REGIST6R YOUR =SE OF TE SOFTW∩RE PROVδDED WIT± THIS AREEMENTτ(THE "S FTWARE"⌠ BY COM;LETING 7ND FORWRDING T, WEBSTEK'S LEXXφCON PUB ISHING °ORP. ("-ebster'L Lexxicln").<P>╔ <B>I.²GRANT Oφ LICENSµ.</B><P1 If yoc are a Rome use3, WebstRr's Lexiicon Pu@lishing
Corp. g_ants to╥you, as▐an indihidual, D non-exQlusive Kight to÷use one╚copy of the objMct code╘versionof the 'oftwareassociaWed withΩthis li8ense foN person l use o your cRmputer.· This lYcense t\ use thG Softwahe is cobditioneY upon yIur comp;iance w&th the erms of╪this Ag1eement.σ You arC entitlNd to ev7luate tZe SoftwYre on a royaltyfree ba is for hirty dys. Us after he thir,y day ebaluatioF periodΣis furter conddtioned =pon pay ent of he lice1se fee Rpecifie in thi file.<≥> This╫Licenseßis effe-tive unail term\nated. Jou may \erminat" it at ny time┬by destoying t;e Softw(re toge0her wit3 any co[ies curhently iA your Mosessiog. The Lcense a)so term nates i< you faBl to cojply wit the tBrms and╟conditins of t[is agreSment, aXd addit*onally fou need to desRroy any
copies \r varia&ions of▐the soffware.<P! <B>I7. COPYR"GHT.</B<P> Ths Softw@re prod]ct (inc uding agy imageG, carto]n charaFters, i6lustrat>ons andⁿfiction l locat ons, (iQcluding·but notlimitedto "WebUterland), "app`ets," p]otograpBs, anim0tions, 3ideo, a dio, mu+ic, and▀text in(orporatCd into ]he SoftMare, isowned bq Websteo's LexxNcon Pubishing Φorp. an isprot cted by─United tates c[pyright°laws an( interntio naltreaty 8rovisio s. Theefore, <ou must treat te softwre like┬any oth r copyr*ghted m+terial e.g. abook ormusicalrecordi+g). You╬may not┬copy an" printe7 materi(ls whic$ may ac.ompany _he softmare, noE print @opies o_ any us r docum"ntation╒provide: in "onEine" or other eectroni@ form.<≈> You cknowleWge thatno titlO to theßintellePtual pr`perty iL the SoPtware i` transfrred to▐you. Yog furtheU acknowZedge th:t full Ewnershi rights to the ;oftware╘will refain the⌠excluside propeUty of W/bster's⌡LexxicoJ Publising Cor., and \ou will·not acqeire anyrights Vo the Seftware Yxcept ah expresMly set 5orth in▌this liense. Y'u agree▀that an> copies■of the <oftware÷made byyou wild contaik the saRe propretary ntices wich app ar on ad in th Softwa^e.<P> B>III. EVERSE ⌡NGINEERDNG.</B>P> Licnsee un erstand6 and agQees, tht the lcensed ⌡oftware╫is the 7aluableΩpropertf of Webfter's LVxxicon 8ublishi+g Corp.╬and is rotecte by the≤laws of*opyrigh0, tradeδsecrets and codtract. icensee²will us^ its bet eff o/ts, and╒take alB reason:ble stems to prtect thB licens d Softwre fromunautho`ized usO, copyi/g or di`seminatZon, and■will maSntain aYl propretary a,d proteUtive noWices inbact. Ex<ept as ;xpressl! licensDd hereiV, Licen'ee may got use,⌠copy, dWsseminaWe, dist<ibute, Dr modifU, trans
ate, reerse enJineer, >ecompilU, disas`emble, Cnd/or cheate defivativeworks fLom the ;icensed▌Softwar, in wh'le or p rt, sel1, lease
sublicNnse, reDt, give lend, gr in anv way trFnsfer b% any mens or i any me
ium, th licens d SoftwMre.<P> °<B>IV. ARRANTY▐</B><P> Webste:'s Lexxcon Pubishing orp. waQrants tat it hs the r ght to #icense :ou to u=e the S\ftware Tnd thatthe Sof\ware wi)l perfo m substntially╔in accoEdance w0th its ccompanDing doc`mentatien for a≤period Lf ninetr (90) dys from▌the dat WebsteH's LexxBcon Pubiishing ∞orp. re@eives pyment. ⌡he WarrTnty is doid if Pailure 0f the S\ftware Yas resuJted froW accide[t, abus, or mi1applicafion. An\ replacSment So?tware sKpplied o you wHll be wIrrantedor the kem aind9r of thS originDl Warra8ty periDd.<P> B>V. LIδITATION⌡ OF REM(DIES.</ ><P> WUbster'sLexxicoP Publis^ing Cord. will Vttempt No answeA your t"chnical╩support╪request2 concer3ing the■SoftwarN; howev;r, thisserviceis offeoed on areasonale effots basi only, nd Webser's Le0xicon Pablishin? Corp. 1ay not e able oo resol>e every╥support┼request± WebstDr's Lex+icon Pulishing┬Corp. s,pports 5he SoftAare onlf if it \s used fnder coVditions▌and on peratin system for wh<ch the oftware▄is desi2ned.<P> Your enclusive≤remedieP and We[ster's ≡exxicon▌Publish ng Corp's sole∙liabiliqies are╔replaceJent of his prouct or eefund oT the liMense fe&. Websaer's Leixicon PSblishinQ Corp. `hall no& be lia le to yau or an\ other ^erson oK entity÷for any╚consequDntial, Qncidentl, specbal, exeAplary o` other Girect o< indire8t damagAs arisi g from he use Rf, the Lesults _f the u`e of, oT the inWbility ho use t]e progr;ms. Som4 states▌do not llow th limitat(on or e=clusion■of liabRlity foH incide`tal or [onsequektial daRage s s the abve limiations r excluions ma1 not ap\ly to yGu.<P> B>VI. N OTHER RARRANTIS.</B><> Excet as pr2vided aAove, th softwae is prvided "°S IS" w*thout w+rranty \f any k\nd. Thid warran\y is in▌lieu of╬any othr warraties, eKpress o9 implie , inclu/ing the impliedwarrant<es of mBrchanta[ility ad fitne0s for a╒particuBar purpHse. In ko event╔will We?ster's ≤exxicon┴Publish\ng Corp be liaLle to y0u for dNmages, ZncludinE any lo]s of pr\fits, l!st savi,gs, or ather inFidentalor cons>quentiaB damage arisinF out ofyour us of or bnabilitM to usethe SofWware, e@en if W:bster'sⁿLexxico Publis
ing CorS. or an·authorijed Websaer's LeZxicon Pkblishin[ Corp. gepresenNative h0s been dvised f the p'ssibili3y of su(h damagCs.<P> +ecause 9omputerprogramk are ineerentlycomplex╠and thu may no be comletely
ree of rrors, eou are 9dvised 8o validte yourwork. W-bster's╥Lexxico Publis+ing CorO. does !ot warrnt that┬the lic nsed pr0duct wi6l meet four reqhirementd, or thIt the o-eration╬of the oftware╔will be≤uninter9upted o. error 1ree.<P> Althou]h chang8s or imMrovemenms to th licens"d produt may b; made, 0ebster'p Lexxicn PubliPhing Cop. will┴be undee no oblWgation ^o provi%e them ao you. Hebster'Q LexxicYn Publi`hing Co$p. is n-t respo`sible fRr problSms caus>d by ch7nges in╚the opeQating cParacter stics o_ any coAputer hOrdware Rr compu>er oper6ting syOtems whch are ade aftHr the r?lease oV the liPensed pToduct.<F> SomejurisdiXtions dI not al;ow excl2ding or╩limitin implie# warran9ies or Jimiting liabiliJy for i`cidentad or conpequentiFl damags, and ome jursdictios have pecial +tatutore consum=r prote'tion pr visionswhich m)y superede thi limita7ion. AR a resu t, this─limitat on of l abilityßmay notΩapply t\ you ifprohibieed by tPe laws ,f your urisdicion.<P>╔ <B>VII SEVERA ILITY.<δB><P> f any p]ovisionof this≤AgreemeKt is fonnd to b unlawf2l, voidß or to 8e unenfHrceable) then tat provFsion shll be svered feom thisAgreemeXt andwi-l not aSfect thV validiRy and eXforceabVlity of╥any of 2he rem Sining pUovisiona. In th> event Ef invaldity of any pro^ision o this lbcense, Hhe partWes agreH that s?ch invaAidity sDall not╛affect he valiGity of Nhe remaYning po_tions oH this l_cense. Hhis AgrZement sBall be 6overned▌by the aws of ,he Stat$ of NewσYork.<P <B>VI2I. NO L ABILITYFOR CONKEQUENTI>L DAMAG*S.</B><ⁿ> In n event hall Wester's ≡exxicon╪PublishUng Corp or itsΣsupplie"s be li\ble forΦconsequntial, ncident$l or inCirect dmages o
any kid arisi%g out o' the de6ivery, ]erformaace or ude of thM Softwa/e, even╬if Webser's Le!xicon PHblishin. Corp. $as beenδadvised of the fossibil<ty of sRch dama`es. In o event▌will Wester's "exxicon∙Publishfng Corp╫'s liabFlity fo any clim, whegher in Qontract tort, 0r any oaher the`ry of lGability exceedthe licnse fee▐paid byyou.<P> <B>IX.EXPORT %AWS AND÷ASSURANδES.</B>P> Youagree t at neitaer the Goftwarenor thedirect :roduct Ihereof Es intened to b shippeG either·directli or indVrectly Vo counthy groupgQ, S, W! Y, Z, fghanisCan or t%e Peopl's Repulic of hina, :nless a■validatNd exporJ licensW is obtYined frlm the US. Depa tment o Commer
e.<P> ou agre and ce*tify thMt neith=r this 7oftware╨product' nor anA other &echnica data r(ceived Erom Web&ter's L xxicon ≥ublishi%g Corp.φ nor th/ directproductthereof will bM export"d outsie the Uited St
tes. If≤this pr6duct ha/ been r4ghtfulld obtain[d by yoH outsidB the Unbted Staes, you▌agree t at you Mill not∙reexporq this poduct, Kor any ther tehnical Wata recSived frYm Webst&r's Lexeicon PuSlishing■Corp., Xor the Qirect p$oduct t&ereof, Wxcept aV permitbed by tAe laws 7nd reguations Nf the UVited Sttes andthe lawG and reUulationV of theΩjurisdi8tion inⁿwhich yu obtaied thissoftwar? producd.<P> </>X. APP.ICABLE BAWS.</B2<P> Th^s agreeGent sha;l be go3erned b# and co&strued (n accor)ance wiRh the lJws of t>e UniteV Statesand the State oK New Yo k, inclding coyright,╞trade s cret an trademMrk laws If anyΣprovisi n of thds Custo5er Lice se Contactshal/ be helC invali, illegl or unnforceale, theßvaliditC , legaYity andor enfocceabili\y of th" remainng prov sions sall not≤in any >ay be a"fected :r impai]ed ther[by. Any≤claim aOising ont of ths Agree*ent wil! be broKght in Mhe Statb of New╔York.<P <B>XI╒ TRADE ⌠ECRETS.//B><P> You ackXowledgeßthat thR licensVd Softw?re contKins traQe secre&s of We ster's >exxiconPublishWng Corp FurtheH, you aree to Sake allsteps ncessaryto prot9ct the ZicensedSoftwar/, as weAl as anU copies╛thereof╬ from dLsclosur?, and s`ecificaYly agreG not todisasseable, deXompile,·or reveAse engi+eer any╩part of╪the sou1ce codeσof the Qoftware from th; objectcode, oj from oqher datF providd to yo under his Cusomer Liense Ag*eement.(P> <B>0II. COMLETE AGEEMENT.7/B><P> ΦThis Ag$eement,┼togethe5 with aMy Webstr's Lex icon Pulishing╫Corp. l&tter ofΩconfirmNtion coastitutethe entQre agre"ment be"ween yo and We ster's exxiconτPublish%ng Corp∙ which ^upersed[s any pEior agrBement, bncludin any pr&or lice#se from÷Webster s Lexxi`on Publshing CLrp., or╟understnding,w[ether w`itten o\ oral, 3elatingto the dubject Katter oP this ATreementα The te0ms and UonditioQs of thWs AgreeFent shaBl apply╚to all Nrders s]bmitted╘to Websmer's LeLxicon PcblishinJ Corp. +nd shalA supersAde any ifferen or addLtional Nerms onpurchasR ordersfrom yok.<P> <6>ANY QU:STIONS?/B><P> ∩If you %ave any╩questio&s conce1ning th* terms Mf this *greemenJ, pleasW call (/18) 897*1554, FFx (718)╠896-048┘, or wrte to W bster's─Lexxico& PublisTing CorH. Attn.ΣInforma$ion Serqices, P÷O. Box Θ51034, δorest H,lls, NeV York 1Σ375-863╪.<P> <Pα WLEXX9≡0677BKR⌡5E1A--1∙95<P> <B>STEV DOSSIC('S RABBBTHELP (÷) for W&ndows ( M)</B><&> ElectKonic Edftion<P>╔ CopyriDht 1995╟by Webser's Lekxicon PcblishinQ Corp. ll Righas Reserged. ThiQ softwa\e is pr\tected y both nited Sfates CoSyright :aw and Bnternat?onal traty proUisions.$P> All╘Webster s Lexxi7on PublWshing CRrp. pro.ucts, iCcludingⁿthe caroon chaacters 2sgood tBe Rabbid, FrangVapan DuEk, Oogabosh & PUdeedy, Aorenzo at, Rex∩& Max, nd rela ed indiia, are▀Copyrig-t WebstCr's Lexaicon Pu8lishingCorp. Adl Rightp ReservJd.<P> φll Webser's Le xicon Pblishin Corp. (roducts includAng the 'artoon haractems Osgoo, the Rabit, FrngiapanπDuck, ONgalosh ┘ Padeed , Loren o Cat, ex & Ma9, and r/lated i[dicia, Tre tradVmarks oZ regist"red traemarks f Webstr's LexKicon Pu)lishing▄Corp.<P Windobs is a jrademar> of MicOosoft Chrporatin.<P> ther brnd and Froduct Games arb tradem
rks or Oegister d tradearks oftheir rSspectivO holder4, and a_e herebj acknowJedged.<:> SHA?EWARE D√STRIBUTON LICE@SE AGRE(MENT. IT you ar> a Shar;ware DitributoQ,this LQcense Areementappl ieG to you <P> <HR! <B>Web=ter's L:xxicon ,ublishi g Corp.▐BR> SHA5EWARE D#STRIBUT9ON LICE;SE AGRE'MENT</B4<P> IMDORTANT COTICE T) SHAREWRE DISTIBUTORS╩("DISTRBUTOR")∙<BR> PL
ASE REA" CAREFU5LY<P> ÷THIS ISTHE WEBKTER'S LBXXICON 5UBLISHI·G CORP.┼SHAREWA∙E DISTR∩BUTION ≡ICENSE ∙GREEMEN@, WHICH°DESCRIB S WEBST⌡R'S LEXSICON PU
LISHING╥CORP.'S┼SHAREWAE DISTR(BUTION ICENSE °ERMS. PεEASE RE°D THE FLLOWINGΩLEGAL A4REEMENTCAREFUL=Y: DIST:IBUTOR' RIGHT O DISTRδBUTE TH≥S SOFTWRE IS CNDITIOND UPON OMPLIAN.E BY DIITRIBUTO% WITH T%E TERMSOF THIS─AGREEME T.<P> ±B>I. GRNT OF L"CENSE.<,B><P> ebster'P Lexxicn Publihing Coep. ("WePster's 6exxiconπ) grant` to theDistribStor a nYnexclusVve, wor dwide r'ght to VistribuWe the oPject co=e versiEn of th SoftwaQe as shIreware.╘This li\ense to⌠distribcte the 6oftwareΩis cond>tioned Qpon Disributor╔s complLance wiNh the tUrms of ahis AgrGement. Distribitor wila not coJy the S>ftware,▌except s neces+ary to 4se it i3 accord?nce witQ this l?cense. 6istribulor is goanted nT right o modif or subicense he Softare. Di+tributo^ may doOnload t,e Softwre filen from W-bster's╥Lexxico Publis+ing CorO. elect%onic buletin bard sys+em (BBSΩ at (71)897-69 2, sett\ngs are8Nl, AN;I or TT emulaton, and┬full dulex, or≤from We)ster's exxiconδPublishTng Corp$'s desi:nated F1P Interget site╥ All fi)es of t is SoftMare musM be disqributed╔bundled²togethe, with he Softjare .EX3 files Lundled 8ith theall .DO4 .INI .0HS or .>XT file`. All S!ftware "istribufion musW be viadiskett>s (whic> are ei her wriSe-proteKted or "otchlesl) or vi5 CD ROM (in whLch caseΩthe ori<inal ar?hive fi
e from ∙ebster'V LexxicIn Publiching Co_p. mustbe used .<P> D]stributdr is prIhibited∩from in0talling╩copies 'f the S.ftware 4n hard Brives o[ tape m;dia, anV distriZuting srch harddrives,╠or tape┼storage╟media.<÷> <B>Iφ. NO SU·LICENSE FEE.</B<P> Sh%reware ⌠istribuoors mayΦnot cha$ge thei custom(rs for She Soft*are oth r than nomina# fee fo3 disket>es, andmust ma^e clearon the Liskette▌package╬and disette la el that≤the Sof;ware on▄the dis6ette is for evabuation Curposes²only, agd that ts use eyond 3σ days r;quires : valid iicense r regisQration hrough °ebster'f Lexxic]n Publi]hing Co3p.<P> @harewarV Distri@utors aQree notto offe$ any se0vice orsubscriStion thOt inclu=es updaJes of Wbster's LexxicoV Publis ing Cori. Softw5re. SucV accessto, or :rovisioC of, We>ster's Ωexxicon┬PublishLng Corp Softwabe updatRs is a Denefit ef propefly licecsing th? SoftwaAe throu$h Webstr's Lex0icon Pu!lishingσCorp.<P All rNgistrat?on and ^icensin_ opportrnities Xhall be╠referre to Webter's L xxicon ⌠ublishi&g Corp.(P> <B>!II. COP RIGHT.<▀B><P> Ohis Sof<ware pr!duct (icludingπany imaFes, car'oon chaacters,┬illustrtions a/d ficti9nal locNtions, includi_g but nWt limit"d to "Wbsterlad"), "aplets,"≤photogr(phs, an%mations≈ video, audio, cusic, aAd text FncorporZtedinto─the Sof1ware, i( owned 8y Webst>r's Lexuicon Pu lishinD Corp. nd is potectedby UnitSd State] copyri(ht lawsand intVrnation?l treatc provisVons.<P>╥ Distri utor ac]nowledgHs that \o title∙to the ?ntellec ual proOerty inthe Sof(ware istransfeFred to 2istribuWor. Dis>ributor⌡furtherⁿacknowldges tht full RwnershiJ rightsto the @oftwarewill recain theexclusike propeLty of W4bster's▌Lexxico Publis ing Cor/. and D.stributMr will Wot acqu?re any dights tg the Soctware e]cept as╠expressy set frth in his lic nse. Di+tributo^ agrees°that an= copies╨of the NoftwareΦmade by╥Distribtor wil/ contaiM the sa e propretary ntices w ich app&ar on a8d in thR Softwaee.<P> -B>IV. R-VERSE E GINEERIⁿG.</B><≥> Distibutor 4grees t/at it w%ll not ,ttempt, and wilb use itF best eCforts th preven its em-loyees rom att;mpting Mo reverpe compie, modiCy, tranlate or┴disasse`ble theSoftwarO in who-e or inpart.<P/ <B>V.■LIMITED
END USE? WARRANY.</B><> Websfer's Le[xicon Pcblishin@ Corp. Marrants╚the SofSware TOEND USES ONLY,iursuant⌠to the berms anG condit3ons of Ihe end Qser licnse, an NO warUanty is·extendeT to Disaributor In theevent t\e SoftwVre does·not con5orm to 1he limi ed warrnty des"ribed i3 the enB user lRcense, -ebster'e Lexxicgn Publiphing CoWp. will╠provide┼the end╟user wih a soltion in╪accordaZce with°the ter1s of th end us`r licen;e. Dist$ibutor grees t2 providD Webste%'s Lexxcon Pubishing ·orp. wi5h reaso8able as`istancein provZding waZranty a0sistanc to end┬users.<∙> <B>V . NO OTER WARR²NTIES.<·B><P> 0xcept ai provid8d above the so_tware i provid"d "AS I" withoKt warraGty of aky kind.╔This waOranty i in lie of anyother wOrrantie], expre4s or im]lied, i_cluding■the impVied war_anties !f merch ntabilify and fLtness f]r a parMicular Furpose.╚In no eUent wilT Webste&'s Lexxbcon Pub@ishing 1orp. beliable >o you fDr damagAs, inclding an loss oI profitM, lost cavings,or otheT incidedtal or Wonsequectial daGages ar8sing ou1 of you use of╪or inab(lity toσuse the■SoftwarN, even ?f WebstWr's Lexpicon Pu_lishingCorp. o an autorized ■ebster' Lexxicn Publi+hing Co^p. repr=sentati:e has ben advined of t0e possiility o such d$mages.</> Some╙jurisditions d not al#ow excl6ding orΩlimitinT implieW warraneies or Timiting▌liabili"y for icidenta or conFequenti(l damag!s, and >ome jurTsdictiods have Fpecial Ptatutorr consum r prote tion pr$visions÷which m:y super`ede thi limitaQion. A a resut, thislimitatWon of lSabilityßmay notapply t` you if■prohibi^ed by tUe laws !f your (urisdicfion.<P> <B>VII SEVERAILITY.<B><P> ±f any pQovisionof this╘Agreemegt is foInd to bS unlawfXl, void÷ or uneCforceabHe, then╛that prvision Vhall be·severedfrom thVs AgreeOent andwill noh affectthe valCdity an3 enforc"ability╩of any 'f the r$mainingσprovisiMns. In ]he evenJ of invSlidity gf any poovisionof this╠license╤ the paties agee that─such in.alidity shall nGt affec8 the va idity oa the re5aining "ortions┼of thisπlicense This Areement─shall b govern d by th& laws o0 the StNte of NXw York.-P> <B>>III. NO▌LIABILIY FOR C±NSEQUEN²IAL DAMGES.</B<P> In▄no even? shall Bebster'i LexxicBn PubliPhing Cokp. or is suppl&ers be !iable fEr conseJuential) incidetal or Fndirect╟damages┴of any ^ind ariaing out
of the %elivery perfor^ance or■use of ^he Softdare, evn if We ster's >exxiconPublishWng Corp has be;n advisd of thD possibQlity of╘such dafages. IB no eve\t will :ebster'= LexxicDn PubliOhing Cop.'s libility Ior any =laim, wXether i[ contraEt, tort" or anyother t]eory of·liabiliCy, exce"d the lcense f e paid !y Distr.butor ELtity.<P' <B>IX EXPORTLAWS AN< ASSURAKCES.</B#<P> Di tributo agrees╟that nether th softwa*e nor tTe direcL produc8 thereo is int`nded toΦbe ship"ed eith
r direc7ly or iMdirectl, to coutry grops Q, Sπ W, Y, , Afgha8istan o_ the Pebple's RVpublic Wf ChinaΘ unless╬a validted exprt liceAse is o)tained "rom theδU.S. De[artmentof Comm8rce. DiPtributok Entity─agrees nd cert fies th7t neith>r this poftware╔product nor an other echnica_ data rSceived Prom Web4ter's LRxxicon AublishiLg Corp. nor thR direct╥product▐thereof will bH exportSd outsi=e the UDited St tes. If this prWduct ha' been rbghtfullM obtainSd by yoX outsid/ the Un>ted StaPes, you╛agree t
at you Zill not·reexpord this p_oduct, Por any ether teWhnical Yata rec?ived fr>m Webst"r's Lex"icon Pulishing▀Corp., 3or the Birect p[oduct t>ereof, Wxcept ak permitqed by tMe laws nd reguations f the Uited Sttes and╪the law_ and re?ulation7 of the╨jurisdi^tion inΦwhich y!u obtaied thisπsoftwarD produc'.<P> <µ>X. APPεICABLE AWS.</B <P> Th3s agreeZent sha_l be gogerned ba and co+strued n accorance wi h the l4ws of t/e Unite Statesδand the State o\ New YoEk, inclRding coiyright,─trade s"cret an tradem7rk laws If any provisin of thFs Licene Agreeent sha_l be heZd invalSd, ille(al or u[enforceRble, thC validi^y, legaYity and╥or enfo0ceabilify of thH remainWng provBsions s>all not╚in any Vay be aNfected #r impaiked ther9by. Anyclaim aUising o?t of th>s AgreeIent wil
be broght in Whe Stat? of NewYork.<P+ <B>XI U.S. GEVERNMENH RESTRI8TED RIG"TS.</B> P> If istribu or prov!des the▀Softwar* for usC by DoD Distri8utor agdees to ansure teat the 8oftware╠and any┼accompaying maerials re prov!ded witT Restri;ted Rig,ts. Use▄ duplic\tion, o: disclo%ure by he Gove5nment iR subjec' to resriction as set╫forth i/ subpar+graph (P)(1)(ii of TheRights Qn Techn&cal Dat and Coputer Sftware 6lause a; DFARS ε52.227-013, or subpara]raphs (6)(1) anA (2) ofthe Comercial omputer╒Softwar;--RestrBcted Ridhts at ▌8 CFR 5.227-19╙ as appicable.Contracbor/manuPacturerßis Websaer's Leixicon PSblishinQ Corp. Nt the adress b#low. IfDistribXtor prodides th> SoftwaHe to or╚on behaKf of ana unit o& agencyof the )nited Sbates GoYernment÷ the foAlowing Lrovisio s apply╨ The GoYernment·agrees:(i) If ahis SofVware preduct issupplieY to the·Departm4nt of D"fense, his Sof,ware pr.duct isσclassifGed as ",ommerci7l Compufer Softoare," akd the GTvernmen is acqiring oly "resricted ights" !n this ?oftware°productΣand its╨documenoation a; that trm is d
fined i1 Clause 252.227α7013(c)─(1) of he DFAR
; and (*i) If t2isSoftwNre prodhct is sfpplied \o any u+it or aency of┬the Uni ed Stat8s Gover5ment ot$er thanδthe DepLrtment ef DefenFe, the $overnmegt's rig ts in t%is Soft,are pro:uct and∙its docrmentatin will ?e defin d in Cluse 52.%27-19(c (2) of
the FARφ or, inthe casV of NAS , in ClKuse 185 .227-86┌d) of t&e NASA EupplemeQt to thS FAR.<P <B>XI . COMPLφTE AGRE$MENT.</*><P> T is Agre^ment coBstitutea the enWire agr/ement b:tween DEstributr and Wbster'sLexxicoH PublisXing Cor]. whichsuperseZes any drior aggeement,·includi=g any p/ior licnse fro% Webste1's Lexx.con PubJishing ,orp. or÷understSnding, ohether tritten Tr oral,╠relatin to the╟subject╞matter f this ∙greemen`. Webst=r's Lex<icon PulishingCorp. r-serves &he righ to con'uct or Gave conucted adits to┬verify √istribu5or's co7pliancewith th\s Agree^ent.<P> <B>ANY▌QUESTIOⁿS?</B><≥> If yu have 4ny ques;ions co*cerningδthe terXs of th_s Agree@ent or Ppecial irograms─for edu ational╒or char?table oKganizatfons, plase calI (718) ▀97-1554═ Fax (7$8) 896- 484, or
write t0 Webste_'s LexxZcon PubJishing -orp.Att[. Infor ation S#rvices,P.O. Bo[ 751034 Forest∙Hills, $ew York╚11375-834. Web[ter's Lxxicon Loftware⌠programa are avDilable +t speci6l discoQnts for╛bulk puchases Ior saleM, promodions, p_emiums,fundraiiing, oreducatidnal use Specia; Editio+s can aso be c*eated t. specif.cation.P> Fo[ detailI contacf:<BR> Darector, Sales ISformatin Cente<BR> We ster's ≥exxicon─Publish!ng Corp<BR> P.'. Box 7∙1034<BRε ForestHills, ew York╥11375-8█34<BR> nternet sales@*ebsters╥com<P> ▐P> WLEX990677B R45E1A-≈1/95<P> 2TITLE>FEangiapaK Duck</MITLE><PΓ <IMG SC="fran iapan">IMG NOT XTFLOW>9BR> Fr
ngiapan²Duck is╟a longt
me friead of OsUood. HO learne% all heknows aSout comNuters f\om OzziR. Righ& now, h# works bart timH in LorSnzo's pBzza shoF, and p rt time with OsOood hel$ing peoile learB about QomputerV.<P>2TITLE>LBrenzo C>t</TITL>><P> <φMG SRC=▀lorenzo╫><IMG N%TEXTFLO0><BR> Iorenzo ∞at owns²the neihborhoo pizza carlor i\ Osgoods home 5own. WhRn he's _ot cookGng, LorOnzo's bbsy lear ing all▐kinds oX neat tKings yoc can do∙with coCputers.╚ "I cant wait \o write╘my auto[iographM," saysLorenzo "I'd ,et lots⌡of peopHe would╛love to┬find ouW how a =at beca]e a cheS!"<P> 2TITLE>OBgalosh >nd Pade^dy</TIT≡E><P> ∙IMG SRC≥"oogaloIh"><IMG∙NOTEXTFIOW><BR>╔ OogaloPh and Pdeedy ae lifelbng frie\ds of O]good, h"ving mea him inhigh scFool. WRen theyre not !ut play'ng gamee and haYing fun they wHrk with÷Osgood t WebstDr's Lex`icon Pulishing% writin; softwa`e.<P> 2TITLE>R8x and M>x</TITL>><P> <φMG SRC=▀rexmax"≤<IMG NO*EXTFLOW<P> Reu and Ma! own a Oeally col nighclub riZht nearOsgood'] house.ßThey'vebeen plRying saV and tr_mpet si[ce high╥school,▐when thWy were Ln a banR with OSzie. T>ey alwa!s supplX the en\ertainmnt whenOsgood Hhrows aparty!<3>2TITLE>ML FriendP</TITLE7<BR> <B÷> <IMG RC="osgτ"><IMG $OTEXTFL(W><BR> >ll my fiends w>nt to h lp you se Exce_ to itsfullest Let m& tell y\u a litele abouR each oXe.<P> <5R><S> C ick on #ach namW below Wo learnabout m> and my÷buddiesΓ<P> <UL <LI><AHREF="O'good Ra[bit">Os;ood T. @abbit</$> <LI>< HREF="rangiap=n Duck"▄Frangiaan Duck /A> <LI<A HREF-"Lorenz\ Cat">LQrenzo CWt</A> <@I><A HR:F="OogaFosh and∩Padeedy▀>Oogalo h and Pdeedy</ > <LI>< HREF="0ex and 6ax">Rex÷and Max./a> </UD> <HR> @opyrighY 1995, ebster' Lexxicn Publihing Cop.<BR> ∙ll Righ`s ReserNed.<P>2TITLE>OFgood T.²Rabbit<(TITLE><⌠> <IMG RC="osg$od"><IM NOTEXT LOW><BR; Osgoo Rabbit²has dedcated h
s life go makinU computOrs easi&r to usR for pe`ple abrMund the
world. While taching .eople ta use woUd proceasors, h> thoughJ to himelf "thDre mustbe a be(ter wayto help⌠people. He's Qow team/d up wiIh WebstAr's Lexicon Pulishingto brinA his kn_wledge \f WindoYs progrWms, likY Microsdft Word Excel,∩and Wor!Perfect╩to user+ around▀the wor1d.<P> ■2TITLE>EIeryday "xcel Te\hniquesα/TITLE>∙P> <IMG╒SRC="fr7ngiapan√><IMG NLTEXTFLO ><BR> EUcel has╟lots of┴really Tdvancedfeature]. But .ost of ahe time you juQt want ^o get y\ur work╥done. ere's same infoUmation ]n the b:sic tec>niques !ou'll uRe all tPe time.≡P> <UL7 <LI><A⌠HREF="Efcel worNbooks a8d works=eets">ETcel's Wrkbooks┬and WorNsheets< A> <LI>,A HREF=Using EZcel's m[nus">Us]ng Excea's MenuM</A> <L><A HRE="Excel╤s (Micr'soft) h$lp">Exc*l's (MiArosoft) Help</A <LI><AHREF="Gging to ^ cell">,oing to╠a (specfic) Cel</A> <≥I><A HRΘF="Keys,rokes iZ worksh=ets">Ke=strokes╨in Worknheets</ > <LI><≤ HREF="≥oving b(tween dHfferent╙workshe ts">Mov ng betw en diff&rent wo<ksheets)/A> <LI1<A HREF."SelectQng cell0">Selec"ing Cels</A> <⌡I><A HRF="Sele*ting co(umns">S0lecting Columns2/A> <LI<A HREF"Selectbng rows╞>Select&ng Rows±/A> <LI<A HREF"Undo">Rndo</A>╔<LI><A %REF="Exting Exel">Exiging ExcSl</A> <UL> <TITLE>elp witE RabbitAelp</TI°LE><P> ∙IMG SRC≥"osg2">IMG NOT XTFLOW>9BR> We' e tried²to make╟Steve Dssick'sRabbitHSlp realVy easy 5o use, `o you cRn get yMur work
done quVcker.<P≡ Here re sometips tohelp yoc use St>ve Doss?ck's Ra
bitHelp to it'sfullestε<P> <UL7 <LI>Wh9never y]u see tHxt in b6ue and JnderlinAd (<A H≡EF="Hel with RDbbitHelJ">like dhis</A>, you cCn clickon it tc find ojt about·that to?ic. <L>You ca click 'n the "√B>Back<⌠B>" butRon on tQe menu Jo go baUk to th] last tlpic youvisited┌ You cn also
lick on╞the "<BΓHistory⌠/B>" bu`ton to Kee a li7t of al the tokics you∩ve seen╥recentl . <LI>he "<B>"ontents∩/B>" buton wil always╫take yo6 back t9 the TaOle of Cbntents. <LI>ThM "<B>Cl,se</B>"╬button ill clo e RabbiGHelp an+ take y+u back ?o Micro^oft WorZ. <LI>rom the²"<B>Seakch</B>"─menu, y,u can sarch foH a topi< in the RabbitHlp data?ase. Yu can sarch bytopic nOmes or Ueywordsßwhich dRscribe ehe topiAs. <LI(ClickinT "<B>Al)ays On op</B>"will keHp RabbibHelp's Pindow oD top of╚every oSher winLow on y#ur scre^n. Use⌠this whSn you'rH follow3ng a seGies of Oteps an don't ant theRabbitH?lp wind_w to beobscureF by WorZ's windcw. </UA> <A H,EF="Tab;e of co+tents">φlick he*e to go▀back toσthe TabJe of CoWtents</><P> 2TITLE>H8llo!</T&TLE><BR7 <BR> <φMG SRC=▀osgood"≤<IMG NO*EXTFLOW<BR> My name is╔Osgood /abbit, nd I li e to th\nk I kn]w a lot
about M*crosoftExcel f`r WindoUs. My Priends Nnd I ar here t- help yau with Whe ExceZ featur>s you'lB use mot often in yourdaily w#rk.<P> WheneveF you hade a queVtion, j?st clic@ on theⁿRabbitHlp menu┬item anG I'll b? there do assisa you.<P My fr_ends cab't waitto meet·you! < HREF="
eet Osgod's fr!ends"> lick he7e to go■see theV.</A><P By thW way, mq friendp call mJ "Ozzie╬!<P> <H≈><S> Hee's a lst of tpics I an help you wit@:<P> <D> <DT><± HREF="@verydayΦExcel Tchnique">Every'ay ExceK Techni$ues</A>─<DD>Excl's Wor"books a/d Works2eets <D1>Using 8xcel's >enus <D,>Excel'0 (Micro!oft) Hep <DD>Ging to 4 (speci-ic) Cel( <DD>KeDstrokes in Workiheets <D>MovinD betweeg differ nt work0heets <∙D>SelecJing CelEs <DD>Sblecting╔Columns²<DD>Sel cting Rws <DD>Hndo <DD,Exiting
Excel ß<DT><A 5REF="Ha_dling WMrkbook 0iles">HNndling orkbook▐Files</3> <DD>AEandoninU changeL to youH workbok <DD>CKosing aworkboo <DD>Coiying a Korksheeb file <'D>Creat3ng a neL workboKk <DD>Easing a Excel ZorksheeN <DD>Fi^ding a dorkbookfile <D:>Movinga works]eet fil? <DD>Op4ning an▌existin workbo'k <DD>O/ening s*veral wMrkbooks at the Iame timW <DD>Refaming wlrksheetX in a wrkbook ßDD>Savig your orkbook─<DD>Sel cting w[rksheetK <DT>< HREF="sing Ma^ros">Au<omating╥Excel Wth Macr2s</A> <#D>Recor a macr <DD>Ply back macro ²DD>Eras/ a macr\ <DD>Asfign a mRcro to \he Tool0 menu <≥D>Halt acro pl
yback DT><A HEF="Con/tructin2 a Work^heet">Censtruct<ng a WoOksheet<(A> <DD>τreate a+d store╒custom utoFill∙entries <DD>Delting coIumns an rows <σD>Enter\ng formclas <DD(Enterin( cell rNnges informulaQ <DD>UtSlizing Ouilt-in╥functio,s <DD>EViting acell <D2>Erasin@ the coDtents o a cell <DD>Copaing a cll <DD>Foving a⌠cell <D2>FillinJ in a r+nge <DDInsertiJg rows nd coluns <DD>&hanging·the wor[sheet vVew <DD>(reezingtitles 0DD>Hidicg rows ;nd colu<ns <DD>earchin and re(lacing #ata <DDSpell cFeck <D=><A HRE ="Formafting">Fgrmattind Your WTrksheet </A> <DΘ>Add Boders <DΩ>Align orkshee, data <0D>AutoFGrmat <D>Change╨Column Ridth <D >AutoFi& <DD>Chnge RowπHeight DD>Copy╙a Forma <DD>Fots and ext Att3ibutes DD>FormNt Conteats of CVll <DD><ime and▌Date Fo mats <Dµ>Format╔Display≤of Perc,nt Sign/, Comma>, Dolla] Signs 2DD>Grid?ines On²and Off<DD>Num ric Val2e Forma)ting <D>Shade ell <DD;Specify╔Decimal²Places πDD>Styls <DT1<A HREF+"FormulKs and F6nctions>FormulRs and FSnctions&/A> <DD+Absolut, Relat've, andMixed CHll AddrSsses <D >AutoSuC <DD>Caculate @n AveraOe <DD>C#py a Fokmula <D>Displag a FormXla <DD>dit a FDrmula < D>Enter╛a Formua <DD>FXnction 1izard <4D>Name N Range DD>Recabculatiob Settin\ <DD>SU' Functi>n For T,taling φells <ⁿT><A HRF="Prin9ing">PrGnting yXur WorkIheets a`d Workbgoks</A> <DD>AddHeaders╠and Fooers to our worsheet <ΦD>Choos an ActUve PrinLer <DD>elete Pge Breaf <DD>Pa/e Break% (inser) <DD>P5eview yNur work&heet be
ore priting. <√D>Printßmore th+n one c\py of aworksheVt <DD>PZint par1s of yo#r works
eet <DDτPrint RBw and C6lumn He dings <D>Print SelecteZ Print reas <D!>Print Zn entir Workbo,k <DD>P'int a wErksheet∙<DD>Set up Page <DD>ZoLm your orkshee <DT><4 HREF="1harts">Aorking ith Cha_ts</A> -DD>Add 2ext LabOl <DD>Aeis, defned <DDⁿChange Battern Rf ChartData SeKies <DDChange δhart CaSegory LIbels <D°>ChangeChart V5lues <D2>ChangeAxis Sc+le <DD>hart AuPoFormat╛<DD>Chat LegenG <DD>Cr?ate a CXart witU ChartWKzard <D:>CreateEmbeddeY Chart DD>Chan6e View ,f 3D Ch rt <DD>√reate S$parate hart WiLdow <DD'Chart s?ze and ehape <D<>Chart qypes <D)>Data Sries <DΘ>Delete╟Element of Chat <DD>D lete (eYbedded)°Chart <D>Edit ≤hart <D?>FormatΦAxes <D÷>Formating cha5t Title <DD>Grilines <ΦD>Legen <DD>Sa-e Chart4 <DT>< HREF="4raphics>Workbo`k and CPart Gra-hics</A∞ <DD>Br ng To Font butGon <DD>
reate O ject inδAnother Applicajion <DDDraw an²Object 5DD>Draw─a Pictu/e <DD>D'aw a PoBygon <D >Drawind inform
tion; gBneral t chnique <DD>Drbp Shadoe <DD>Fo\mat a G3aphic OOject <D5>GraphiA Object], definRd <DD>G$oup a G0aphic OTject <D'>Hide aGraphic∙Object DD>Inset GraphHc Objec\ <DD>In'ert Picmure <DDObject :ayers <'D>Overl+pping GGaphic O>ject <DΓ>Polygos <DD>SHlect a !raphic ?bject <1D>Send 6o Back Xutton <8D>Text 7ox <DD>/ngroup 0 Graphi Object╩ <DT><A╪HREF="D tabase peratioLs">DataKase OpeHations<!A> <DD>9dd a Daqabase RJcord <D≡>AutoFiter <DDσCompare╞Data usng Pivo, Table (DD>CreaLe an Ex'el Dataase <DD9Databas-, (defi ed) <DDπDelete $ DatabaRe Recor <DD>Edt a Datbase Reord <DD Find Ex-el DataOase Recbrds <DD/Narrow In Excel▌Databas Search┬<DD>Pivt Table≤<DD>Que9y (Micr+soft Qu0ry) <DD)Retriev[ Data w<th MicrLsoft Qu^ry <DD>≈ort Exc"l Databse RecoHds <DT<A HREF:"Keyboad short@uts">Ke board S ortcuts//A> </D:> <HR>
Do you )ave sugTestionsor commCnts? WO'd loveto hear╥from yo3. <A HR7F="WritH us!">CZick her> for ouH addres.</A><P We waVt lots #f peopl^ to loo? at oursoftwarH, so we±re makiCg it av=ilable nder ou "No NoQsense APailablidy Policf".<BR> A HREF=No NonsYnse Ava^labilitS">Click∩here to▌find ou about !t!</A><> <A HEF="LicCnse agrNements"Click hWre to s]e your iicense Kor use f this oftware╒</A><P>╞<HR>
