Ask Your Question

How can a formula be pasted into a column [closed]

asked 2017-12-06 08:59:05 +0100

biiiep gravatar image

updated 2020-09-02 22:19:22 +0100

Alex Kemp gravatar image

i try to copy and paste (fill up) a column with a formula.

how can this be done as i can drag things down, this won't work for me with more than 100 cells.

tried this "paste special" but this filled up only one cell. Then there's "alt+enter" does basically the same.

it should be any easy thing todo, right?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-09 01:46:36.270902

2 Answers

Sort by » oldest newest most voted

answered 2017-12-06 09:24:25 +0100

robleyd gravatar image

Does the formula refer to an adjacent column that is filled? If so, double click on the little handle on the bottom right of your formula cell to fill down to where the adjacent cell has data.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


i get there the square dot... if i double click that nothing happens.

biiiep gravatar imagebiiiep ( 2017-12-06 20:05:34 +0100 )edit

answered 2017-12-06 13:00:24 +0100

Regina gravatar image

updated 2017-12-09 14:48:13 +0100

You have to mark the target range before you paste the formula. To mark a range without mouse enter the range address into the "Name Box" field top-left of the grid and hit Enter. Or you can name the target range via Sheet > Named Ranges and Expressions. Then you can select this range from the drop-down-list of the "Name Box" field.

Method A: Write F1:F100000 into the name field, Enter. Click in input line and write =E1*2. Press Alt+Enter.

Method B: Write =E1*2 into cell F1, Enter. Write F1:F100000 into name field, Enter. Press Ctrl+D for to fill down.

Method C: Write =E1*2 into cell F1, Enter. Set cell cursor to F1, Ctrl+C. Enter F2:F100000 into name field, Enter. Ctrl+V.

Please do exactly as I describe it, especially where to write something and when to press Enter. Try the methods with an separate spreadsheet and the simple formula =E1*2. In case your real formula is complex, it might take a while to fill and recalculate 100000 cells. Which version of LibreOffice do you use, which operating system?

edit flag offensive delete link more


well, then i can select as much as i want, but if i paste the formula i get the dialog to paste unformatted text. Am i doing something wrong?

biiiep gravatar imagebiiiep ( 2017-12-06 20:08:33 +0100 )edit

Du you really have one formula in the clipboard? Click in cell with formula. Ctrl+C. Select the range as indicated above. Ctrl+V. BTW: Alt+Enter is for filling using the input line. Mark the target area. Click in input line. Write formula into input line. Alt+Enter.

Regina gravatar imageRegina ( 2017-12-06 22:42:55 +0100 )edit

well, not sure what i am doing... i mark the cell with the formula, CTRL+C, i can paste it like that anywhere else. then i mark some cells bellow and try to paste it i mark some cells below the formula... paste it and nothing happens.

perhaps i ask the wrong thing...

i want to create a series like i.e.

F1=E1 * 2

F2=E2 * 2

F3=E3 * 2

Fn=En * 2

but i wanna fill the cells up until about 100000.

how can i do that? any more ideas?

biiiep gravatar imagebiiiep ( 2017-12-08 18:30:24 +0100 )edit

Question Tools

1 follower


Asked: 2017-12-06 08:59:05 +0100

Seen: 621 times

Last updated: Dec 09 '17