Question

how will you create a list of numbers 1,2,3,...50 in excel 2013

Answer 1

Select the cells that you want to contain the lists.

On the ribbon, click DATA > Data Validation.

In the dialog, set Allow to List.

Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK