Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy filtered rows in excel
I am running Microsoft Excel 2002, the problem I am having is I have a whole
database of information with the top row being a fileter for each inidividual column, so that I can find specific information in that column when I filter som information so that my data is listed in the rows only with the relevant information the rows go from (ex. 121,134,156...) with the inbetween lines being invisible, the problem is that when I try to copy/cut a group of these filtered lines I can do it and than paste the information into my new sheet and only the copied/cut lines will appear but when i go back to the original sheet the invisble lines that i did not select are also missing. Does anyone know how I prevent this. Thanks for your help |
#2
|
|||
|
|||
Select the filtered range, press f5, click special and select visible cells
only, copy and paste Regards, Peo Sjoblom "BMX19" wrote: I am running Microsoft Excel 2002, the problem I am having is I have a whole database of information with the top row being a fileter for each inidividual column, so that I can find specific information in that column when I filter som information so that my data is listed in the rows only with the relevant information the rows go from (ex. 121,134,156...) with the inbetween lines being invisible, the problem is that when I try to copy/cut a group of these filtered lines I can do it and than paste the information into my new sheet and only the copied/cut lines will appear but when i go back to the original sheet the invisble lines that i did not select are also missing. Does anyone know how I prevent this. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |