Automatically fill series in Ms Excel

 Auto fill in ms excel | Automatically fill series in Ms Excel
•    Select cell when you are want
•    Enter value like 1 or Sunday or January etc.,
•    Click enter on keyboard or select next cell.

•    Enter value like 2 or Monday or February etc.,
•    Then select both cells
•    Then put pointer at + symbol on fill handle
•    Then left click on mouse and drag mouse down
•    You will see fill series automatically
•    Result :
Example 1: 1,2,3,4, etc.,
Example 2: 2,4,6,8, etc.,
Example 3: 1,3,5, etc.,
Example 4: Sun,Mon, Tue, etc.,
Example 5: Jan, Feb, Mar, etc .,
•    For better understanding see the below video

No comments:

Post a Comment