Save time on data entry in Excel

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 2000 and other Software topics.

How can I speed up data entry in Excel?

Save time on data entry in Excel

If you find yourself typing the same information a number of times in the same column, Excel has a really useful 'pick from list' feature which can save you loads of time.

If you right click the cell where you want to enter data, there is an option called Pick From List. This will bring up a list of all entries above the cell (in the same column) and you can select the relevant one.

The same thing can be achieved by holding down the Alt key and pressing the down arrow. Please note - neither of the above will function correctly if there are blank rows in your data.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Carma Spence-Pothitt