suppose you want to divide all columns with 5.

1. Enter 5 in a different cell
2. copy the cell
3. Select the columns/values which are to be divided.
4. Right click-Paste Special.
5. Select 'divide' and OK/

--
If this post helps click Yes
---------------
Jacob Skaria


"twoods403" wrote:

I have a net cost sheet. I want to divide each of the 7 columns (which each
have different values) by one number to get my sell price. When I looked at
the MOD function, it asked for the number in the cell and then my division
number. Do I have to do this manually for each cell or is there a way I can
do a formula applying division to each of cells at one time?