O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

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

The Paste Options

Excel 2013 provides you with a number of different options for pasting copied content into other cells. This is because there will be occasions where you want to paste certain elements of a cell's content into another cell, but not the exact contents. Let's look at an example to clarify this. Remember that what is displayed in your worksheet cells isn't necessarily what's in the cells. If a cell contains a formula, it displays the result of the calculations, but its content is the formula itself. So, what if you want to paste the numerical value of the calculation's result in another cell simply as a number, without bringing the formula along for the ride? These types of situations are where Excel's paste options come in handy. ...

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