Microsoft Monday Tip

by Erin Banister

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Here’s your Weekly [tag]Microsoft Monday Tip[/tag]

Creating [tag]Custom Lists[/tag] in [tag]Microsoft Excel[/tag]

If you find yourself frequently entering the same data into a worksheet, like vendors, you can create a custom list by going to Tools>Options and selecting the ‘Custom Lists’ tab. Enter the list in the list entries pane (one at a time) and click add. (Alternatively, you can import the list from cells if they’re already in the workbook.) Then, when it comes time to enter the list in your worksheet, just enter any of the list entries in a cell and dragging the fill handle to fill other cells with the remainder of the enteries.

~E

No tags for this post.