Paste Special

Tips, Tricks, and Answers

The following articles are available for the 'Paste Special' topic. Click the article's title (shown in bold) to see the associated article.

Creating a Shortcut for Pasting Values
Excel's Paste Special command is used quite a bit. If you want to create some shortcuts for the command, here's some ways you can approach the task.

Easily Dividing Values by a Set Amount
When working with large numbers, you may need a way to quickly divide a range of those numbers by a specific value. Here's the absolute fastest way to make the change.

Making Blanket Changes to Values
If you need to update a bunch of values in a worksheet by a standard amount, you can use the Paste Special feature of Excel to make the change easy. This tip illustrates how easy it really is.

Quickly Transposing Cells
If you want to turn a range of cells by 90 degrees within a worksheet, you need to understand how Excel can handle the transposition for you. Here's the absolute quickest way.