Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2003, the autofilter sorting function would sort the columns of the
whole sheet, even when the autofilter area only included i.e. the columns A to F. When doing the same in version 2007, only the columns included in the actual autofilter range, is sorted... Example: A B C 1 x1 y3 z1 2 x2 y2 z2 3 x3 y3 z3 When having autofilter on only column A and sorting it descending you get the following result in 2007: A B C 1 x3 y1 z1 2 x2 y2 z2 3 x1 y3 z3 Whereas 2003 will give this result: A B C 1 x3 y3 z3 2 x2 y2 z2 3 x1 y1 z1 Which is more correct... Is this a new "feature" or a bug? /David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 trial version does not open except in Safe Mode | Setting up and Configuration of Excel | |||
Autofilter 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Version | Excel Discussion (Misc queries) | |||
Excel 2007 - Autofilter different behaviour | Excel Discussion (Misc queries) | |||
Is there a version of MSN Money Stock Quotes for Office 2007 | Excel Worksheet Functions |