Share this content
AccountingWEB

Excel Tip: Data Entry Shortcut

by
Apr 8th 2012
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.

Replies (1)

Comments for this post are now closed.

avatar
By Data Entry Services
Jun 25th 2015 20:11 EDT

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

Thanks (0)