Work Faster With a Drop Down List For Auto Filling Your Cells

Here’s an Excel Tutorial to show a drop down list to auto fill your cells.

· First you’ll need to select the cell that you want to auto fill (in this case B7)
· Press ALT+DOWN ARROW

Now a list should appear with all the entries from your B column.

· If you now release the buttons then you can use the UP- and DOWN ARROW.
· Select your entry this way.
· And press ENTER

And you’re done.