I want my column to look like
number
30/31/32/33/34
30/31/32/33/34
30/31/32/33/34
30/31/32/33/34
......
eg: The content in each cell is 30/31/32/33/34. I want to fill all of the cells in the column with the same content 30/31/32/33/34, but when I drop down the first line, the following line will be 30/31/32/33/35, followed by 30/31/32/33/36…..how do I make it so each cell contains 30/31/32/33/34.
How can I fill all the cells in a column with the same content(30/31/32/33/34) if there are 8000 rows?
If there are 8000 rows when using copy/paste, it will take too long, is there a simple way to filling the 8000 rows with the same content; 30/31/32/33/34?
Best Answer
The answer is quite simple. Just hold down the Control (Ctrl) key as you drag down the auto fill handle. The last or any of the numbers do not increment.