Paste Special Shortcuts in Excel
To open the Paste Special dialog box in Excel, press Ctrl + Alt + V on your keyboard. Now, press the letter that is underlined to paste formulas, values, or formatting.
💎 Paste Formulas
To paste formulas only, execute the following steps.
1. Click on cell B5 and use the Ctrl + C shortcut to copy the cell.
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: Press Ctrl + Alt + V, then F to paste only the formulas without any formatting or values. Check our page on copying formulas for helpful tips.
💎 Paste Values
To paste values only, execute the following steps.
1. Click cell B5, then hold Ctrl and press C to copy it.
2. To select cell D5, navigate two cells to the right and then 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 Ctrl + Alt + V, and then press V to paste values only. To display the result instead of the formula, click the cell, press F2, and then press F9.
💎 Paste Formatting
To paste formatting only, execute the following steps.
1. Select B5, then press Ctrl + C to copy.
2. To select cell D5, press the right arrow key twice, then press Ctrl + Alt + V to open the Paste Special menu.
The Paste Special dialog box appears.
3. Press T (Formats).
4. Press Enter.
Result – all without using the mouse!
Conclusion: Press Ctrl + Alt + V + T to apply just the formatting from the copied cell. You can use the Format Painter tool to duplicate the formatting from one cell to another.
💎 Transpose
To convert a horizontal range to a vertical range, or the reverse, follow these instructions.
1. Highlight the cells from A1 to C1, and use the shortcut Ctrl + C to copy them.
Tip: Without the mouse, select cell A1, hold Shift, and press the right arrow key two times to highlight the range.
2. Move to cell E2 using the arrow keys, then press Ctrl + Alt + V to open the Paste Special menu.
The Paste Special dialog box appears.
3. Press E (Transpose).
4. Press Enter.
Result – all without using the mouse!
Conclusion: To transpose data in Excel, apply the keyboard shortcut Ctrl + Alt + V + E.
11/11 Completed! Learn more about keyboard shortcuts ➝
Next Chapter: Count and Sum