How to copy only values in Excel?

How can I find multiple values in an Excel sheet and copy/paste the rows that these values are in?

  • In Excel, I have a sheet that has 13,xxx rows and values in one column (sheet A). I also have another Excel sheet in which I have 22,xxx rows and several columns of data (sheet B). ...show more

  • Answer:

    Yes, press and hold down the control button with your left hand, then use the mouse to highlight each cell/row/column you want by clicking it, when you have highlighted all you want, right click and copy, then paste them into another sheet!

NTF5NWWOA3NOX7RYPY3W3BWXHY at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.