» Drawing Lines Between Sorted Groups
CATEGORY - Excel Sorting
VERSION - 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.
Book Store:
Recommended Books:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Excel Charts
- Windows XP All-in-One Desk Reference For Dummies
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
