Append and Insert

The Append and Insert functions are used to add a specific number of columns or rows to tables. Click below to learn more.

How do I... ?

• Add columns

   

  1. Click in the column header (the column will highlight in blue) to the left of where the columns are to be inserted.

  

   

  2. With the mouse located in the blue area, right click to display the menu box.

  3.  Select insert.

  

   

  4. The append pop-up box will display.

  

   

  5. Enter the number of columns to append then click OK. (The columns will insert to the right of the highlighted column).

  

   Column "D" was inserted to the right of highlighted column

   

  6. Click to save changes.

  1. Click on the column header to the left of where you want the columns to be inserted. The column will be highlighted in blue.

   

  2. With the mouse located in the blue area right click to display function table and select insert

   

  3. The append pop up box will be displayed

   

  4. Simple type in the number of columns you what to insert. The columns will insert to the right of the highlighted column.

  Note: Column "D" was inserted to the right of highlighted column

  5. Click save   to save your changes

• Add rows

   

  1. Click in the row header. (The row will highlight).

  

   

  2. With the mouse located in the blue area, right click to display the menu box.

  3. Select Append.

  

   

  4. The append pop-up box will display.

  

   

  5. Type the number of rows to insert and then click OK. (The rows will append at the bottom of the table).

  

  Note: Row 3 was added to the bottom of the list.

   

  6. Click to save changes.