When we create data in Excel, sometimes there is a blank rows between the data that we created. With this below tips you can delete blank lines quickly.
For example we have data with blank rows data:
Follow the steps below:
1. Sort the range A2: B21 and press F5 on the keyboard, it will appear Go To dialog box, Then Click Special.. Button
2. In new Form Tickmark Blanks then click OK
3. Then, in Home Tab, Click Delete
Now you have data without Blank Rows
Easy right..:)
Related Topics:
How to configure Word, Excel 2007 options to save file into 97-2003 format?
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Easy tips to delete blank rows in Excel
Easy tips to create graphic in Excel
Microsoft Excel 2007: How to take limit value to the cell
No comments:
Post a Comment