How to create a table with numbers from 1 to 600?
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!
|