Chapter 14

The Paste Special command

Questions answered in this chapter:

  • How can I move the result of a calculation (not the formula) 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 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 0.05?

With the Paste Special command in Microsoft Excel 365, 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 ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial