00:00In Excel, you can view auto-complete lists by using the alternate and the down key.
00:04This will give you the list of all the items that's found on column B.
00:08This is the same list that Excel uses when you do auto-complete.
00:12If I type pair, you can see it automatically completes it for you.
00:15I also use this for when I have a question saying, let's say, a fruit starting with B.
00:20I press alt down, and you can see they're in alphabetical order, and I select any fruit that starts with B.
00:26Another use case of auto-complete lists is to do a spell check.
00:29Let's say, for example, if you go down and select C, and you press F7 here, you can see that Excel says that all your spellings are good.
00:36But if you go here and select alt, arrow down, you can see there's some spelling mistakes here.
00:41What you do after that to fix it will be ctrl H, and in here, you're going to type your error spelling, and then follow up by that, and click OK.
00:50And five replacement has been made, and that's how you correct the spelling mistakes as well with this.
00:54Auto-complete list does not work on columns with numbers.
00:57Like, for example, if you go here and press alternate down here, you see it doesn't show anything in here.
01:03If you have enable filter on your table, you can also use the same hotkey.
01:08Let's say I'm going to press ctrl shift L to enable filter on my header.
01:12Over here, you select your header and press alternate down.
01:15It will show you your filter context menu.
01:17And then, let's say, whatever else you're going to pull at it.
01:22Let's say I'm going to pull out a single question.
01:22Remember, if I'm going to pressteok right now?
01:24See if I give you three will come back.
01:28It will slowly�� get back.
01:37Well, let's say I can move you on the one.
01:39Would you Casey will not demonstrate?
01:42It will source your daily log to on your table.
Comments