Delete Blank Rows in Microsoft Excel 2007/2010?

By Moe Jame Share
Browse the Microsoft Excel 2007/2010 category for more tutorials

How to delete black rows from an Excel worksheet

  • Select a column from the top of the entries right to the bottom of the entries

 

 

 

  • Hit F5 and click Specials when the GoTo box appears

 

 

 

 

 

  • Right click and select Delete

 

 

  • Select Shift Cells Up and click OK

 

Keywords

Blank RowsDelete

More Microsoft Excel 2007/2010 Tutorials

How to Delete Blank Rows on Microsoft Excel 2007/2010

How to Keep Column Headings Visible When Scrolling on Microsoft Excel 2007/2010

How to Copy Column Width To A New Worksheet on Microsoft Excel 2007/2010

How to Print Title On Each Page Of A Document on Microsoft Excel 2007/2010

How to Copy Formatting To Multiple Cells on Microsoft Excel 2007/2010

How to Use Fractions on Microsoft Excel 2007/2010

How to Use IF Function on Microsoft Excel 2007/2010

How to Print Same Cell Range From More Than One Worksheet on Microsoft Excel 2007/2010

How to Specify Allowed Data on Microsoft Excel 2007/2010

How to Customize Error Message on Microsoft Excel 2007/2010

Follow us on Twitter Subscribe to our Feeds Become a Fan on Facebook

Follow Us

RSS
facebook
twitter

Didn't find your answer?

Post your question on our forum and ask the community!

Ask a question!