If you select the first cell then do a Goto and enter the last cell that you
want then press and hold the Shift key while you press the OK button on the
Goto dialog box then the range that you want will be highlighted.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter. that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.