How to Add Paragraph Breaks in Cells in Excel for OS X. Because Excel's primary purpose is to display, organize and calculate numerical data such as your business' profits or expenses, ...

Launch Excel and load the worksheet you want to work with. Click or tap the "Home" tab. Click or tap any cell within the row you want to insert a blank row above.

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.