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

Posted on February 22, 2008
Filed Under Excel Tips & Tricks, Reader Questions

In the last couple of months we’ve covered some really cool Excel Tips and Tricks. But more important some of these Excel Tips and Tricks were really useful and will save you lots of time. Some of my personal favorite Excel Tips and Tricks are the Excel formula’s that we used to count all the empty cells, the one to automatically highlight the weekdays, and the Trick for Excel telling you your input so you can check your data. You can imagine that I would publish the Tips and Tricks first that I’m using most often. This is why I was a bit surprised when Danielle send me an e-mail if I could make a tutorial for her with a small explanation about the use of auto-form’s in Microsoft Excel. I’m using the drop down menus in Microsoft Excel quite often and they are real handy, they will save you lots of time so it was quite surprising that I didn’t cover it earlier but if you ask me; better late than never;).

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.

Excel-tip-trick-pic1

· 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.

Danielle I hope this Tip and Trick will help you. It’s a huge time saver and I use this Excel Tip and Trick pretty much always. I hope you all liked it and I’ll talk to you all on Monday, enjoy the weekend!!

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.