Hello,
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:
Thanks for help!
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).
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?
You said you do not want to use a formula… so no.
