How to paste shortcut keys selectively in Excel

Small knitting here to teach everyone excel in the selective pasting shortcut keys, learned this method can greatly improve the efficiency of Excel.

Excel tips for choosing to paste shortcut keys in Excel

Excel's selective pasting can help us to implement formula and data conversion, fill format, row and column transpose and so on. As shown in the following figure, CTRL + C copy-Ctrl + V paste, there will be a paste list, the Open will be listed on the common choice of paste items, such as the point "123" will be converted to the value of the formula

The option to paste selectively is also present when you right-click after copying. As shown in the following figure.

If you want to be able to use this function in a pure keyboard state, is there a "paste-selective shortcut"? There are two ways you can try.

1, CTRL + C after the copy, press Ctrl+alt+v key can open the "Paste" window, and then select the appropriate command.

2, CTRL + C copy, press the key next to the right Ctrl (CTRL left, "paper-like with cursor" graphics, the key to open the right key shortcut), you can open the right button menu.

Remember this little skill Oh!