Hi Lauren,
I expect you are straight on use of the worksheet formula now and use
of the fill handle. If not more on fill handle see
http://www.mvps.org/dmcritchie/excel/fillhand.htm
if this is an adjacent cell you can probably double-click on the fill handle,
but it usually means verifying that you did reach down as far as you wanted.
In any case as Bernard stated it is basic Excel skills so you should learn it
before learning to use macros (even if by only a few minutes).

But it sounds like you want to select the area and make the changes in place,
that is where a macro comes in, macro is a lot quicker See
http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lauren" wrote in message ...
Thats what I did. What I meant was, can't I select ALL the cells I need it
to apply too, such as A2 through H925 and apply it to ALL the cells. Not
just one column at a time.