Excel Tip: Data Entry Shortcut

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 david@acctadv.com or follow him on Twitter. David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link.

 


Already a member? log in here.

Editor's Choice