Microsoft KB Archive/47264

{| = Excel: Vertical Criteria Not Available =
 * width="100%"|

Last reviewed: November 29, 1994

Article ID: Q47264

SUMMARY
The criteria range in a Microsoft Excel worksheet must be aligned horizontally across the page. The first row should contain the field name(s) from the database, and the second row should contain the data that is being set as criteria for selecting records from the database.

For example, if cell A1 contains the field name &quot;Name&quot;, cell A2 should contain the actual name that is being used for the criteria.