How to Retrieve Information in Excel 2007 With a Custom List
A good way to retrieve information in Excel 2007 is with a custom list. There are already lists in Excel. If you type Jan into a cell and pull the copy handle, the rest of the months will fill in. You can create your own custom lists, and make whatever you want fill in. Oh, and hey… if you’re in the market for some Denver IT Support, we’d love to help you!
Let’s say you do parts ordering for your company. Instead of looking up vendor numbers, you want the vendor number to appear next to your part number.
Open a new worksheet in Excel 2007. You want the custom list to be out of the way; click in a cell that’s far to the right, say T1. Before you type anything… Continue reading...
