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