Monday, 24 August 2015

Shortcut key to Delete Multiple Blank Rows/Columns in MS Excel

Shortcut key to Delete Multiple Blank Rows/Columns in MS Excel,Delete all blank rows,excel 2007,2003,2010,2013,2016,Keyboard Shortcut,shortcut key to delete blank rows,remove all blanks rows & columsn,how to delete multiple blank rows,same time delete all blanks rows,Delete/remove Multiple Blank Rows/Columns in MS Excel,multiple blank remove,delete all blank rows in sheet,how to do,how to delete,how to remove,blank rows            In this post you will learn how to delete/remove multiple blanks rows by using easy simple method, if you try to delete blank rows one by one it will take lot of time and concentrate, but here I will show you easiest way to delete multiply blank rows at one same time.  This method will work all the version of Microsoft Excel like 2003, 2007, 2010, 2013 & 2016.  Lets see how to do this.
1.     Select your matter including blanks rows and press “F5” than click on “Special” you will get one box, select “Blanks” and “Ok”
Shortcut key to Delete Multiple Blank Rows/Columns in MS Excel,Delete all blank rows,excel 2007,2003,2010,2013,2016,Keyboard Shortcut,shortcut key to delete blank rows,remove all blanks rows & columsn,how to delete multiple blank rows,same time delete all blanks rows,Delete/remove Multiple Blank Rows/Columns in MS Excel,multiple blank remove,delete all blank rows in sheet,how to do,how to delete,how to remove,blank rows
2.        Now you can see all your blank rows will selected, just hold “Ctrl” and press “-“ (Ctrl -), check on “Entire Row” and hit on “Ok”           
Shortcut key to Delete Multiple Blank Rows/Columns in MS Excel,Delete all blank rows,excel 2007,2003,2010,2013,2016,Keyboard Shortcut,shortcut key to delete blank rows,remove all blanks rows & columsn,how to delete multiple blank rows,same time delete all blanks rows,Delete/remove Multiple Blank Rows/Columns in MS Excel,multiple blank remove,delete all blank rows in sheet,how to do,how to delete,how to remove,blank rows



Watch video tutorial… Please like, share & subscribe 

No comments:

Popular Posts