Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Q&A

Q1:	My field names take up two rows in my database. Why couldn't I successfully search for data?
A1:	The field names must be placed in the first row of the database. Also, they should be placed in one row only. These field names must contain text. You cannot use values as field names.
Q2:	I used spaces to align my data in the fields. Why doesn't Excel find any records I search for?
A2:	You can't use spaces or extra spaces within a field entry. Also, don't align your data left, right, or center. Use the alignment default Excel uses for text (left) and numbers (right). Otherwise, if you align numbers center or left and use comparison operators in your search, Excel doesn't recognize the numbers and treats them as text.
Q3:	After I filtered a database ...