• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 14. Inserting and Removing Cells,... > Inserting Rows and Columns

Inserting Rows and Columns

As you edit and enhance your worksheets, you might need to add rows or columns within the worksheet. Inserting entire rows and columns into your worksheet is very straightforward. Follow these steps:

  1. To insert a single row or column, select a cell to the right of where you want to insert a column, or below where you want to insert a row.

    To insert multiple columns or rows, select the number of columns or rows you want to insert. To insert columns, drag over the column letters at the top of the worksheet. To insert rows, drag over the row numbers. For example, select three column letters or row numbers to insert three rows or columns.

  2. Select the Insert menu, and then select Rows or Columns. Excel inserts rows above your selection and columns to the left of your selection. The inserted rows or columns contain the same formatting as the cells (or rows and columns) you selected in step 1. Figure 14.1 shows a worksheet in which additional columns have been added to a worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint