- The Clipboard Viewer
- Editing with the Keyboard
- Creating a Data Series
- Creating a Custom Fill Series
- Creating a Custom Fill to Define Linear or Growth Trends
- Creating a Custom List or Series
- Replacing Data
- Tracking Changes Made by Multiple Users
- Using Comments to Explain Cell Content
- Linking Excel Data
- Troubleshooting
- Excel in Practice
This chapter is from the book
This chapter is from the book
This chapter is from the book
Creating a Custom List or Series
Companies often have custom data that pertains only to their organization, such as lists of employees, fiscal year, or selected states in which that the company does business. When you type a list once, that's the last time you should ever have to type it. Yes, you could copy and paste the list but that's not necessarily the most efficient way. The best way to handle this information is by creating a custom list so when you type in one of the states, you can then drag the fill handle to fill the rest of the states in automatically, in the order you predefine (see Figure 3.14). Take Figure 3.15, for example. The list of states is the states a company normally has to type in. To automate this list or create a custom list, follow these steps:
-
Select the cell or cells you want in your custom list.
-
Choose Tools, Options.
-
From the Options dialog box, select the Custom Lists tab as shown in Figure 3.16. Click Import.
-
Click OK.
)
Figure
3.14 Start a state in the list and drag the fill handle.
)
Figure
3.15 Create and select the list you must often type or that is specific
to your organization.
)
Figure
3.16 Create and select the list you have to often type or is specific
to your organization.