O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Using Paste Special to Paste Formatting and Perform Actions

If one part of your worksheet contains the type of formatting you need to apply to another part, you can often save time by using the Paste Special command and choosing options in the Paste Special dialog box. For example, you can paste formats or column widths only instead of pasting all the data and formatting from the cells you've copied. The Paste Special command also enables you to transpose data and perform mathematical operations on the cells you're pasting to.

You can access most of the Paste Special options from either the Paste pop-up menu in the Edit groupof the Home tab or the Paste Options pop-up menu, but in most cases it's clearest to use the Paste Special dialog box. ...

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