How To Save Custom Lists In Excel 2010

3 Comments

Using the Fill command which you find in Editing group in the Home tab of the ribbon, you can fill a selected range automatically with a wide range of fill options including the Fill Series option. This feature of Excel 2010 uses some built-in lists to detect and fill the range automatically with the proper series of data like months or weekdays.

You can add more lists to these auto-fill series so that you can use the Fill Series feature instead of rewriting all items every time (For example: You can add the months and weekdays names in languages other than English). To do this, Display the Backstage View, click the Options tab to display the Excel 2010 Options dialogue box, then follow the steps below:

1- In the Advanced tab of the Options dialogue box, Under the General option group, click Edit Custom Lists. Excel Displays the Custom Lists dialogue box.

View the Original article