If you do any work in Excel, you find yourself copying and pasting values often.
Here’s a quick tip on using keyboard shortcuts to paste values.
Step 1 – Copy the cells by using the CTRL C combination.
Step 2 – Paste the cells by using the CTRL V combination.
You will notice the paste options icon shows up at the bottom right hand corner of the cells you just pasted.
Step 3 – Paste Values
Before clicking any other keys, tap the CTRL key again. This opens your paste options box, to show the options shown below. Hit V again, which changes what you’ve just pasted into Values.
It is that simple!
Do you have an Excel question?
Comment below and it just might make it to a blog post!
About the Author
Jackie Kiadii and her team of subject matter expert (SME) trainers provide Microsoft software training that delivers measurable results – increasing productivity, reducing inefficiency, and improving the bottom line. Topics include: Project, Access, Excel, Excel VBA, PowerPoint, Word, Outlook and Publisher. Upcoming Excel courses are on our calendar, click here.
Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.
Click to Grab Your Excel Ebook – Free!
