Excel has a powerful feature which enable user to input by using drag operation we have use this when we want to write month name we'll just have to write jan or January and drag it excel will automatically fill all remaining month name.
You can make your own custom list which help you to input in a fast way....
You can make your own custom list which help you to input in a fast way....
Excel 2003
- Type your list as in the image
- Goto tools >Optoins>CustomLists>Select your list range>import
Excel 2007
- Type your list as in the image
- Office Button > Excel Options > Popular > Edit Custom List.. > Select your list range > import
No comments:
Post a Comment