There are really only a few hard and fast rules to remember when it comes to proper table or list creation. Just commit these rules to memory and your lists will be doing back flips for you! Okay, maybe not actual gymnastics, but you will be AMAZED at the list management capabilities built into Excel that help you manage both large and small amounts of data with ease.

 
• Your Table/List Needs a Header Row
   
 
• Your Header Row Should be Formatted Differently
   
 
• Your Table/List Should Contain NO Blank Rows
   
 
• Your Table/List Should Contain NO Blank Columns
   
 
• Your Table/List Should Contain NO Merged Cells
   

That’s it! Honestly. If you just set up your list with a bold header row, no merged cells and continuous data, Excel can do the rest.