Error in copying the Data

aatish

New Member
Joined
Aug 7, 2009
Messages
1
hi
This is Aatish

I am facing a problem in MR Excel 2007 in copying a huge data from a sheet. details are as below:

i have a data of size Nx2845 in a single sheet of a workbook. i applied some filter on the header and tried to copy the filtered data into a new sheet and got this error
The command you chosed can not be performed with multiple selections. Please select a single range and click the command again
For details, please see attached picture

excelprob.jpg

moz-screenshot.png

what to do to cut the data?
what does it(single range and multiple selections) means??

Please help....

Thanks for your considerations

Regards
Aatish
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,215,734
Messages
6,126,543
Members
449,316
Latest member
sravya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top