From the list of available macros, select the PasteVal macro you just created.Press Alt+F8 to display the Macro dialog box. For instance, create the following simple macro: If you want a shorter keyboard shortcut, the best way to do it is to create a macro that does the pasting for you, and then make sure that you assign a keyboard shortcut to the macro. (Or you can use Alt, H, V, V, in newer versions of Excel for the same results.) This sequence selects the menus and dialog box options necessary to paste values. If you don't want to use the mouse to paste values, then you can use the tried-and-true keyboard sequence to paste values: Alt, H, V, S, V, Enter. Now, whenever you want to paste just the values, you can click on the new tool. The command is copied to the right side of the screen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |