Does anyone know how to copy selected rows (not next to each other)to another spreadsheet?

[bobjfly]

I have a large spreadsheet that I have gone through and selected various rows that I want to put into another spreadsheet, but when I right click and click the copy command, I get a message "That Command Cannot Be Used on Multiple Selections."

[JBeaucaire]

You CAN select multiple ROWS in various places around your sheet, because that forms equally sized ranges that Excel can gather together. You cannot select random cells in random places creating non-exactly placed ranges, that will get you that message every time.

[bobjfly]

That is exactly what I did, selected rowns not cells, but still got the message.

[Yathish.d]

As mentioned by JBeaucaire, see that the rows are identically sized. To select the rows, click on the row number, this would select the entire row.

[royUK]

Did you select entire rows?

[bobjfly]

I did select entire rows and the rows are identically sized.

[Yathish.d]

If you are still not able to copy the selected rows, please attach the file and name a few rows which you are trying to copy. Let us try it out and may be we could help you.

[royUK]

It should work if entire rows are selected

[JBeaucaire]

I use JING to grab screenshots and record videos of what I'm doing to help demonstrate problems I'm having. The pics/vids are posted automatically to screencast.com and a link goes into your computer memory where you can immediately post into forum post for others to see what you're seeing.

http://screencast.com/t/hlfDM5U9