Instead of 3.11111, put the cell location, such as B2, which should be the
first cell that needs the formula at the top of the column. Then copy the
formula down using the Fill Handle.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"STK" wrote in message
...
I have quite a few columns I want to roundup the values. I know how to do
=roundup(3.11111,0), but how do I copy that to a bunch of cells?
--
STK