J
JayKimball
How can I get a collum to go from 1-50 with out typing 1 then 2 then 3 so on
and so forth in every row?
and so forth in every row?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
One way, enter in A1: 1, then right-click on A1's fill handle*, drag down as
far as required. Upon release, choose Fill Series.
*the black square at the bottom right corner of A1
far as required. Upon release, choose Fill Series.
*the black square at the bottom right corner of A1
M
Mike Rogers
JayKimball
Only to add to Max's response:
You could enter Row() in A1 and drag down to row fifty
You could place 1 in A1 and 2 in A2, select them both and with the fill
handle (Lower right corner of the selected cell, the big white plus sign will
turn to a smaller black plus sign) right click and drag down to row fifty.
Mike Rogers
Only to add to Max's response:
You could enter Row() in A1 and drag down to row fifty
You could place 1 in A1 and 2 in A2, select them both and with the fill
handle (Lower right corner of the selected cell, the big white plus sign will
turn to a smaller black plus sign) right click and drag down to row fifty.
Mike Rogers
S
Suleman Peerzade
Hi,
Try this.
Edit/Fill/Series/select rows or columns where in you want the series to
appear.
In Type Select /linear
Then in Step value it is 1 and in Stop value (Whatever value you want excel
to fill)
Then Ok.
By using this you can fill series in both rows and columns upto any extent.
Excel 2003.
Try this.
Edit/Fill/Series/select rows or columns where in you want the series to
appear.
In Type Select /linear
Then in Step value it is 1 and in Stop value (Whatever value you want excel
to fill)
Then Ok.
By using this you can fill series in both rows and columns upto any extent.
Excel 2003.
J
joeu2004
How can I get a collum to go from 1-50 with out typing 1 then 2 then 3
so on and so forth in every row?
Yet another way....
Enter 1 into A1. Enter =A1+1 into A2, right click and select Copy.
Enter A3:A50 in the Name Box of the Formula Bar, right click and
select Paste.