08_Editing_2007

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

1、Unit8:Editing8.0IntroductionMuchofeditinginExcelissimilartoeditinginotherMicrosoftOfficeapplications.SoifyouknowhowtocopyandpastetextinWord,youwillknowhowtodosoinExcel.ThisUnitcoversthebasicsbutwillalsogiveyouasetofsimpletipsandtrickstocopy/pastemosteffectivelyinExcel.8.1Cop

2、yingBasics‘Copying’inMicrosoftExcelduplicatesthecontentsofallthecellsthatareselected(thesearethenheldtemporarilyuntil‘pasted’somewhereelse).Selectedcellsappeargreywithaboldblackborder.AswithotherMicrosoftOfficeapplications,therearemanywaysofperforming‘copy’.Tokeepthingssimpl

3、e,werecommendusingjusttwoofthese–oneusingthekeyboard,andanotherusingthemouse:Holdingthe‘Ctrl’keyandpressing‘C’(Ctrl-C);or©2010ExcelwithBusiness1Unit8:EditingRightclickingontheselectedcellstobringupthismenuandselectingCopy.SelectingcellsforcopyWhenhoveringoveracell,themouse

4、pointerwilltaketheformofathickcross:Clickingtheleftmousebuttonthenselectsthecellunderthiscross.Holdingthemousebuttondownandmovingthepointertoanothercellselectsallcellsinarectanglebetweenthetwocells.Withthekeyboard,thearrowkeysmovetheselectedcellaroundthespreadsheet.Copyingw

5、holeWorksheetsClickingontheboxinthetopleft-handcornerofaWorksheetselectsallthecellsinthatsheet–andthis(thenpressingCtrl-C,thenpastingitintocellA1ofanewsheet)isonewaytocopyanentireWorksheet.Easier–andsaferintermsofpreservingformattingandlinks–istocopytheentiresheetusingitstab

6、.HolddownCtrl,leftclickonthesheettab,holdingthemousebuttondown,anddragthepointertotherightofthetab:ablacktriangleshouldpointtothegapintowhichthenewsheettabwillbeinserted.©2010ExcelwithBusiness2Unit8:EditingCut‘Cutting’removestheselectedcellcontents,insteadofsimplycopyingit.I

7、fyouwanttodeletethecontentsoftheselectedcellafteryouhavepasteditelsewhere,dojustthatinsteadof‘cut’.Thereasonweadviseagainstusingcutisthat,whilecutting,youlosetheoriginalcellasareference–soyoucan’tseeanydifferencestothecellthatoccurasaresultofthecopy.Forexample,thecellmightco

8、ntainaformulawhoseresultyouwouldexpecttobeunchangedbythemove,whereascopy>pa