XL2000: Add To List Button Is Dimmed in the Find Dialog Box (212005)
The information in this article applies to:
This article was previously published under Q212005 SYMPTOMS
The Add to List button in the Find dialog box appears dimmed when you use a numeric, date, or time property, and specify a condition between two values, dates, or times.
WORKAROUND
When you specify a criteria that falls between two values, use the word "and" to separate the two values, dates, or times.
For example, to find all files created between August 1, 1999 and August 15, 1999, follow these steps:
- In Microsoft Excel 2000, click Open on the File menu.
- Navigate to a folder that has several .xls files.
- Click Tools, and then click Find.
- Click Creation date in the Property list.
- Click anytime between in the Condition list.
- Type 8/1/99 in the Value box.
Notice that the Add to List button still appears dimmed.
- Modify the text in the Value box to read 8/1/99 and 8/15/99.
The Add to List button is now available.
MORE INFORMATION
The Find search tool in Microsoft Excel 2000 allows you to create more complex searches. You can use it to find files based on advanced criteria such as the date a file was created or last printed, its size in bytes, number of pages, number of characters within a file name, author name, strings of text within a file, and so forth.
REFERENCESFor more information about finding files, click Microsoft Excel Help on the Help menu, type use file properties to locate files in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Modification Type: | Major | Last Reviewed: | 11/5/2003 |
|---|
| Keywords: | kbprb KB212005 |
|---|
|