|
» Drawing Lines Between Sorted Groups
CATEGORY: Excel Sorting |
VERSIONS: All Microsoft Excel Versions |
|
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 the Sort icon. 2. Select cell A1 in the Current Region and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A). 3. From the Format menu, select Conditional Formatting. 4. In Condition 1, select Formula Is. 5. In the Formula box, enter the formula =$C1$C2. Be sure to enter the formula with absolute reference for the column and relative reference for the row. 6. In the Conditional Formatting dialog box, click the Format button, select the Border tab, in Border section click Underline and then choose a color. 7. Click OK twice. |
| Screenshot // Drawing Lines Between Sorted Groups |
  |
|
RATING:
3.44
VIEWS: 38783 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- PowerPoint® 2002 For Dummies®
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Microsoft Word Version 2002 Inside Out
- How to Use Financial Statements: A Guide to Understanding the Numbers
Related MS EXCEL TIPS:
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.
