O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding and deleting columns and rows

As you continue to add to your worksheet, sooner or later you will need to insert columns and rows within the areas where you’ve already added values. You can easily insert a column—or more than one—and add rows, as well, and if you’ve inserted formulas on the worksheet, Excel 2013 will adjust the formulas automatically to accommodate the addition of the new cells.

Insert a column

  1. Right-click and hold the column header immediately to the right of where you want the new column to appear.

  2. In the options menu or minibar that appears, click Insert.

image with no caption

Insert a row

  1. Right-click and hold the row header ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required