O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

  • I’ve downloaded U.S. T-Bill interest rates from a Web site 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 Office Excel 2007, you can easily manipulate worksheet data. In this chapter, I’ll show how you can use the Paste Special command to perform the following types of operations:

  • Paste only the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required