Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Perhaps something like this:

A2: =F1+1
B1: =A2+1
Copy that cell across thru F2

Copy A2:F2
Paste down thru row 101

To "hardcode" those numbers
Select the A2:F101
<edit<copy
<edit<paste special<values

Adjust references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Today's my day for typos..

This is the correct formula:
B2: =A2+1

NOT B1: =A2+1

apologies
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Perhaps something like this:

A2: =F1+1
B1: =A2+1
Copy that cell across thru F2

Copy A2:F2
Paste down thru row 101

To "hardcode" those numbers
Select the A2:F101
<edit<copy
<edit<paste special<values

Adjust references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Oh my God... I'm very sorry but it seems I'm not able to understand yet. :-((((
Excel is a complete mystery to me?
Could you try to explain a step to step guide for a complete idiot (in using
excel) like me?
I don't understand what f1+1 or a2:f2 stands for!! :-(((
You're very kind, thank you so much!!!
Ciao

"Ron Coderre" wrote:

Perhaps something like this:

A2: =F1+1
B1: =A2+1
Copy that cell across thru F2

Copy A2:F2
Paste down thru row 101

To "hardcode" those numbers
Select the A2:F101
<edit<copy
<edit<paste special<values

Adjust references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

OK..See if this works for you..

If you want to create a grid of numbers from 1 thru 600, that is 6 columns
by 100 rows, beginning in cell A2, do this:

In cell A2 type: =F1+1
Then press the [Enter] key.
(The notation for those steps is A2: =F1+1)

B2: =A2+1
Copy that cell across thru F2
Here's how:
Select cell B2
From the Excel main menu:<edit<copy
Select cells B2:F2
Press the [Enter] key

Copy A2:F2
Paste down thru row 101
Here's how:
Select cells A2:F2
From the Excel main menu:<edit<copy
Select cells A2:F101
Press the [Enter] key

That will create the table of numbers, but they will be formulas.
If you want to convert them to "hardcoded" numbers (as if you typed them all
in), do this:
Select the A2:F101
From the Excel main menu:<edit<copy
From the Excel main menu:<edit<paste special
Select: Values
Press the [Enter] key

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Oh my God... I'm very sorry but it seems I'm not able to understand yet. :-((((
Excel is a complete mystery to me?
Could you try to explain a step to step guide for a complete idiot (in using
excel) like me?
I don't understand what f1+1 or a2:f2 stands for!! :-(((
You're very kind, thank you so much!!!
Ciao

"Ron Coderre" wrote:

Perhaps something like this:

A2: =F1+1
B1: =A2+1
Copy that cell across thru F2

Copy A2:F2
Paste down thru row 101

To "hardcode" those numbers
Select the A2:F101
<edit<copy
<edit<paste special<values

Adjust references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Frank

I realize this is the NewUsers group, but maybe you're willing to try some VBA.

This macro allows you to build a table of numbers in rows and columns.

Your choice of direction and scope.

Sub FillNums()
'to fill rows and columns with numbers from 1 to whatever
Dim nrows As Integer
Dim ncols As Integer
On Error GoTo quitnow
RowsorCols = InputBox("Fill Across = 1" & Chr(13) _
& "Fill Down = 2")
Num = 1
nrows = InputBox("Enter Number of Rows")
ncols = InputBox("Enter Number of Columns")
If RowsorCols = 1 Then
For across = 1 To nrows
For down = 1 To ncols
ActiveSheet.Cells(across, down).Value = Num
Num = Num + 1
Next down
Next across
Else
For across = 1 To ncols
For down = 1 To nrows
ActiveSheet.Cells(down, across).Value = Num
Num = Num + 1
Next down
Next across
End If
quitnow:
End Sub

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Thu, 15 Jun 2006 13:22:02 -0700, F R A N K
wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Gord Dibben MS Excel MVP

Thank you for the macro suggestion! I'd like a lot to understand them and use
them, but I'm too much newbie I fear... :-(((
Thanks anyway! Ciao :-)))

"Gord Dibben" wrote:

Frank

I realize this is the NewUsers group, but maybe you're willing to try some VBA.

This macro allows you to build a table of numbers in rows and columns.

Your choice of direction and scope.

Sub FillNums()
'to fill rows and columns with numbers from 1 to whatever
Dim nrows As Integer
Dim ncols As Integer
On Error GoTo quitnow
RowsorCols = InputBox("Fill Across = 1" & Chr(13) _
& "Fill Down = 2")
Num = 1
nrows = InputBox("Enter Number of Rows")
ncols = InputBox("Enter Number of Columns")
If RowsorCols = 1 Then
For across = 1 To nrows
For down = 1 To ncols
ActiveSheet.Cells(across, down).Value = Num
Num = Num + 1
Next down
Next across
Else
For across = 1 To ncols
For down = 1 To nrows
ActiveSheet.Cells(down, across).Value = Num
Num = Num + 1
Next down
Next across
End If
quitnow:
End Sub

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo


Gord Dibben MS Excel MVP

On Thu, 15 Jun 2006 13:22:02 -0700, F R A N K
wrote:

Thank you so much, but I need to use both rows and columns. Can you please
help me again? Thanks a lot! :-)))
Ciao

"Ron Coderre" wrote:

If the list of number is all in one column, try something like this:

Enter a 1 in cell A1
Select Cell A1

From the Excel main menu:
<edit<fill<series
Series in: Column
Stop Value: 600
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"F R A N K" wrote:

Hi!
I need to create a table with numbers ranging from 1 to 600. It could be
simpler.
Just automatically filling cells with these numbers in increasing order.
I'm trying with excel, which sould be the most appropriate software to do
that, but I'm very negated with it. Could you please help me?
Thanks a lot, ciao!

Gord Dibben MS Excel MVP