Ask Your Question

Copying rows by dragging to the right

asked 2018-12-20 14:50:42 +0200

ch0sen gravatar image

updated 2018-12-27 20:54:19 +0200

wget gravatar image


quick question: how i can copy contents from, for example A5 to D5, without using =A5 formula in D5?

What function should i use in D5, to be able to ctrl-drag that cell to the right, so it would fill cells to the right with correct values (E5=222, F5=333, G5=444, G=555.. and so on?)

screen: image description

Thanks for help!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-20 18:38:36 +0200

erAck gravatar image

updated 2018-12-20 18:40:49 +0200

Copy A5 to clipboard, on D5 use Paste Special (Shift+Ctrl+V) and either click Values Only (the $0 button) or Values & Formats (the paintbrush button), or check Text, Numbers and Date & time (and possibly Formats) and hit OK. This will paste the values and use formula results instead of underlying formulas (of which relative references would be adjusted to the new position). You can also check the Transpose option to paste a column vector selection as a row vector (which seems to be what the screen shot hints with its colours).

edit flag offensive delete link more


Thanks, transpose is very helpful and it will speed up the process, but could i use some magic, which will update d5 whenever i change value in a5?

ch0sen gravatar imagech0sen ( 2018-12-21 09:12:14 +0200 )edit

You said you do not want to use a formula.. so no.

erAck gravatar imageerAck ( 2018-12-21 12:02:50 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-20 14:50:42 +0200

Seen: 35 times

Last updated: Dec 27 '18