O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required