How Do You Use Excel As A Database?
Many people use Excel as a database. Excel can be a convenient way to store information as a database as long as the information is not too cumbersome to be contained in a spreadsheet format. Because Microsoft Office comes with Excel, using Excel as a database is less expensive than purchasing additional software to house a database. Identify the data you want to include in the database. Before you can set up a spreadsheet as a database, you need to know what information you will be tracking. Use Row 1 as headings for each item that you plan to track. For example, if you plan to use Excel as a database for contact information, you would include name, address, phone number and other headings across Row 1. Format Row 1. Change the formatting of Row 1 to separate the headings from the data in your database. To do this, click the number one next to Row 1, which highlights the entire row. Add your formatting, such as bold, center and a gray background. Freeze the heading row. Use the freeze
