Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below.
We recently updated our Terms and Conditions for TechRepublic Premium. By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
You will also receive a complimentary subscription to TechRepublic’s News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.
Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
How to enter data quickly in Excel
Your email has been sent
Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren’t available.
Your summarizations, analyses, projections, reports and so on, are only as good as your data. It’s important that you use every resource available to protect the validity of the data, which means you can spend a lot of time creating an app that’s nearly foolproof. Fortunately for us, not every spreadsheet needs that kind of protection and when that happens, there are automated features in Microsoft Excel that help protect data. In this article, I’ll show you two quick and easy data entry tricks that will reduce typos the same way customization will, but without the extra work.
SEE: 69 Excel tips every user should master (TechRepublic)
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can work with earlier versions. You can use the demonstration downloadable .xlsx or .xls file or work with your own data. AutoComplete works in the online version but the pick list doesn’t
The term AutoComplete shows up often in feature lists—it’s easy to guess what it does even if you’re not familiar with it in Excel. This feature kicks in as soon as you enter contiguous values, in any direction. Even if you’re familiar with AutoComplete, I’ll bet you didn’t now that last part. The feature is extremely versatile.
Here’s how AutoComplete works in Excel: When you enter a character that matches an existing value in a contiguous range, this feature will display matching values. As long as there’s a bit of ambiguity, you have to keep entering characters. Let’s run a couple of examples though the simple sheet in Figure A.
First, enter the letter D in cell B8 and watch what happens. As shown in Figure A, AutoComplete completes the entry based on the previously entered values (the values above B8). The entry Denise matches the character D, and because no other existing entry also matches the letter D, AutoComplete suggests Denise. To enter Denise, press Enter (or Tab if you want to move to the next column instead of moving down to the next row). To reject the suggested entry, keep typing. Press Escape to remove everything, including the D you typed.
Let’s try another example, this time type Su. Were you expecting something? In this case, AutoComplete does nothing because there aren’t enough characters to select Susan or Sue. If you enter S, AutoComplete offers Susan. If you enter e, AutoComplete does nothing.
SEE: Windows 10: Lists of vocal commands for speech recognition and dictation (free PDF) (TechRepublic)
Try entering a value to the right, left, and even above. This feature will work in all four directions.
To disable AutoComplete, click the File menu and choose Options (or More if you don’t see Options). Choose Advanced in the left pane. In the Editing Option section, uncheck the Enable AutoComplete for Cell Values option shown in Figure B. Unfortunately, doing so also disables Flash Fill, which is a powerful tool that you’ll probably want to keep. To learn more about using Flash Fill, read 6 ways to save time using Flash Fill in Microsoft Excel.
Sometimes you won’t want a match. Instead, you’ll want to see a unique list. When this is the case use a pick list.
When entering contiguous values in a single column, you can also use a pick list—a built-in feature that displays a unique list of existing values. It’s similar to a dropdown list but it’s completely automated. The only thing you must do is press Alt + Down Arrow to see it. Then, select an item in the list to populate the active cell. Let’s try it! Select B8 and press Alt + Down Arrow to see the pick list shown in Figure C.
If the active cell has content, this feature will write over it if you select a list item. Remember that you can use Ctrl + z to undo that action. You can display the pick list above the list, but not to the right or left, even if multiple value exists in those directions.
Neither feature will keep you or a user from choosing a wrong value, but you’ll be increasing productivity a a bit and avoiding typos. If you’d like to learn more Excel data entry tricks, read How to reduce data input and typos in Excel.
How to enter data quickly in Excel
Your email has been sent
Your message has been sent
Google Tasks has never had a solid interface … until now. Jack Wallen shows you how to turn Tasks into a kanban board-like workflow with the help of TasksBoard.
Don’t pack your bags and move to Bozeman yet. This micro-scale warp bubble won’t be capable of propulsion, but it could have myriad other applications, says its discoverer Dr. Sonny White.
If you’re not certain whether your Java project is free from Log4j vulnerabilities, you should try this easy-to-use scanning tool immediately.
If you missed in-person tech events in 2020 and 2021, here’s some good news: It’s looking promising that in 2022 many conferences will get back to (almost) normal.
The comprehensive bundle covers a range of subjects, including app development, game development, machine learning, computer vision, deep learning, NFTs, Java and website building.
Storage has always been a key aspect of data management in the enterprise. Now, in the era of big data, understanding storage options and technologies has taken on an even greater significance. This glossary offers essential terms that will help you tune up your storage vocabulary. From the glossary: Cloud storage Cold storage is the …
Electronic data is likely to be more prevalent in today’s organizations than physical printed data. Reams worth of documents can now be stored on computer hard drives, handheld devices and storage cards smaller than a fingernail. The bulk of many strategic operations depend on this digital information and the safe handling thereof. Data often has …
The concept of a metaverse, or a computer-generated universe, has been around for decades, certainly longer than when it was recently commandeered by Mark Zuckerberg in his attempt to rebrand Facebook as a new company called Meta. Massively multiplayer games, which can be classified as early metaverses, have been widely available to the gaming public …
The OneDrive Cloud Usage Policy from TechRepublic Premium defines the practices and behaviors organization representatives must follow when using any Microsoft OneDrive Cloud file storage account to execute organization services, process organization data, or access or store organization information. Whether organization representatives access Microsoft OneDrive file storage capabilities using an organization-provided, organization-reimbursed or personal OneDrive …