17 Amazing Features of Excel Tables

Well, most of the time, any arrangement data is referred as a table in excel but they are not. You need to format your data as table on excel to get t...

Total the Table in Excel 2007

To total Table last column: 1. Select a cell in the Table range. 2. Select Design tab (in Table Tools Ribbon) -> Totals Rows (in Table Style Op...

Applying Colors to Top/Bottom Values in a List in Excel 2007

To color the top/bottom values in the entire List: 1. Select a cell in the List and press Ctrl+Shift+* or press Ctrl+A to select the List. 2. Sele...

Coloring Based on Text Criteria in Excel 2007

To color based on text criteria: 1. Copy a column containing a list of items such as Customer Name, see column C, and paste it to a new column. 2....

Drawing Lines between Sorted Groups in Excel 2007

To draw lines between sorted groups of data: 1. Sort the List by Customer Name by selecting a cell in column C (see screenshot) and clicking Sort ...

Apply Formatting to List/Table in Excel 2007

To apply formatting to List/Table: Select Home -> Format a Table palette (in Styles Group). ...

Table Sorting Rules in Excel 2007

To sort a Table, the Table structure: The Table should have only one header row. Do not leave any blank cells in the header row. Sorting one ro...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube