How to use keyboard shortcuts when Paste Value in Excel?

You are looking for a way to use the keyboard shortcut when Paste Value in Excel, so please join TipsMake.com to find out in the article below.

How to use keyboard shortcuts when Paste Value in Excel? Picture 1

Here is a summary of keyboard shortcuts when Paste Value in Excel, how to use keyboard shortcuts when Paste Value in Excel, invite you to track.

Summary of keyboard shortcuts when Paste Value in Excel

The keyboard shortcut to open the dialog Paste Special (special paste) is Ctrl + Alt + V or Alt + E + S .

How to use keyboard shortcuts when Paste Value in Excel? Picture 2

1. Shortcut combination to paste: CTRL + V ;
2. Shortcut combinations to paste values ​​only: ALT + H + V + V ;
3. Shortcut combination for pasting values ​​and numeric formats: ALT + H + V + A ;
4. Keyboard shortcut to paste values ​​and keep the source format: ALT + H + V + E ;
5. Shortcut combination to paste only the source format: ALT + H + V + K ;
6. Shortcut combination for pasting without borders: ALT + H + V + B ;
7. Keyboard shortcut to paste to keep the width of the source column: ALT + H + V + W ;
8. Shortcut combination to paste only the format: ALT + H + V + R ;
9. Shortcut combination for transposition: ALT + H + V + T ;
10. Shortcut combination for pasting formulas: ALT + H + V + F ;
11. Shortcut combination for pasting formulas and numeric formats: ALT + H + V + O ;
12. Shortcut combination to paste as image: ALT + H + V + U ;
13. Shortcut combination to paste as linked image: ALT + H + V + I ;

Note:

1. Some key combinations do not work in Excel 2007.
2. To use the shortcut key combination when you paste the value, you need to have the copied data.
3. Use keyboard shortcuts: for example, you want to paste the value ( ALT + H + V + V combination ), hold down the Alt key and then press H -> V -> V respectively .

How to use keyboard shortcuts when Paste Value in Excel?

For example, suppose you want to copy the format in cell A1 to cell D5 -> Copy format will use the key combination Alt + H + V + R .

You do the following:

Step 1: Select cell A1 and select Ctrl + C combination .

How to use keyboard shortcuts when Paste Value in Excel? Picture 3

Step 2: Put the cursor in cell D5 and hold down the Alt key , then press the H key -> V key -> R key respectively .

How to use keyboard shortcuts when Paste Value in Excel? Picture 4

So you copied the format from cell A1 to cell D5 quickly.

How to use keyboard shortcuts when Paste Value in Excel? Picture 5

Above TipsMake.com has shared with you the shortcut key combination for special paste in Excel, how to use the shortcut key when Paste Value in Excel. Hope you will easily remember these keystrokes to use in Excel.