?

Log in

No account? Create an account
 
 
11 April 2009 @ 04:27 am
Alternative to click & drag?  
Suppose I have a very large data set in Calc and I want to enter a formula into several thousand cells. Is there a way to do so besides typing the formula into one cell and then dragging it over 46 655 more cells?
 
 
 
ormeco on April 13th, 2009 09:06 pm (UTC)
Re:Alternative to click & drag?
Hi!

As long as the destination cells are empty, and the cell past the last one has some content in it, you can copy the formula, and when you need to set the destination range, you can click on the first cell and then type

CTRL+SHIFT+DOWN ARROW

and the range will mark all the way down to the last empty cell. Then pressing the ENTER key will paste the formula.

Hope this helps.
6ferrets6ferrets on May 20th, 2009 12:01 am (UTC)
Re: Alternative to click & drag?
I finally got back to this project, and your solution works great. Thanks!