View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Klee Klee is offline
external usenet poster
 
Posts: 67
Default How to... apply the same formula to every cell?

I've run a sales report by item showing monthly sales for the last 3 years.

I need to divide each cell by 4.

I am sure there is a much easier way than what I'm currently doing... right
now I'm clicking in each cell, entering the "=" before the result, arrowing
to the end & pasting the "/4".

I think I'll go insane if I have to do this to all the cells...

Is there a way to select a range of cells & have it apply the same formula
to all of the cells at once?