Chapter 13. The Paste Special command

Questions answered in this chapter:

  • How can I move the results of calculations (not the formulas) to a different part of a worksheet?

  • I have a list of names in a column. How can I make the list appear in a row instead of a column?

  • I’ve downloaded US T-bill interest rates from a website into Excel. The data displays a 5 when the interest rate is 5 percent, 8 when the interest rate is 8 percent, and so on. How can I easily divide my results by 100 so that a 5 percent interest rate, for example, is displayed as .05?

With the Paste Special command in Microsoft Excel 2013, you can easily manipulate worksheet data. In this chapter, you see how to use the Paste Special command to perform the following types of operations: ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.