Re: Grow a range by # of lines by right click on grow tool & type

I'm sorry, I was under the impression that you were solely interested in *copying*.

If we're talking about *filling*, there's a dialog box that can help you *fill* easily and quickly, if you're looking to go down a 1,000 rows or across a couple hundred columns, and accomplish this without having to "drag" the cells.

Say you want to number the rows from A2 to A1002, from 1 to 1000.

Enter 1 in A2 and click back in it to select it, then,
<Edit> <Fill> <Series>
Since you're filling down, click "Columns",
Then "Step Value" = 1
"Stop Value" = 1000
Then <OK>
And you're done!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"David Thyer" <DavidThyer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:73FC90AF-3ECC-4DB2-A8BE-8FD82112F80B@xxxxxxxxxxxxxxxx
For example, I type "Month" in A1 as a column heading. Then I type "1" into
A2, and "2" into A3. Then I select the range A2:A3. Finally I drag the little
square at the bottom right of the selection down for the required number of
rows, and the new values generated into cells A4 downwards have increasing
values, 3, 4, 5 etc. onwards.

When I try what you suggested, I just get the value in the cell repeated,
e.g. the value 2 repeated. Maybe I am doing it wrong?

Thanks,

David

"RagDyer" wrote:

Your terminology of "growing it" is unfamiliar to me.

Can you relate to me what the procedure that I described does *not* do in
"quite the same way" that your *growing it* does do?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Thyer" <DavidThyer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B045DC3D-4954-4794-8CCD-A657C4794FE7@xxxxxxxxxxxxxxxx
> Hi RagDyeR,
>
> Thanks for that. It doesn't seem to extend the range in quite the same > way
> as growing it, just copies the last value, but by having a dummy first
> column
> using this method, and then double clicking for the real columns, as > per
> Jaleel's suggestion, it gets me there.
>
> Thanks again,
>
> David
>
> "RagDyeR" wrote:
>
>> You can just about do that.
>>
>> Click in the cell containing the data or formula to copy.
>> Click in the 'name box' (left of formula bar).
>> Type in *last* cell address, say A300.
>> Hold down <Shift> and hit <Enter>
>>
>> This selects the range, with the focus in your first, original cell.
>>
>> Now, to complete the copy,
>> Hit <F2>,
>> Then <Ctrl> <Enter>
>>
>> And you're done!
>> -- >>
>> HTH,
>>
>> RD
>> =====================================================
>> Please keep all correspondence within the Group, so all may benefit!
>> =====================================================
>>
>> "David Thyer" <David Thyer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:92EA2F40-05B0-4213-A0AB-8DE4EC64708E@xxxxxxxxxxxxxxxx
>> Often when I'm doing a quick mortgage spread***, I enter the first
>> couple
>> of lines, then grow the range downwards by dragging the grow tool at >> the
>> bottom right of the selected range. This works, but it is a bit of a >> pain
>> when I am growing it to a large number of rows, as it often scrolls >> too
>> far.
>> It would be nice to be able to right-click on the grow tool (the >> square
>> at
>> the bottom right corner of the selected cell or range) and then type >> in a
>> number of lines to grow.
>>
>> ----------------
>> This post is a suggestion for Microsoft, and Microsoft responds to the
>> suggestions with the most votes. To vote for this suggestion, click >> the
>> "I
>> Agree" button in the message pane. If you do not see the button, >> follow
>> this
>> link to open the suggestion in the Microsoft Web-based Newsreader and
>> then
>> click "I Agree" in the message pane.
>>
>> http://www.microsoft.com/office/community/en-us/default.mspx?mid=92ea2f40-05b0-4213-a0ab-8de4ec64708e&dg=microsoft.public.excel.misc
>>
>>
>>



.

Loading