In this dialog box you enter: 

  Start value: Enter the start value for the series.  The start value must be a number, character or 

properly formatted date. 

  Step value: Enter a positive or negative number to indicate the amount by which you want a series to 

increase or decrease. 

  Step unit (dates): Specify whether the series of dates will increase by days, weeks, months, or years. 

Available only when creating a date series. 

Insert   Remove 

To insert or remove the spreadsheet row or column where the cell pointer is located, select the 

corresponding menu command in the Edit menu. 

Examples: 

  When the cell pointer is located in row 20 and you select the command Insert row in the menu, then all 

rows starting with row 20 will be moved down and a new row will be inserted at this position.  So row 20 

will be moved to row 21, row 21 to 22, etc., and row 20 will be empty. 

  When the cell pointer is located in column B and you select the command Remove column in the menu, 

then column B will be removed and all columns starting with column C will be moved to the left.  So the 

data in column B will be lost, and column C will be moved to column B, column D to C, etc. 

Transpose 

With this command you can switch the orientation of data, either in a selected area, or in the complete 

spreadsheet. 

Data from the top row of the area to transpose will appear in the left column of the transposed area, and 

data from the left column will appear in the top row. 

When you want to transpose only a particular area of the spreadsheet, select this area with the mouse.  In 

this case, the number of rows and the number of columns of the selected area must be equal  (while 

selecting, this can be checked in the status bar). 

31