英文版-Microsoft-Excel-2010-教程

CustomizeExcel&WorkingwithaRangeJanuary13th2012Module02-StartingExcel1CustomizethequickAccessToolbar:YoucanmakeExceleasiertousebycustomizingtheQuickaccesstoolbartoincludetheExcelcommandsyouusemostoften.ClickthecustomizeQuickaccesstoolbarbuttonclickMorecommandsclicktheChoosecommandsfromclickthecommandyouwanttoaddclickAddclickOk.Afasterwaytoaddbuttonstoquickaccesstoolbarisbyright-clickanycommandclickaddtoQuickaccesstoolbar.January13th2012Module02-StartingExcel2CustomizetheRibbon:YoucanimproveExcelproductivitybycustomizingtheRibbonwithextracommandsthatyouusemostoften.Right-clickanypartoftheRibbonclickCustomizetheRibbonclickNewTabclickNewGroupclickRenametypethenameforthegroupclickOk.Toaddcommandstothepreviewsgroup:clickChoosecommandsfromclickthecommandyouwanttoaddclickthecustomgroupclickAddclickOk.January13th2012Module02-StartingExcel3CustomizetheView:YoucanadjustExcelwindowtosuitwhatyouarecurrentlyworkingonbychangingtheviewtomatchthetask.Exceloffers3differentviews:Normalforbuildingandeditingworksheets,pageLayoutwhichdisplaysworksheetsastheywouldappearifyouprintedthemoutandPageBreakswhichdisplaysthepagebreaksasbluelines.Tochangetheview:ClicktheViewtabclickPageLayout(youcanalsoclickPagelayoutbuttononviewToolbar).ToswitchtoPagebreakpreviewclickPageBreakpreviewbuttononviewToolbarclickOkToswitchtoNormalviewclickNormalbuttononviewToolbarJanuary13th2012Module02-StartingExcel4CustomizetheView:WhatdoesPagebreakpreviewdo?PageBreakisapositionwithinaworksheetwhereanewpagebeginswhenyouprinttheworksheet.Whenyouswitchtopagebreakpreview,Exceldisplaysthepagebreaksasbluelines.Ifthepagebreakoccursinabadpositionyoucanuseyourmousetodragthepagebreaktonewpositions.Fullscreenisusefulwhenyouwanttomaximizetheamountoftheworksheetonthescreen:clickViewtabclickFullScreenToreturntonormalviewpressEscJanuary13th2012Module02-StartingExcel5January13th2012Module02-StartingExcel6WorkingwithaRange:Arangeisagrouporblockofcellsinaworksheetthathavebeenselectedorhighlighted.Whencellshavebeenselectedtheyaresurroundedbyablackoutlineorborder.(Normallythereisonlyonecellintheworksheetwithablackoutline.Thisistheactivecell.WhatevercommandisexecutedbyExcelaffectstheactivecell).ToworkwitharangeinExcel,youmustselectthecellsthatyouwanttoincludeintherange.Afteryouselecttherange,youcanfillitwithadata,moveittoanotherpartoftheworksheet,formatthecells,andsoon.Theeasiestwaytoselecteverycellintheworksheetis:PressCtrl+AJanuary13th2012Module02-StartingExcel7WorkingwithaRange:Toselectarectanglerange:positionyourcursor+overthefirstcellyouwanttoincludeintherangeClickanddrag+overthecellsthatyouwanttoincludeintherangereleasethemousebuttontoendtherandselection.ToselectarangeofindividualCells:positionyourcursor+overthefirstcellyouwanttoincludeintherangeHolddownCtrlandClickineachoftheothercellsthatyouwanttoincludeintherangereleasethemousebuttontoendtherandselection.ToselectanentireRoworentireColumn:position+overtheheaderoftheRoworheaderoftheColumnclicktheHeaderToselectmultiplecolumnsOrrowsorcolumnsandrowsHolddownCtrlandclickeachHeader.January13th2012Module02-StartingExcel8FillaRangewiththesameData:Excel’sAutoFillfeaturemakesiteasytofillaverticalorhorizontalorevenanyselectedrangewiththesamevalue.TofillaverticalorhorizontalRange:inthefirstcelloftherangeyouwanttoworkwith,enterthedatayouwanttofillpositionyourcursoroverthebottomrightsideofthecellclickanddrag(+)downtofillverticalorhorizontalrangereleasethemouse.January13th2012Module02-StartingExcel9Tofillaselectedrange:SelecttherangeyouwanttofillTypetheDataPressCtrl+EnterFillaRangewithseriesofvalues:ByusingExcel’sAutoFillfeature,youcansavetimetofillarangewithaseriesofvalues.TofillaRange:Clickinthefirstcelloftherangeyouwanttoworkwith,enterthefirstvalueintheseriesClickinthefirstcelloftherangeyouwanttoworkwith,enterthesecondvalueintheseriesSelectthetwocellspositionyourcursoroverthebottomrightsideofthesecondcellclickanddrag(+)downtofillverticalorhorizontalrangereleasethemouse.January13th2012Module02-StartingExcel10TofillacustomSeriesofValues:ClickthefirstcellandtypethefirstvalueSelecttherangeyouwanttofillClickHomeTabInEditingGroupClickFillclickSeriesselectanoption(dateanddateunit)clickAutoFillClickOk.DefineaRangename,changeanddeletearangename:Togiveaname(ormultiplenamestothesamerange)toarange:SelecttherangeyouwanttonameClickFormulastabinDefinednamesgroupclickDefineNametypethenameyouwanttouseclickOkOrSelecttherangeyouwanttonameClickinsidethenameBoxtypethenameyouwanttouseclickOkThenameappearsinthenameboxwhenEvertherangeisselected.OneoftheadvantageofdefiningrangesnamesisthattheymakeiteasiertonavigateaWorksheet.TonavigateaWorkbookusingRangenames:clickthenameboxclickthenameoftherangeyouwanttoselectExcelselectstherange.January13th2012Module02-StartingExcel11DefineaRangename,changeanddeletearangename:Youcanchangeanyrangenameby:ClickFormulastabclickNameManagerclickthenameyouwanttochangeclickEditusetheNametextboxtoeditthenameclickOkclickClose.YoucandeleteaRangename:ClickFormulastabclickNameM