02_Basic_Navigation_&_Editing_2007

《02_Basic_Navigation_&_Editing_2007》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、Unit2:BasicNavigation&Editing2.0IntroductionUnit1:TheExcelDashboarddescribedthevariouscomponentsoftheExcelinterface.Thisunitteachesthemostbasicusesofthatinterface.ThisisintendedasgroundingforbeginnersbeforeproceedingtothemoreadvancedUnits.2.1MovingabouttheWorksheetTheobviouswayofmovi

2、ngtheselectedcellinaworksheetistousethemousepointer:leftclickingonacellselectsthatcell;holdingdowntheleftmousebuttonandmovingthepointerselectsarectangleofcells.WehavereducedthemyriadotherwaysofmovingtheselectioninExceltoacorethatallowfastnavigationbutarequicktolearnandeasytoremember.

3、Arrowkeys.Thesemovetheselectedcellonecellatatimeinthearrow’sdirection.Return.Hasthesameeffectasthedownarrow()–movesacelldown(althoughyoucanchangethis–seeUnit3:CustomizingExcel).Pageup/down.Thisscrollsup/downbya‘page’–thatis,bytheheightofthespreadsheetthatisvisibleinthewindow.Thes

4、electedcellwillmoveapageupordowntoo.Ctrlkeyplusarrowkey.Thismovestheselectedcelltotheedgeoftheblockofdatatheselectionison,orifitisnotonablockofdatatothestartofthenextone,or,iftherearenomoreblocksofdata,totheedgeofthespreadsheet.Thisdiagrambelowillustratesthis:Ctrlmovestheselectedce

5、lltotherighthandedgeofthefirstblockoftext;pressingCtrlagainjumpstothestartofthenextblockoftext,andsoon.Thisisusefulinparticularifyouareworkingwithdatabasesthatincludeblocksoftextthatarebiggerthanasinglescreen.CtrlCtrlagainCtrl©2010ExcelwithBusiness1Unit2:BasicNavigation&Editing2.

6、2MovingandselectingThisisasmallthingtolearnbutverypowerful:holdingdownShiftwhiledoinganyofthenavigationtipsintheprevioussectionselectsallthecellsbetweenthestartandendpointoftheselection.Soforinstance,Shift-Ctrl-withcellD5selectedinthefollowingexampleselectsallthecellsincolumnbelowth

7、atcelluptotheedgeofthedatablock:Thisisworthpractising.2.3Find‘Find&Select’searchesthespreadsheetforawordorothersetofcharacters.Ifthosecharactersexistinacell,Findwillselectthatcell.TheFindiconisfoundontherightoftheHometaboftheRibbon.ClickthisandthenselectFind…fromtheresultantmenu.This

8、resultsinabo