Hello Excellers and welcome back to another #Excel tip in my 2019 series. Do you need to enter data quickly into your Excel workbook?. Well, this is a great little tip to enable easier data entry and less clicks. Do you need to enter data horizontally across columns rather than down rows in your Excel data sheet. Each time you need to press enter or return the cursor normally moves down one cell right?. Like in the screen cast below?.
- Select the cells you want to enter data into. In my example it is the range of cells A2 to D2.
- Go right ahead and enter your data into the cells one by one, hit enter after each entry as usual.
Now your data entry is complete.
What Next? Want More Tips?
So, if you want more tips then sign up for my Monthly Newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
If you want to see all of the blog posts in the Macro Monday or Formula Friday Series, click on the links below
Do You Need Help With An Excel Problem?.
Finally, I am pleased to announce I have teamed up with Excel Rescue, where you can get help FAST. All you need to do is choose the Excel task that most closely describes what you need to be done. Above all, there is a money back guarantee and similarly Security and Non-Disclosure Agreements. Try It!. Need Help With An Excel VBA Macro?. Of course, you don’t need to ask how to list all files in a directory as it is right here for free.