How do I create a List in Excel 2000

[Watch Online]

In Excel 2003, I can create an Excel list by selecting the command "List"
under the "Data" menu. I do not find the same selection in Excel 2000. How
can I create a list using Excel 2000 as I use Excel 2000 at home.
When I open the list I created in Excel 2003 at work in Excel 2000, all the
list features disappear, all I can see a simple straightforward spreadsheet.
I wish I know how to create the list in Excel 2000 so that I can do
filtering, etc...
Thanks for your help.

[Gord Dibben]

Excel's "List" feature was added in 2003 and is not available with earlier
versions.

You will have to select the columns/rows/ranges and do your filtering/sorting on
that selection.

Perhaps a named range would work for you.


Gord Dibben MS Excel MVP

On Tue, 31 Jan 2006 08:51:32 -0800, Watch Online
<[email protected]> wrote:

>In Excel 2003, I can create an Excel list by selecting the command "List"
>under the "Data" menu. I do not find the same selection in Excel 2000. How
>can I create a list using Excel 2000 as I use Excel 2000 at home.
>When I open the list I created in Excel 2003 at work in Excel 2000, all the
>list features disappear, all I can see a simple straightforward spreadsheet.
>I wish I know how to create the list in Excel 2000 so that I can do
>filtering, etc...
>Thanks for your help.