Note: You need to hold Ctrl + ALT key together and then press “V” to open paste special dialogue box. Now hold “Ctrl + ALT” and press “V” to open the “Paste Special’ dialogue box. The second shortcut key is to open paste special dialogue box is “Ctrl + ALT + V” this will open up the paste special dialogue box, and from there on, press “V” to select the “Values” option.Ĭopy the range of cells to be pasted, then select the targeted cell where we need to paste as values. #2 – Paste Values Using Shortcut Key “Ctrl + ALT + V” After selecting the “Values” option, click on the “Ok” button to get only values.Shift-Command-P: Page setup: Display a window for selecting document settings. Option-Command-I: Show or hide the inspector window. To use Paste Special, just copy normally, then use the shortcut Ctrl + Alt + V in Windows, Ctrl + Command + V on the Mac. As you might already know, Paste special is a gateway to many powerful operations in Excel. Option-Shift-Command-V: Paste and Match Style: Apply the style of the surrounding content to the item pasted within that content. In this video, we'll review shortcuts and commands for Paste Special. From this list, we need the option of “Values” so to select this option in this window, we can press the shortcut alphabet “V,” and it will choose the “Values” options in this “Paste Special” window. Option-Command-V: Paste Style: Apply the copied style to the selected item.Now press the shortcut key “ALT + E + S” (all keys one by one, do not hold any key), it will open up a wide variety of paste special options.Now select the cell or range of cells where we need to paste the copied data.Follow the steps to paste values in excel using shortcut key.
0 kommentar(er)
