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
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
文章標籤
全站熱搜
