Where is Custom List in Microsoft Excel 2010 and 2013?
- Used way to find out the Custom List command if you have Classic Menu for Office
- If you do not have Classic Menu for Office
Kutools for Excel: 120+ advanced features for Excel 2007, 2010 and 2013 (includes Office 365). Know more
Kutools for Word: 100+ advanced features for Word 2003/2007/2010/2013 (includes Office 365). Know more
Used way to find out the Custom List command if you have Classic Menu for Office
If you have installed Classic Menu for Office on your computer, you can get drop down menus and toolbar back into Ribbon. You can get the Custom List command from Tools drop down menu:
Figure 1: Open Excel Options from Tool Menu
- After clicking the Options item, you will enter the Excel Options window;
- Click the Advanced button at left bar;
- Go to the General section;
- Then you will view the Edit Custom List button, as figure 2 shows:
Figure 2: Edit Custom List button in Excel Options
Click the Edit Custom List button, and you will view the Custom List dialog box. In this dialog box, you can add, delete, import custom lists. The Figure 3 will show more:
Figure 3: Custom List dialog box
Seek for Custom List from Ribbon if you do not have Classic Menu for Office
If you do not have Classic Menu for Office, you can get into the Excel Options from backstage view by clicking the Options button under File tab.
After you get into the Excel Options window, you can follow the same way that we mentioned in method One to get the Custom List dialog box.
More Tips for Microsoft 2007, 2010 and 2013
- Where is AutoFormat
- Where is Control Toolbox
- Where is Document Properties
- Where is Edit Menu
- Where is Format Menu
- Where is Insert Menu
- Where is Page Break Preview
- Where is Tools Menu
Brings the familiar classic menus and toolbars back to Microsoft Office 2007, 2010 and 2013. You can use Office 2007/2010/2013 immediately without any training. Supports all languages, and all new commands of 2007, 2010 and 2013 have been added into the classic interface.
Screen Shot of Classic Menu for Excel