How to stop autocalc from adding a digit to each column cell

[Chimerakc]

So I want to be able to enter a number and click on the lower right corner and drag down through more columns and repeat THE SAME number in every cell. I guess the default program adds one to the previous entry as you scroll down. I have tried unclicking all 3 commands in the tools - cell format - menu. Thanks

[FJCC]

If you hold down the CTRL key while dragging, the same number will be placed in each cell.

[Chimerakc]

Thanks I tried something like that, will try again. Will hit control both before and after clicking on the corner

[RoryOF]

Click on the cell so the black square shows bottom right. press and hold Ctrl, then drag black square down.