Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Sorting Issue
I have a large spread sheet and frequently use the auto filter capabilities.
My rows are getting out of sequence (the data is not staying in the correct row). I've marked cells and then tested by sorting different columns ascending, desending, etc. and I've done this on multiple columns. I can not get the data to return to the original format even when I turn the filters off. I have in excess of 100 hours invested in this data. Needless to say it's a very important document! Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Sorting Issue
If you want to get back to original order of the rows, then you can
put a simple sequence 1, 2, 3, 4 etc down a column before you start changing anything in your sheet. Then you will always be able to sort back to this sequence. Remember to include this column in the sort range whenever you sort. Hope this helps. Pete On Feb 12, 3:59*pm, Ryan@Wpl wrote: I have a large spread sheet and frequently use the auto filter capabilities. * My rows are getting out of sequence (the data is not staying in the correct row). *I've marked cells and then tested by sorting different columns ascending, desending, etc. and I've done this on multiple columns. *I can not get the data to return to the original format even when I turn the filters off. *I have in excess of 100 hours invested in this data. *Needless to say it's a very important document! *Any help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Using Grouping and Sorting and Auto Filter | Excel Discussion (Misc queries) | |||
Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |