Excel Forum
Similar Content
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...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.