Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

According to https://help.libreoffice.org/Calc/Automatically_Calculating_Series:

You can double-click the fill handle to automatically fill all empty columns of the current data block.

However, there is no similar feature for rows. Instead, do the following:

  1. Go to the cell to autofill from.
  2. Press Ctrl+Shift+End to select the cells to fill.
  3. Fill right by going to Sheet -> Fill Cells -> Right (Alt+s, i, r on my machine).

Tools -> Customize can be used to set up a key combination to fill right.

The above steps are needed for a large number of cells. For only a few cells, simply drag and drop the handle.

According to https://help.libreoffice.org/Calc/Automatically_Calculating_Series:

You can double-click the fill handle to automatically fill all empty columns of the current data block.

However, there is no similar feature for rows. Instead, do the following:

  1. Go to the cell to autofill from.
  2. Press Ctrl+Shift+End to select the cells to fill.
  3. Fill right by going to Sheet -> Fill Cells -> Right (Alt+s, i, r on my machine).

Tools -> Customize can be used to set up a key combination to fill right.

The above steps are needed for a large number of cells. For only a few cells, simply drag and drop the handle.fill handle instead.

According to https://help.libreoffice.org/Calc/Automatically_Calculating_Series:

You can double-click the fill handle to automatically fill all empty columns of the current data block.

However, there is no similar feature for rows. Instead, to fill many cells, do the following:

  1. Go to the cell to autofill from.
  2. Press Ctrl+Shift+End to select the cells to fill.
  3. Fill right by going to Sheet -> Fill Cells -> Right (Alt+s, i, r on my machine).

Tools -> Customize can be used to set up a key combination to fill right.

For only a few cells, simply drag and drop the fill handle instead.