Adding and Removing Rows

Rows are a central part to the structure of your Excel worksheets. Understanding how to quickly edit rows while you work in Excel will help your worksheet stay organized. Learn how to add and remove rows easily with the following articles.

Tips, Tricks, and Answers

The following articles are available for the 'Adding and Removing Rows' topic. Click the article''s title (shown in bold) to see the associated article.

   Deleting Every X Rows without a Macro
Grab some info from a source other than Excel, and you may find the need to delete a certain pattern of rows from a worksheet. The steps presented in this tip allows you to delete every other row, every third row, etc.

   Inserting Rows
Need to insert rows in your worksheet? Excel provides a few techniques you can use to do this. Here are some ideas you can put to work.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.