ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   modify how files are displyed in the "file open" window (https://www.excelbanter.com/excel-discussion-misc-queries/177570-modify-how-files-displyed-file-open-window.html)

Brett

modify how files are displyed in the "file open" window
 
when i push the file open button, i want to show the most currently used
folders first and after all the folders are listed, list the most recently
used file next

i tried to arrange by date and it lists them all backwards

please email me when you have responded



Gord Dibben

modify how files are displyed in the "file open" window
 
Brett

Folders are shown in alphabetical order, not by date created or used.

You can arrange files by date from new to old, but the folders will drop to the
bottom of the list.

I don't think you can configure the way you want.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 11:11:02 -0800, Brett
wrote:

when i push the file open button, i want to show the most currently used
folders first and after all the folders are listed, list the most recently
used file next

i tried to arrange by date and it lists them all backwards

please email me when you have responded




RagDyeR

modify how files are displyed in the "file open" window
 

I believe the default view is "List".

If you click the Views icon, then click on "Details", you'll get a Header
row, where you can then determine how the files and folders will be
displayed by clicking in the headers to pick ascending or descending, by
dates, or names, or size, ...etc.

This should work for all versions.
Different versions work more easily.

My XL2K machine gives these options without having to go to the "Details"
view.

Just click the small down arrow next to the View icon.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Brett" wrote in message
...
when i push the file open button, i want to show the most currently used
folders first and after all the folders are listed, list the most recently
used file next

i tried to arrange by date and it lists them all backwards

please email me when you have responded





Gord Dibben

modify how files are displyed in the "file open" window
 
But, Brett wants them sorted by date new to old and still wants the folders at
top.

Cannot be done IMO.


Gord

On Fri, 22 Feb 2008 16:31:51 -0800, "RagDyer" wrote:


I believe the default view is "List".

If you click the Views icon, then click on "Details", you'll get a Header
row, where you can then determine how the files and folders will be
displayed by clicking in the headers to pick ascending or descending, by
dates, or names, or size, ...etc.

This should work for all versions.
Different versions work more easily.

My XL2K machine gives these options without having to go to the "Details"
view.

Just click the small down arrow next to the View icon.




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

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