Open Office - Autofill under Calc

April 2018

The Autofill feature of Calc, though far less acheived, works in the same way as under Excel:

For example to autofill the days of the week.
  • Enter the starting day and move your cursor to the lower-right of the cell.
  • The cursor shall change to a small + sign
  • Left click/hold and drag along the desired range of cell

  • Upon releasing the mouse button the mouse button, all the cell will be automatically filled.
Published by jad05. Latest update on January 10, 2011 at 09:27 AM by jad05.
This document, titled "Open Office - Autofill under Calc," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Open Office Calc - Insert an Audio file or Video in a cell
OpenOffice Calc - Protect your spreadsheet with a password