Ask Your Question

LibreOffice Calc: How to auto-fill a row with double click on handler?

asked 2017-11-29 18:45:00 +0200

Pantona gravatar image

In the vertical way auto-fill works very easy with a simple double-click on the handler (which is located in the lower right edge of the marked cell). Then the whole column is getting auto-filled until the neighbour column on its left hand side is not occupied anymore.

How can I do the similar thing like auto-fill a horizontal row until the neighbour row above is not occupied anymore?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-11-30 00:43:37 +0200

Jim K gravatar image

updated 2017-11-30 00:44:32 +0200

According to

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.

edit flag offensive delete link more


Thank you very much! Maybe it would be useful if the LibreOffice-developers could add such a feature for columns also for rows. For example: Press Shift and double click the handler to auto-fill a row instead of a column.

Pantona gravatar imagePantona ( 2017-11-30 05:08:29 +0200 )edit

Sounds good to me! To make an enhancement request, see

Jim K gravatar imageJim K ( 2017-11-30 19:06:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-11-29 18:45:00 +0200

Seen: 2,093 times

Last updated: Nov 30 '17