View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default How do I create a List in Excel 2000

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
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.