Latest posts by techwriter (see all)
- Test Your Knowledge of 4 Basic Fonts – Drag & Drop - January 27, 2017
- How NOT to Design a Web Site - January 25, 2017
- Hazards of Poorly Written Technical Documentation - December 26, 2016
© 2009 Ugur Akinci
If you’d like to create a searchable address database in MS Excel, the best way to do it is to assign a separate column to every data component with which you’d like to sort or search your database.
For example, here is a good example of how to do it:
In this example, you can sort the records by State or you can quickly find the number of people living in a certain ZIP code, etc.
Here is a bad way to do it:
Because it is impossible with an Excel sheet like this to search by City, State, ZIP, First Name, or Last Name.
NOTE: To stretch the column widths to fit the content, 1) select all records by clicking on the top-left cell, and then 2) select Format > Column > Autofit Selection from the menu.