Tips for Setting Up a Table in Excel

There are a few things to consider before creating your Table:

• Columns are the foundation of an Excel Table. Table rows are easy to add and remove, but adding or removing Table columns disrupts a Table's basic structure. To save time and frustration, determine exactly what columns are necessary before creating your Table.
• Do not leave blank rows in the middle of your Table. Blank rows will interfere with Table analysis functions.
• Enter numeric data either as numbers or as text; do not combine the two.
  HINTS:
  When using analysis functions, numbers are counted before text.
  When using mathematical formulas (e.g., SUM and AVERAGE), numbers cannot be entered as text.
  For more information on entering numbers and text, refer to Getting Started with Excel.

Related Posts by Categories