Apr 09 2020 05:19 PM
I have spreadsheet A8 to Z103
I have randomly selected 32.
How can I copy these 32 rows with columns to new location
Apr 09 2020 05:59 PM
Hello,
once you have selected the 32 columns you need, press CRTL + C to copy and CTRL + V to paste in desired located or sheet.
Does that answers your question?
Apr 09 2020 06:11 PM
Apr 09 2020 08:43 PM
Hi @eiregobra
Are the rows aligned together? I imagine not, due to the random selection. If together, it should be easy to select them and use copy and paste as previously selected.
If you are able to hide the other rows that you are not trying to copy, you could then select the rows and use Go to > Special... Visible Cells only (right side of menu). You can get to this by hitting the CTRL button and G at the same time (CTRL+G).
Once you do that it will not select the hidden rows.
Now you can choose to copy (CTRL+C) these particular rows/cells onto your clipboard.
Then go to the new workbook/worksheet and paste the data.
Apr 09 2020 08:45 PM