how to divide the number in one cell into multiple cells

  • Thread starter Thread starter Ramya
  • Start date Start date
R

Ramya

I have a value (5000) in one Excel cell. I need to distribute it into equal
values in 10 cells. Can any one please let me know how to do that
 
Suppose you have 5000 in cell A1 and your target cells are B1:B10.

Select B1:B10. Keeping the selection of 10 cells press = to enter a formula

=A1/10

Instead of enter press Ctrl+Shift+Enter...Now try changing the value in A1

If this post helps click Yes
 
Back
Top