Paste Special

Paste Formulas  |  Paste Values  |  Paste Formatting  |  Transpose

Use the shortcut Ctrl + Alt + V to display the Paste Special dialog box in Excel. Next, press an underlined letter to paste formulas, values, formatting, etc.

Paste Formulas

To paste formulas only, execute the following steps.

1. Select cell B5 below and press Ctrl + C (copy shortcut).

2. To select cell F5, press → four times and press Ctrl + Alt + V (paste special shortcut).

The Paste Special dialog box appears.

3. Press F (Formulas).

4. Press Enter.

Result - all without using the mouse!

Conclusion: use the shortcut Ctrl + Alt + V + F to paste formulas only. Visit our page about copying formulas for more tips and tricks.

Paste Values

To paste values only, execute the following steps.

1. Select cell B5 below and press Ctrl + C (copy shortcut).

2. To select cell D5, press → two times and press Ctrl + Alt + V (paste special shortcut).

The Paste Special dialog box appears.

3. Press V (Values).

4. Press Enter.

Result - all without using the mouse!

Conclusion: use the shortcut Ctrl + Alt + V + V to paste values only. Use F2 and F9 to quickly replace a formula with its result.

Paste Formatting

To paste formatting only, execute the following steps.

1. Select cell B5 below and press Ctrl + C (copy shortcut).

2. To select cell D5, press → two times and press Ctrl + Alt + V (paste special shortcut).

The Paste Special dialog box appears.

3. Press T (Formats).

4. Press Enter.

Result - all without using the mouse!

Conclusion: use the shortcut Ctrl + Alt + V + T to paste formatting only. You can also use the format painter to quickly copy and paste formatting.

Transpose

To convert a horizontal range to a vertical range, or vice versa, execute the following steps.

1. Select the range A1:C1 below and press Ctrl + C (copy shortcut).

Tip: to select this range without using the mouse, select cell A1, hold down Shift and press → two times.

2. Select cell E2 (using your arrow keys) and press Ctrl + Alt + V (paste special shortcut).

The Paste Special dialog box appears.

3. Press E (Transpose).

4. Press Enter.

Result - all without using the mouse!

Conclusion: use the shortcut Ctrl + Alt + V + E to transpose data. Follow the link to learn more about this topic!