» Use Sorting to Delete Blank Rows in Excel 2007
CATEGORY - Excel Sorting
VERSION - Microsoft Excel 2007
To delete blank rows between data:1. Select a cell in a List.
2. Select Home -> Sort & Filter (in Editing Group) -> Sort Smallest to Largest.
Before:

After:
Book Store:
Recommended Books:
- Investing in Real Estate, Fourth Edition
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- How to Pay Zero Taxes (Annual)
- Marketing Plans That Work, Targeting Growth and Profitability
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Marketing Plan: A Handbook with Marketing Plan
No comments have been submitted.

