Custom Key word
Can someone help?
how can I creat a custome list of state name? for example, My list contant "Alabama, Maine, Oregon, Minnesota, Florida" when I input the first or first two letter of the state name the rest of the letter will show up, so that I don't need to type the whole state name. (similar to the function that when I type in the date) Can I do that? THANK YOU! |
Custom Key word
Tools Options Edit and check the AutoComplete box.
Then, just for example, in column A enter: Alabama Minnesota Florida Oregon Maine If you then click in A6 and begin to enter Alabama, it will autofill right after the A. -- Gary's Student "L.T." wrote: Can someone help? how can I creat a custome list of state name? for example, My list contant "Alabama, Maine, Oregon, Minnesota, Florida" when I input the first or first two letter of the state name the rest of the letter will show up, so that I don't need to type the whole state name. (similar to the function that when I type in the date) Can I do that? THANK YOU! |
All times are GMT +1. The time now is 03:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com