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

Excel Notes

• How to create a template in excel 2007?
• Table Terms in Excel
• Sorting Data in Excel (Sort Button and Sort Dialog Box)
• Separating Text in Excel (Separating the Data)
• Separating Text in Excel (Considerations)
• Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)
• Hiding Columns, Rows, and Cells in Excel (Hiding Rows)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)
• Hiding Columns, Rows, and Cells in Excel (Hiding Columns)
• Find and Replace Features in Excel (Using the Replace Feature)
• Find and Replace Features in Excel (Using the Find Feature)
• Paste Special Feature in Excel (Paste Special Options)
• Paste Special Feature in Excel (Using the Paste Special Dialog Box)
• Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill)
• Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments)
• Importing an External Data File in Excel
• Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns)
• Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data )
• Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function)
• Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste )
• Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules )
• Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting )
• Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )