Question

how to write a series of numbers from 1 to 10 without using the keyboard in excel sheet?​

Answer 1

Enter a 1 in the first cell and press Ctrl+Enter to keep the cell selected.

Press & hold the Ctrl key.

Use the fill handle to drag the number down one cell. A 2 will be placed in the next cell.

Double-click the fill handle to perform