How to Make Sequentially Numbers in Microsoft Excel

microsoft office excel 2013



The steps are as follows:

- Using AutoFill

1. Enter the desired number in the Excel sheet in 2013, for example, the number 1 in cell C3.
excel sheet number 1 in cell C3


2. Then drag down to cell C7 and select Fill Series

excel cell C7


3. Then digit number 1 of cell C3 to C7 will be sequentially 
excel cell number 1 of C3




- Using the Ctrl key on the keyboard

 1. Enter the number 1 in the excel sheet 2013 for example in cell D4
excel number 1 cell D4



2. Then press Ctrl and drag down to cell D11 which is the number 1 in cell D4 will be sequentially up to the D11 cell

excel number 1 in cell D4


 Good Luck....





No comments:

Post a Comment