Use Excel 2007/2010’s Table Feature to Help You Quickly Calculate, Format, and Sort Data
Have you ever needed to make an Excel spreadsheet look good in a hurry? Well, Excel’s table feature (introduced in the 2007 version) can help you get that data computed, sorted, and formatted in just five easy steps.
Here’s how the data initially looked on the left. Notice, the data has not been organized on any fields, and the format is very bland. Look at the difference once the table feature has been applied! (Click on the image to enlarge)
To give your spreadsheet data a more professional appearance, simply:
- Select the data range and then click the Insert tab. ***IMPORTANT***Be sure there are no blank rows between your column headings (fields) and your actual data.
- Click the Table icon from the Table Group to determine your range and then click OK
- Select from one of the other 60 pre-designed table styles, if you don’t want to use the default table style.
- Click the Total check mark in the Table Styles Options Group and then scroll to the last row in the table and click the drop-down arrow to the right of the column(s) you want summarized (Count, Sum, Average, Min, etc.). In our example, we will include a total (SUM) for 1st Quarter Sales and take a count (COUNT) of the sales reps by last name.
- Sort the data on specific fields. In our example, we will sort the data by last name (LName field) by clicking on the arrow for that field and select the Sort A to Z option.
For more information, contact Becky Jones, Associate Dean, firstname.lastname@example.org, 972-238-6215