Microsoft Office Professional 2010 Step by Step eBook

Arranging Multiple Workbook Windows. As you work with Excel, you will probably need to have more than one workbook open at a tim ...

244 Chapter 8 Set Up a Workbook Arranging windows vertically. Troubleshooting The appearance of buttons and groups on the ribbon ...

You can change a button’s position on the Quick Access Toolbar by clicking its name in the right pane and then clicking either t ...

246 Chapter 8 Set Up a Workbook Customizing the Ribbon. Excel 2010 enhances your ability to customize the entire ribbon by enabl ...

Just as you can change the order of the tabs on the ribbon, you can change the order of groups on a tab. For example, the Page L ...

248 Chapter 8 Set Up a Workbook You can add an existing group to your new ribbon tab by clicking the Choose Commands From field’ ...

When you’re done customizing the ribbon, click the OK button to save your changes or click Cancel to keep the user interface as ...

250 Chapter 8 Set Up a Workbook Magnifying selected cells. On the View tab, in the Zoom group, click the Zoom button. The Zoom ...

On the View tab, in the Window group, click the Switch Windows button, and then click PackageCounts. The PackageCounts workbook ...

252 Chapter 8 Set Up a Workbook Adding commands to the Quick Access Toolbar. Click Customize Ribbon. The Customize The Ribbon ...

In the left tab list, click the Home tab’s expand control, click the Styles group’s name, and then click the Add button. The St ...

Chapter at a Glance Enter and revise data, page 256 Find and replace data, page 264 Move data within a workbook, page 260 Correc ...

255 9 Work with Data and Excel Tables In this chapter, you will learn how to ✔ Enter and revise data. ✔ Move data within a workb ...

256 Chapter 9 Work with Data and Excel Tables Entering and Revising Data After you create a workbook, you can begin entering dat ...

You do have some control over how Excel extends the values in a series when you drag the fill handle. For example, if you drag t ...

258 Chapter 9 Work with Data and Excel Tables Another handy feature in Excel is the AutoFill Options button that appears next to ...

In this exercise, you’ll enter data by using multiple methods and control how Excel for- mats an extended data series. SET UP Yo ...

260 Chapter 9 Work with Data and Excel Tables You can restrict cell entries by defining them in a drop-down list. From the list ...

Center Manager for Consolidated Messenger, might want to copy the cells that contain a set of column labels to a new page that s ...

262 Chapter 9 Work with Data and Excel Tables If you position your mouse pointer over one icon in the Paste gallery and then mov ...