My excel folders get quite large. I try and find my files by changing my
file format to details and then sort by date to locate my most recent files.
How can I change the way windows stores my files so that they always open in
detail and the most recent file is sorted to the top of the list? Sorry if
this is not an excel function question, I just find you guys always have
great guick answers.
--
inthestands
quot;inthestandsquot; wrote:
gt; My excel folders get quite large. I try and find my files by changing my
gt; file format to details and then sort by date to locate my most recent files.
gt; How can I change the way windows stores my files so that they always open in
gt; detail and the most recent file is sorted to the top of the list?
Try this in Explorer
Click on a folder in the left pane
Click View gt; Details, then click to sort quot;Date Modifiedquot; descending
Then click Tools gt; Folder Options gt; View tab gt; Apply to all folders gt; Yes
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---You might also want to check out Daniel Klann's
Favourites Add-in for Microsoft Excel at his:
www.danielklann.com/excel/exc...tes_add-in.htm
In his words:
quot;.. This is a simple add-in I wrote that allows you to access frequently
used files and folders from within Excel, much like the 'Favorites' feature
in Internet Explorer or 'Bookmarks' in Netscape Navigator. The add-in allows
you to open your favourite files, or display the file open dialog at a
particular folder.... quot;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Thanks, the add-ins are great, and the instructions to modify the file were
great. Thanks again
--
inthestandsquot;Maxquot; wrote:
gt; You might also want to check out Daniel Klann's
gt; Favourites Add-in for Microsoft Excel at his:
gt;
gt; www.danielklann.com/excel/exc...tes_add-in.htm
gt;
gt; In his words:
gt; quot;.. This is a simple add-in I wrote that allows you to access frequently
gt; used files and folders from within Excel, much like the 'Favorites' feature
gt; in Internet Explorer or 'Bookmarks' in Netscape Navigator. The add-in allows
gt; you to open your favourite files, or display the file open dialog at a
gt; particular folder.... quot;
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
Glad you liked it !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;inthestandsquot; wrote:
gt; Thanks, the add-ins are great, and the instructions to modify the file were
gt; great. Thanks again
gt; --
gt; inthestands
- Dec 18 Thu 2008 20:48
change display format for excel folders and files
close
全站熱搜
留言列表
發表留言
留言列表

