Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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 ... ;) – Rook Apr 3 '10 at 21:29
@Randolph - put it as an answer, and I'll accept it. – Rook Apr 3 '10 at 21:35

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. – Rook Apr 3 '10 at 23:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .