Enter your formula in the uppermost cell in the column of choice, then
left-click on it and left-click and drag the little black square in the lower
right hand corner down the column as far as you wish to copy the formula...

hth
Vaya con Dios,
Chuck, CABGx3



"dhoward via OfficeKB.com" wrote:

I download a lot of data from various sources and need to manipulate in Excel.
These spreadsheets are of variable size. Sometimes I need to add a formula
to the spreadsheet. I've been entering my formula, copying it and then
selecting entire column and then pasting it. This of course expands the size
of my spreadsheet to the maximum size. I tried using paste special but that
didn't prevent it. What can I try to paste only in the active area of my
sheet?

--
Message posted via http://www.officekb.com