How to Easily Delete Blank Rows and Columns in MS Excel 2013
Posted by
KrishKT
–
KrishKT
–
Highlight the area of your spreadsheet in which you want to delete the blank rows/colums. Be sure to include the row just above the first blank row and the row just below the last blank row.
>> Navigate to Home --> Editing --> Find & Select --> Go To Special… --> Blanks
>> All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected.
>> Now navigate to Home --> Cells --> Delete and then select “Delete Sheet Rows/Delete Sheet Columns”
All the blank rows/columns will be removed!
>> Navigate to Home --> Editing --> Find & Select --> Go To Special… --> Blanks
>> All the cells in the selection that are not blank are de-selected, leaving only the blank cells selected.
>> Now navigate to Home --> Cells --> Delete and then select “Delete Sheet Rows/Delete Sheet Columns”
All the blank rows/columns will be removed!
ref.
| Free forum by Nabble | Edit this page |