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...

Print a Table in Excel 2007

To print a Table: 1. Select a cell in the Table range. 2. Click File -> Print -> and select Table option button in Print what section. ...

Remove Duplicate Rows in Excel 2007

To remove duplicate rows from a Table: 1. Select a cell in the Table range. 2. Select Design tab (in Table Tools Ribbon) -> Remove Duplicate (i...

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