Translations:Basic Excel/77/en

Cell with a number
  1. Select the desired cell.
  2. Move the cursor to the righthand edge of the cell until it changes shape to a '+'.
    • Note that screenshots DO NOT show this shape change!
  3. Right click and DRAG the cursor to the desired extent of the copy range.
  4. Release the button. The cells will fill with the copied text, but there will be an option button at the bottom righthand corner of the selection:
    Copied cell with number
  5. If this is what you want, you can ignore this button. Otherwise, click on the down arrow to reveal options:
    Copy-and-drag number autofill options
  6. Select 'Fill series' to fill the selection; by default, this will be done in 1 step increments:
    Copy-and-drag - fill with series