Inserting Rows or Columns

After you’ve created a worksheet and begun filling in your data, you might decide to insert a row or column to add data you didn’t think to include when you started. For example, a customer might want to add a product to an order. To accommodate this, you can insert a blank row below the last row in the existing order and add the new item there. If you wanted to add a row in the middle of the existing order data, you could insert a blank row above an existing row. You can perform similar actions with columns: If you want to begin recording a new piece of information about your customers, such as a Web site or e-mail address, you can add a column to store that information. You can even use the Insert Options smart tag to format the new rows or columns.

Insert a Row in a Worksheet

  1. Right-click the row header below where you want the new row to appear.

  2. Choose Insert from the shortcut menu.

    Insert a Row in a Worksheet

Insert a Column in a Worksheet

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

  2. Choose Insert from the shortcut menu.

    Insert a Column in a Worksheet

    Tip

    Tip

    If you want to insert more than one row or column at a time, select a number of existing rows or columns equal to the number you want to insert and then choose the Insert command from the shortcut menu.

Set Insert Options

  1. After inserting rows or columns, click the Insert Options smart tag.

  2. Select the type of formatting you want the new cells to have.

    Set Insert Options

    Tip

    Tip

    The Insert Options smart tag will appear only if the cells above or below the insertion point have special formatting.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.226.104.127