Excel Tip: Data Entry Shortcut

Share this content

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
By David Ringstrom, CPA
If you find yourself making repetitive entries into an Excel spreadsheet, press Alt-Down to view a drop-down list of previous entries in the current column.
Arrow down the list and press Enter to make a selection.
Keep in mind that this technique works with text only, not numbers, and your cursor must be in or adjacent to a contiguous block of non-blank cells.
Read more articles by David Ringstrom. 
About the author:

David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at [email protected] or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.


Please login or register to join the discussion.

This is a great tip about data entry shortcut using Excel. Those users will surely find this information helpful. Thanks for sharing.