| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a List in Excel 2000
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How do I create a mailing list with current data in Excel? | Excel Discussion (Misc queries) | |||
| How can Excel create a list of tabs on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
| How do I create a drop down list in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
