Excel - sort order of viewing files

BleepingComputer.com: Excel - sort order of viewing files

Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

Excel - sort order of viewing files Order of files in a directory when opening

#1 smitch

Member

Group: Members
Posts: 22
Joined: 23-September 04

Posted 10 October 2005 - 04:27 AM

There should be a simple answer to this - but can't seem to find it anywhere.

When I go to open an Excel file (File>Open>My Documents) the order of the directories (and then the files within a selected directory) is in the order they were last opened (I view them as a list). How can I get the directories and files to display in alphabetical order? :thumbsup:

#2 tos226

BleepIN--BleepOUT

Group: Members
Posts: 1,412
Joined: 21-October 04
Gender:Female
Location:LocalHost

Posted 10 October 2005 - 10:20 PM

smitch, on Oct 10 2005, 05:27 AM, said:

There should be a simple answer to this - but can't seem to find it anywhere.

There is. First select details, not icons. Now click on any column you want to sort by - filenames, or dates or type. Same as in standard Windows explorer.

#3 smitch

Member

Group: Members
Posts: 22
Joined: 23-September 04

Posted 11 October 2005 - 03:46 AM

So Easy - Thanks! :thumbsup:

BleepingComputer.com: Excel - sort order of viewing files