Banjo For Dummies
Book image
Explore Book Buy On Amazon
Excel 2013 makes it easy to insert and delete rows and columns to deal with many kinds of changes. Even if you’re a careful planner, you’ll likely decide that you want to change your worksheet’s structure. Maybe you want data in a different column, or certain rows turn out to be unnecessary.

When you insert a new row or column, the existing ones move to make room for it. You can insert multiple rows or columns at once by selecting multiple ones before issuing the Insert command. (There’s no limit on the number you can insert at once!) Similarly, you can delete multiple rows or columns by selecting them before using the Delete command.

In the following exercise, you learn how to insert and delete rows and columns.

  1. Open the file and click anywhere in column A.

  2. On the Home tab, click the down arrow on the Insert button and choose Insert Sheet Columns, as shown in this figure.

    A new column is placed to the left of the selected column.

    when users click on the insert button in Microsoft Excel, a pull down menu appears that allows users to insert columns and rows.
  3. Click the column header for column A to select the entire column and then choose Home→Delete.

    The entire column is deleted.

  4. Select rows 7 and 8 by dragging across their row headers and then choose Home→Insert.

    Two new rows are inserted.

  5. Click any cell in row 7; then, from the Home tab, click the down arrow on the Delete button and choose Delete Sheet Rows.

    The figure shows the worksheet after the insertions and deletions.

    a Microsoft Excel worksheet after columns and rows are inserted and deleted.

About This Article

This article is from the book:

About the book author:

Bill Evans has helped thousands of people to play the five-string banjo through his instructional workshops, music camps, DVDs, books, and recordings. He has performed on stages all over the world, his recordings have topped folk and bluegrass charts, and he has mentored many of today's top young professional players. Bill shares the shortcuts and secrets he has developed in more than 35 years of teaching to help all banjo players sound their best.

This article can be found in the category: