Jump to content

Create a custom Auto Fill list


Recommended Posts

Create a custom Auto Fill list

The Auto Fill feature can make it easy to enter any data series that frequently appears in your spreadsheets. All you need to do is add the series to Auto Fill's built-in lists.

For example, if you report most operations by sales region (e.g., North America, Southeast Asia, Europe, etc.), you can create a custom fill series for those regions. Follow these steps:

1. Select a column or row that contains the names of the sales regions.

2. Go to Tools | Options.

3. On the Custom Lists tab, you'll see the selected range displayed in the Import List From Cells text box. Click Import, and click OK.

Users can now enter all regions by typing one region and using the Auto Fill feature.

You can also use the Custom Lists dialog box to make entries to a new list. Follow these steps:

1. On the Custom Lists tab of the Options dialog box, select New List.

2. Type each item in the List Entries text box, and press [Enter].

3. After you've entered the entire list, click Add, and click OK.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...