Paste Values Keyboard Shortcut (Excel Tip)

Untitled Document

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.

Excel paste options icon

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.

Excel paste special 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.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>