In this article we are going to learn how to remove blank rows in Excel?
To delete empty rows, we can use ‘Sort’ option and ‘Go To Special’ option in Microsoft Excel 2010.
Sort:-This option is available in the Data Tab under the Sort & Filter group.
Go To Special: - This option is used for quickly directing to different cells in Excel.
Shortcut: F5 and Ctrl+G
Command button: Home>Find & Select >Go to Special
Let’s take an example to understand how we can delete empty rows.
We have data in range C1:C18 where column A contains name in which some cells are blank. Now, we want to delete the blank cells.
To delete the blank rows we use ‘Go to Special’, follow below given steps:-
Let’s take another example to understand how we can delete data through sorting.
We have data in range A1:B14 where column A contains Agent’s name and column B contains Revenue ($).
To delete the blank rows, we sort the data.
These are the ways we can delete the empty rows in Microsoft Excel.
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.