![]() ![]() ![]() Using this shortcut doesn't actually finish the Paste, it simply displays the Paste Special dialog, where you can choose which options you want. ![]() To use Paste Special, just copy normally, then use the shortcut Ctrl + Alt + V in Windows, Ctrl + Command + V on the Mac. Of course, the one drawback to this method is that using the macro removes the use of the undo function so if you make a mistake you'll either have to change it manually or return to your last saved version.In this video, we'll review shortcuts and commands for Paste Special.Īs you might already know, Paste special is a gateway to many powerful operations in Excel. Now, whenever you want to paste values, all you need to do is press Ctrl+G, the macro is run, and the values in the Clipboard are pasted to the selected cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |