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.

4] Delete multiple Rows by running a Macro. For those who have tasks in Microsoft Excel that they need to do repeatedly, it can be easily be automated by recording a macro.

1] Delete Excel Pivot Tables and keep the data In some situations, the user wants to delete the Pivot Table but at the same time, retain the data. This might seem complicated, but believe us, it ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without ...

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.

How to Delete Blank Pages in Excel. When you set up a Microsoft Excel workbook to build an employee roster, calculate profit margins or track sales by region, the application creates a document ...