Microsoft® Excel Data Analysis and Business Modeling

Chapter 13. The Paste Special Command

• 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 single column. How can I make the list appear in one row instead of one column?

• I’ve downloaded U.S. Treasury bill interest rates from a Web site into Excel. The data lists 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 listed as .05?

The Paste Special command in Excel enables you to easily perform certain manipulations of spreadsheet data. In this chapter, I’ll show how you can use the Paste Special command to perform the following types of operations: ...