Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSExcel 2007 Filters do not allow Copy and Paste of data
In MSExcel 2003, I could apply a filter, highlight the data that was selected
and paste it to another worksheet. When I attempt to do this in MSExcel 2007, the data that is pasted includes all the data from the worksheet from which it was selected (i.e. it unpacks the filter when you paste it and all the lines are shown). Is there a patch that needs to be installed to correct this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSExcel 2007 Filters do not allow Copy and Paste of data
Try this
Select the whole data range or if you not have empty rows/columns in the range you can use Ctrl * to select all data or use F5SpecialCurrent regionOK with one cell selected in the data range. If it copy all the data (there are a few reports of 2007 users) use also the shortcut Alt ; or F5SpecialVisible cells onlyOK to select only the Visible cells. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Avril V" <Avril wrote in message ... In MSExcel 2003, I could apply a filter, highlight the data that was selected and paste it to another worksheet. When I attempt to do this in MSExcel 2007, the data that is pasted includes all the data from the worksheet from which it was selected (i.e. it unpacks the filter when you paste it and all the lines are shown). Is there a patch that needs to be installed to correct this problem? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MSExcel 2007 Filters do not allow Copy and Paste of data
Hi,
Once the information is filtered press CTRL G, special, visible cells only, then CTRL C and then go to where you want to copy the information and press CTRL V If this helps please click yes, thanks "Avril V" wrote: In MSExcel 2003, I could apply a filter, highlight the data that was selected and paste it to another worksheet. When I attempt to do this in MSExcel 2007, the data that is pasted includes all the data from the worksheet from which it was selected (i.e. it unpacks the filter when you paste it and all the lines are shown). Is there a patch that needs to be installed to correct this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste 2007 | Excel Discussion (Misc queries) | |||
Copy/paste with filters from one sheet to another? | Excel Discussion (Misc queries) | |||
Data filters in Excel 2007 not working for one file | Excel Worksheet Functions | |||
MSExcel 2007 | New Users to Excel | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |