We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

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

Pantona gravatar image

updated 2021-05-20 08:16:37 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-21 18:26:36.831855

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 https://help.libreoffice.org/Calc/Aut...:

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 https://ask.libreoffice.org/en/questi....

Jim K gravatar imageJim K ( 2017-11-30 19:06:24 +0200 )edit

Question Tools

1 follower


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

Seen: 15,459 times

Last updated: Nov 30 '17