how to fill series of common diference 10000 not typing manually.

[nisha01]

hi..
how can i enter 10000 ,20000 and so on not manually..please suggest!

 

[Chihiro]

Enter 10000 in first cell in range.

In Ribbon tools-Home Tab. Find "Fill" button->"Series".

Choose "Series in" (whichever direction), Type as Linear.
Step value as "10000", Stop value as your maximum series value (ex. 500,000).

Hit Ok.

 

[Chihiro]

Alternately, type 10000 in first cell, 20000 in second cell.

Highlight both cells, go to right bottom corner of the selected range (you will see solid black cross). Drag selection down (or across depending on how first 2 cell is arranged).

 

[Basavaraj K H]

Hi
Say example in cell A1 Type 1
& in cell A2 Type formula like below
=A1+1
use the Go to function press F5 or Ctrl G
in Reference type A10000
OK or Enter
press Ctrl Shift up array & finally
press Ctrl D

 

[Khalid NGO]

Hi,

Or try this and copy down:

=ROW(A1)*10000

Regards,