Hi, there,
How to creat data as following in one column of Excel,
1,3,5,7,9..........1001
Thanks,
Mike
Hi, there,
How to creat data as following in one column of Excel,
1,3,5,7,9..........1001
Thanks,
Mike
#1
--------
Put a 1 in the first cell of the column
Select the entire column
Menubar: Edit > Fill > Series > columns, linear, step=2, stop=1001
#2
--------
type 1,3,5,7, in the first few rows of the column, select the rows and drag the selection rectangle down the column. It will increment as you go down.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks