Record a macro called "NumberRangeMacro" using relative references $($remember$,$ Excel will not accept spaces between words in its macro names$).$ Store this macro's shortcut keys as Ctrl$+$Shift$+$M$.$ Count from $1$ to $10$ in a range of ten $(10)$ vertical cells.

Run NumberRangeMacro at least twice in different parts of the spreadsheet to ensure it works.