Use the AutoFill handle

  1. Enter a cell's contents
  2. Point at the the fill handle on the lower right corner of the cell.

    AutoFill Handle

    • Make sure you get the + pointer
    • Drag to fill
    • Ctrl+drag or right-drag (drag with your "other" mouse button) for different results
    • Double-click the fill handle to AutoFill "all the way"
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish