英文版 Microsoft Excel 2010 教程

《英文版 Microsoft Excel 2010 教程》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、MicrosoftExcel2010CustomizeExcel&WorkingwithaRangeJanuary13th2012Module02-StartingExcel1CustomizethequickAccessToolbar:YoucanmakeExceleasiertousebycustomizingtheQuickaccesstoolbartoincludetheExcelcommandsyouusemostoften.ClickthecustomizeQuickaccesstoolbarbutton>clickMorecommands>clicktheChoos

2、ecommandsfrom>clickthecommandyouwanttoadd>clickAdd>clickOk.Afasterwaytoaddbuttonstoquickaccesstoolbarisbyright-clickanycommand>clickaddtoQuickaccesstoolbar.January13th2012Module02-StartingExcel2CustomizetheRibbon:YoucanimproveExcelproductivitybycustomizingtheRibbonwithextracommandsthatyouusem

3、ostoften.Right-clickanypartoftheRibbon>clickCustomizetheRibbon>clickNewTab>clickNewGroup>clickRename>typethenameforthegroup>clickOk.Toaddcommandstothepreviewsgroup:clickChoosecommandsfrom>clickthecommandyouwanttoadd>clickthecustomgroup>clickAdd>clickOk.January13th2012Module02-StartingExcel3Cu

4、stomizetheView:YoucanadjustExcelwindowtosuitwhatyouarecurrentlyworkingonbychangingtheviewtomatchthetask.Exceloffers3differentviews:Normalforbuildingandeditingworksheets,pageLayoutwhichdisplaysworksheetsastheywouldappearifyouprintedthemoutandPageBreakswhichdisplaysthepagebreaksasbluelines.Toch

5、angetheview:ClicktheViewtab>clickPageLayout(youcanalsoclickPagelayoutbuttononviewToolbar).ToswitchtoPagebreakpreviewclickPageBreakpreviewbuttononviewToolbar>clickOkToswitchtoNormalviewclickNormalbuttononviewToolbarJanuary13th2012Module02-StartingExcel4CustomizetheView:WhatdoesPagebreakpreview

6、do?PageBreakisapositionwithinaworksheetwhereanewpagebeginswhenyouprinttheworksheet.Whenyouswitchtopagebreakpreview,Exceldisplaysthepagebreaksasbluelines.Ifthepagebreakoccursinabadpositionyoucanuseyourmousetodragthepagebreaktonewpositions.Fullscreenisusefulwhenyouwanttomaximizetheamountofthewo

7、rksheetonthescreen:clickViewtab>clickFullScreenToreturntonormalviewpressEscJanuary13th2012Module02-StartingExcel5January13th2012Module02-StartingExcel6WorkingwithaRange:Arangeisagrouporblockofcellsinaworksheetthathavebeenselectedorhighlighted