How To Delete Blank Rows In Excel Quickly And Easily

Asked By Kumay Edwards 5 points N/A Posted on - 05/09/2017

I want to delete the blank rows in Excel sheet since I am using it for the first time and don’t know many how to operate kindly help me out.

• Status: Open
• Question Views: 614
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: blank rows | Excel

Answered By emil flores 20 points N/A #296418

How To Delete Blank Rows In Excel Quickly And Easily

There are ways to delete blank rows in Excel, press f5 which is there in the top center of the keyboard. The dialogue box will appear and go to special and choose how your rows and columns should be aligned, go to blanks for deleting. If the dialogue box does not appear, go to the find and edit option under home button and then table layout, try to edit there.

About emil flores

Questions
10

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/09/2017
• Question Category: MS Excel