Look Who it Was Random video

How to delete blank rows in Excel

3,455 views · Published 3 July 2015 · 7:04 · Indexed 11 October 2026

Channel: Krishna S · 2015 · Science & Technology

Watch on YouTube

How to delete all the blank rows in Excel

steps

1. Filter the data with only blank rows visible
2. Select the rows visible 
3. Right click and Say "delete rows


How to select and copy only filtered rows
1. Apply filter to non blank rows
2. Select the filtered rows
3. press Alt+; which will only select visible rows
4. Copy and paste some where else 


http://krishnasr.blogspot.in/2013/11/excel-vba-macro-to-swap-2-values-in.html

Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishnasr.blogspot.in/
Google Plus: https://plus.google.com/+KrishSanj/

More from this channel