 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / August 2008filter and save result
After filtering a list, how do I save only the filtered result "as it is shown" on the same worksheet and discard the rest? Please help...thanks. After filtered, select the range press F5 - Special - Visivable cells only, copy, and paste in a new sheet and save it. delete the old if you want hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > After filtering a list, how do I save only the filtered result "as it is > shown" on > the same worksheet and discard the rest? Please help...thanks. Thanks for the tip..I've just tried it...it works! But I am still wondering if there's a way to save the result on the same worksheet instead of copying and pasting on a new worksheet. If there is no such trick, I guess I will just use F5 key. Thanks. > After filtered, select the range press F5 - Special - Visivable cells only, > copy, and paste in a new sheet and save it. delete the old if you want [quoted text clipped - 4 lines] > > shown" on > > the same worksheet and discard the rest? Please help...thanks. Maybe you can filter on Custom>"Does not equal" Then do the F5>Special>Visible cells only and Edit>Delete>Row Gord Dibben MS Excel MVP >Thanks for the tip..I've just tried it...it works! But I am still wondering >if there's a way to save the result on the same worksheet instead of copying [quoted text clipped - 9 lines] >> > shown" on >> > the same worksheet and discard the rest? Please help...thanks. Thanks for the idea. This way I can keep my header and footer of the document....but this deletes the header "row" as well....but I can always copy and paste another header row...thanks. > Maybe you can filter on Custom>"Does not equal" > [quoted text clipped - 15 lines] > >> > shown" on > >> > the same worksheet and discard the rest? Please help...thanks. I am having difficulty telling when it will copy only the filtered and when it copies everything. I copied filtered data only selecting the entire sheet so how do I switch that to copy the entire sheet? Very user unfriendly. > Thanks for the idea. This way I can keep my header and footer of the > document....but this deletes the header "row" as well....but I can always [quoted text clipped - 19 lines] > > >> > shown" on > > >> > the same worksheet and discard the rest? Please help...thanks. to copy filtered results only try F5 > Special > Visible cells only > Copy > Paste to a new worksheet If you select entire worksheet after filtering, original data will be still there hidden... > I am having difficulty telling when it will copy only the filtered and when > it copies everything. I copied filtered data only selecting the entire sheet [quoted text clipped - 23 lines] > > > >> > shown" on > > > >> > the same worksheet and discard the rest? Please help...thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.