Pasting single formula entire column

**scomar411** · 07-16-2007, 08:55 PM

How does one paste a single formula to an entire column and have it end at the first cell w/no data? The only solution I know at this point is to highlight and scoll down the entire data set...slow. Pls help

**davesexcel** · 07-16-2007, 09:33 PM

Originally Posted by scomar411

How does one paste a single formula to an entire column and have it end at the first cell w/no data? The only solution I know at this point is to highlight and scoll down the entire data set...slow. Pls help

I don't quite understand, try double clicking the right bottom corner of the cell

**scomar411** · 07-16-2007, 09:39 PM

I'd like to paste a single formula down a column 7,000 rows,with values, and stop after it reaches a row w/no entries. Currently I start at the bottom row with data then highlight to the top using the scroll key and then paste the formula. Is there a faste way?