Using Excel

I was using Excel, and I set up in invoice, it's blank to fill in.  I can't remember; in the description, I want to fill out all the details, but as I start, it should be automatic to move on the second line, third line, fourth line, etc. etc.

How do I feel this in?

Excel
Thank you.
tmckinney01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I want to fill out all the details, but as I start, it should be automatic to move on the second line, third line, fourth line, etc. etc.
It's not clear, at least to me. Would you please elaborate it by giving few examples?
0
tmckinney01Author Commented:
Sure.  When I write down as far the description, it continues on; it runs over Qty., Rate, etc.

What I need is as I type it out it automatically moves over the next line. But it doesn't.

Excel 2
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I am not sure if I have understood your requirement correctly.

But if you are talking about the cursor movement during the data entry, normally cursor movement is controlled by Tab or Enter during the data entry.
When a tab is pressed, the cursor moves to the next column in the same row and when Enter is pressed the cursor moves to the next row or line.

So while you have filled out the description in a cell and you press Tab, the Qty cell will be selected i.e. cursor will move to the Qty cell and so on until you reach the Amount cell and once you fill the amount cell, you may press Enter and your cursor will be moved to the Description cell in the next row or line.

By default hitting Enter will move the cursor to the next row or line, but you may change this default behavior of Enter key press through Excel Options-- > Advanced --> Under Editing options.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Saurabh Singh TeotiaCommented:
Select you cell which is A17 in this case..

Press Ctrl+1 over it-->Then -->Alignment-->In That text Control-->Select first shrink to fit and then wrap text..

This will do what you are looking for...

Enclosed is the screenshot for your reference...

Before i have selected...Before
And after i have selected that Option..It will automatically adjust the cell size basis of data you are adding..

After
Saurabh...
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tmckinney01Author Commented:
Awesome, thank you!!!
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@Saurabh

+1 for getting the question correctly. I completely missed it and now I see what the OP was referring to. :)
0
Saurabh Singh TeotiaCommented:
@sktneer,

Thanks,It happens.. :-)

Saurabh...
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
I think that is where experience counts. :) :) :)
0
Saurabh Singh TeotiaCommented:
Nah not really..At times i get confused what end user is looking for..and i see you get up early part of the day.. :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.