up vote 1 down vote favorite
1
share [g+] share [fb]

Is there a shortcut in Excel 2007 (or a simple way to define one) to paste all copied values, but without formatting ?

I'm entering some data in tables, and it would really save my life, that one.

link|improve this question
63% accept rate
1  
Alt+E, S, V pastes just values. Is that what you're looking for? – Randolph West Apr 3 '10 at 21:12
@Randolph . thanks. That will do for now. (Still not comfortable with this new Excel ... ;) – ldigas Apr 3 '10 at 21:29
@Randolph - put it as an answer, and I'll accept it. – ldigas Apr 3 '10 at 21:35
feedback

3 Answers

up vote 1 down vote

It is Alt+H, V, V

link|improve this answer
feedback
up vote 1 down vote

Add the "Paste Values" button to your Quick Access toolbar.

  1. Right-click any tab on the menu bar, and then go to "Customize Quick Access Toolbar."
  2. Pick "Customize" from the Categories on the left. Under "Choose Commands from," pick "Home Tab."
  3. Pick "Paste Values" from the long list. Click the "Add" button, then click "Ok."
link|improve this answer
feedback
up vote 0 down vote

Since you're going from Excel to Excel, a trick is to run two copies of Excel. Start the first one normally, but then run Excel again, and then open the second file. Copy and paste then goes between the two Excels as if it was text.

link|improve this answer
No, I'm not copying from one sheet to another. I'm entering some gigantic tables, which have a lot of same values, so while entering the data, I copy it so I don't have to type it. That's what I ment under "excel to excel" ... although, yes, I could've made it more clear. – ldigas Apr 3 '10 at 23:43
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.