Apply formula to entire column

  • Thread starter Thread starter MICHAEL
  • Start date Start date
M

MICHAEL

I need to apply a #/100 formula to an entire column. How
do I do this within the format cell capability.
 
Hi
try the following
- enter 100 in an empty cell and copy this cell
- select your data range
- goto 'Edit - Paste Special' and choose 'Divide'
 
If I understand you correctly, you wish to divide every cell in you
column by 100.

In an empty cell, enter 100. Highlight that cell and select "copy".
Now, highlight the column in question and select "paste special".
Check the "divide" box and your cells will be divided by 100.

Hope this solves your proble
 
Back
Top