Keyboard shortcut for copying formula to the end of my table data

pavion · August 11, 2023, 12:06pm

In LibreOffice 7.5.5.2 on Windows 10 I have a two columns: income and expenses. Income is from A1:A100, Expenses is in B1:B100. In C1 I have created formula: =A1-B1
Now I need to copy formula from cell C1 to cell C100. In C1 I press CTRL+C to copy a formula. Now a question? How to quickly select cells from C1 to C100, so I can easily paste the formula.

For example if I click on cell A1 and press Ctrl+Shift+Arrow_Down key I get selection from A1:A100, but if I do the same for C1, I get selection from C1 to the end of spreadsheet (million and something row).

The question is, how to quickly select cells from C1:C100 with keyboard shortcut?

P.S. The more rows my table has, much longer manual selection takes place.

robleyd · August 11, 2023, 12:15pm

The question is, how to quickly select cells from C1:C100 with keyboard shortcut?

The question really is - how to fill cells C1:C100 with the formula.

Click in C1 where you have the first formula =A1-B1

At the bottom right of C1 you’ll see a small black square; double click on that to fill down column C to match filled cells in column B. You can also drag down with the square.

pavion · August 11, 2023, 12:32pm

Double click on black square in C1 really copies data to the end of table. Excellent. Any keyboard shortcut for this?

karolus · August 11, 2023, 12:50pm

<ctrl>d would work, but unfortunatly it requires an explizit Selection of C1:C100

whats wrong with doubleclick ?

sokol92 · August 11, 2023, 1:15pm

Stops before a combination of empty cells in the current column and the column on the left (you need to keep this in mind).

Shortcut:

Ctrl+Shift+F5 (Name Box)
Type C1:C100, Enter.
Ctrl+D

Or:
2a. Type C100, Enter, Ctrl+Shift+Arrow_Up.

karolus · August 11, 2023, 3:16pm

Yes of course, but OP states: Excellent… so I guess there no gaps!

pavion · August 12, 2023, 8:14am

I use keyboard most of my time, typing in, keyboard shortcuts etc. That is why I asked if there is some keyboard shortcut to do the double click on “small bottom-right black square”.

@sokol92, those keyboard combinations do work, but it is way more time consuming that double mouse click. Specially, because I usually do not know what is the maximum row I need to copy text to (like C100 in my example). When I have several thousand rows, then I would need to move down to max row to get this info first. The time spend to do this is way higher then releasing a mouse and double click black-small-square.