Since the contents of your clipboard didn’t originate from Excel, this would normally produce an error. However, since we’ve bypassed the errors using the On Error Resume Next code, it tries the second method of pasting. No error is generated and you’re left with clean, unformatted, values pasted into Excel: This time, the second method, which pastes with unformatted text, works perfectly. The icing on the cake is when you bind the PasteValues macro to a keyboard shortcut so you can paste values into Excel using VBA with just a keystroke. Select “PasteValues” then click “Options.” I’ll show you how!įrom your Developer Tab, click the “Macros” button (Alt+F8). Your screen will look something like this: In the Macro Options screen, type a capital V. Press OK and close the Macros screen.Last week, I shared a couple of workarounds for pasting data into a filtered list.
#HOW TO PASTE VALUES SHORTCUT EXCEL 2003 HOW TO#
Today, see how to paste with shortcut in filtered Excel list. If you use a simple copy and paste, you could end up overwriting data in the hidden rows. You can use those workarounds, if you are pasting into the filtered list, with data from another location. However, if you are copying and pasting data from one column to another, within the filtered list, there is a better solution. Instead of using one of the workarounds for copying and pasting, you can use a keyboard shortcut. To copy data into the same rows in a filtered list: Thanks for the tip – it’s a new one for me, and a real time-saver! This tip was shared by Khushnood Viccaji, in a comment on my previous post.
#EXCEL KEYBOARD SHORTCUT FOR PASTE VALUES HOW TO#
#HOW TO PASTE VALUES SHORTCUT EXCEL 2003 FULL#
There are videos, screen shots and written instructions there, to help you get your Excel work done.Īnd for a full list of Excel keyboard short cuts, go to my interactive Shortcuts List. #EXCEL KEYBOARD SHORTCUT FOR PASTE VALUES FULL#