software

How do I change the default view (to quot;detailsquot;, ordered by date modified,
most recent date at the top) in Excel 2000?

Thank you!

Record a macro when you do data|filter|showall (to show the details).
Then continue recording when you sort your data the way you want.

Now name that macro
Sub Auto_Open()

It'll run each time you open the workbook (well, with macros enabled that is).

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

(Ps. Is that what you meant by details?)

hello wrote:
gt;
gt; How do I change the default view (to quot;detailsquot;, ordered by date modified,
gt; most recent date at the top) in Excel 2000?
gt;
gt; Thank you!

--

Dave Peterson