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