Follow the given below steps for how to drag continuous number in excel sheet.
- Enter the number like 5001.
- Click down arrow and use " = " then use up arrow (show =A1) and press " +1 " sign.
- Go to line no ( how many no drag like 20 ).
- Press ctrl+shift+uparrow
- At last use ctrl+d.
No comments:
Post a Comment