Excel Forum
Similar Content
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...



Excel Magic Trick #184: Setup Database in Excel


See how to create a simple database in Excel using the List or Table feature.
A simple database can be created in Excel using the Excel 2003 "List" feature or the Excel 2007 "Table" feature.
Fields names must be in first row (no blanks).
Records are in rows (no blanks).
Other data in the sheet cannot be next to the Table/List (at least one blank row or column between other data and the Table/List
Keyboard shortcuts: Excel 2003 List: Ctrl + L. Excel 2007 Table: Ctrl + T.
The ranges are dynamic: formulas, pivot tables, charts will all automatically update





Got a Question? Ask it Here in the Forum.