2] Delete multiple rows in Excel using Shortcut. Here we will use one of the most used shortcut keys i.e. ‘CTRL+ Minus (-) ‘. Let us understand how to use it: Select multiple rows in a single ...

How to Remove Extra Unused Cells in Microsoft Excel 2013. ... One advantage of spreadsheet programs such as Microsoft Excel is that you can place data essentially wherever you wish on a ...

Excel will then delete the blank cells from the selected data range. The blank cells in rows 7 and 10 are gone. (Screenshot: TechRepublic) SEE: Learn how to parse time values in Microsoft Excel.

Note: When you delete cells in Excel, the data below it will be moved up. 6. Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.