ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort order in 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/147428-sort-order-2007-a.html)

Sam Cox

Sort order in 2007
 
In Excel 2007 the file open directory sorts in horizontal order instead of
vertical order as it did on previous versions. Can this be changed?

robert morris

Sort order in 2007
 
Try this ---

On the HOME Ribbon
Click on Sort & Filter
Click on Custom Sort

The Sort Critera Box opens -- at the top Click on Options
The small sort Options Box opens
the box marked Sort Top To Bottom should be checked, if not, check it.

If that does'n fix it, then I'm lost

Bob M.


"Sam Cox" wrote:

In Excel 2007 the file open directory sorts in horizontal order instead of
vertical order as it did on previous versions. Can this be changed?



All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com