英文版 Microsoft Excel 2010 教程.ppt

Microsoft Excel 2010 Customize Excel Working with a Range January 13th 2012 Module 02 - Starting Excel 1 Customize the quick Access Toolbar: You can make Excel easier to use by customizing the Quick access toolbar to include the Excel commands you use most often. Click the customize Quick access toolbar button click More commandsclick the Choose commands fromclick the command you want to addclick Addclick Ok. A faster way to add buttons to quick access toolbar is by right-click any commandclick add to Quick access toolbar. January 13th 2012 Module 02 - Starting Excel 2 Customize the Ribbon: You can improve Excel productivity by customizing the Ribbon with extra commands that you use most often. Right-click any part of the Ribbonclick Customize the Ribbonclick New Tabclick New Groupclick Renametype the name for the groupclick Ok. To add commands to the previews group: click Choose commands from click the command you want to addclick the custom group click Addclick Ok. January 13th 2012 Module 02 - Starting Excel 3 Customize the View: You can adjust Excel window to suit what you are currently working on by changing the view to match the task. Excel offers 3 different views: Normal for building and editing worksheets, page Layout which displays worksheets as they would appear if you printed them out and Page Breaks which displays the page breaks as blue lines. To change the view: Click the View tab click Page Layout (you can also click Page layout button on view Toolbar). To switch to Page break preview click Page Break preview button on view Toolbarclick Ok To switch to Normal view click Normal button on view Toolbar January 13th 2012 Module 02 - Starting Excel 4 Customize the View: What does Page break preview do? Page Break is a position within a worksheet where a new page begins when you print the worksheet. When you switch to page break preview, Excel displays the page breaks as blue lines. If the page break occurs in a bad position you can use your m