Best Offer for Books in Amazon

Showing posts with label How to Fill Number Series in Excel Column. Show all posts
Showing posts with label How to Fill Number Series in Excel Column. Show all posts

Monday 22 May 2017

Fill Number Series in Excel Column

How to Fill Number Series in Excel Column

Hi.!
     In this Tutorial We are providing how to fill number series in excel column with using mouse and drag them. Ya this is most useful because if we want more than 1000 numbers in series in a single column it is very difficult to drag them with your mouse even it takes more time. So learning this we can make how to number series an easy way below steps to guide you how to do this process.

step 1:













1. enter number 1 & 2 in column 'A'.
2. Now select entire column 'A'
3. Home Tab -> Fill -> Click 'series' Option


4. now you will see a pop-up window, make sure enable 'Column' radio button
5. enable Type 'Linear' 
6. Set Step value to '1'
7. Set stop value to '1000'
8. Click to 'Ok' Button 
Now you will see 1000 numbers in Sequential Order in Column 'A'.


Thank You
Excel Tric blog 

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.