Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
1  
Alt+E, S, V pastes just values. Is that what you're looking for? –  user3463 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

3 Answers 3

It is Alt+H, V, V

share|improve this answer

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."
share|improve this answer

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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