A pop-up box will appear. Select Blanks, and then hit OK. ... Once all the blank rows are highlighted, go to the Home tab and locate the Delete button on the right-hand side.

Step 2: In the pop-up box, check the measurement for the Bottom margin. Normally, this is set to 1 inch by default. Step 3: You can change the Bottom measurement to a smaller number and pick OK .