How do I create a List in Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i use the create a list feature in Excel 2000 1
Function in Excel to count and list number of entries of text valuesin a row. 2
Excel 2003-Data Validation drop down list not working? 2
Excel How to enable engineering functions in MS Excel 2000? 3
How to create a bubble chart with more than 2 variables 0
How do I create a list in excel 2007? 3
Does Xcel 2000 have a list function like that in 2003 1
Counting multiple memberships 1

Back
Top