Microsoft Office Professional 2010 Step by Step eBook

In the Paste Special dialog box, you can specify the aspect of the Clipboard contents you want to paste, restricting the pasted ...

264 Chapter 9 Work with Data and Excel Tables Excel pastes the contents of column I into column E. Keyboard Shortcut Press Ctrl+ ...

You can limit your search to the current worksheet or expand it to include all worksheets in the workbook. One way you can use t ...

266 Chapter 9 Work with Data and Excel Tables Control Function Format button Displays the Find Format dialog box, which you can ...

Excel highlights cell B16, which contains the value 114. You can conduct a simple text search, or expand the dialog box and sele ...

268 Chapter 9 Work with Data and Excel Tables The Font list displays the fonts that are installed on your computer. In the Font ...

You can replace text, formatting, and formula elements. Click the Format arrow to the right of the Find what field, and then in ...

270 Chapter 9 Work with Data and Excel Tables Tip After you make a change in a workbook, you can usually remove the change as lo ...

Finally, if you want to translate a word from one language to another, you can do so by selecting the cell that contains the val ...

272 Chapter 9 Work with Data and Excel Tables In this exercise, you’ll check a worksheet’s spelling, add terms to a dictionary, ...

Click cell B6. On the Review tab, in the Proofing group, click Thesaurus. The Research task pane opens. The Thesaurus displays ...

274 Chapter 9 Work with Data and Excel Tables You can translate the same word into another language by choosing one from the To ...

Converting a data range to an Excel table provides many data-management capabilities. To create an Excel table, type a series of ...

276 Chapter 9 Work with Data and Excel Tables You can add rows and columns to an Excel table, or remove them from an Excel table ...

If for any reason you want to convert your Excel table back to a normal range of cells, click any cell in the Excel table and th ...

278 Chapter 9 Work with Data and Excel Tables You can change the summary operation performed in a table. On the Design contextu ...

Key Points. ● You can enter a series of data quickly by typing one or more values in adjacent cells, selecting the cells, and th ...

Chapter at a Glance Name groups of data, page 282 Create formulas to calculate values, page 286 Summarize data that meets specif ...

281 10 Perform Calculations on Data In this chapter, you will learn how to ✔ Name groups of data. ✔ Create formulas to calculate ...

282 Chapter 10 Perform Calculations on Data Naming Groups of Data. When you work with large amounts of data, it’s often useful t ...