View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How do I ROUNDUP an entire column of numbers?

Just copy the ROUNDUP formula down the column. Select the cell, select the
bottom right-hand corner and it will turn into a square "fill handle" which
you can drag down. If your formula is in a cell adjacent to the column with
the data, if you double-click the fill handle it will fill down the column
as far as the data stretches.
--
David Biddulph

"Yellow Elk" <Yellow wrote in message
...
I need to ROUNDUP an Excel column that contains 250 numbers. Is there a
way
to do this without rounding up each cell individually?