asked on

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?

Thank you.

Subodh Tiwari (Neeraj)

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?

tmckinney01

ASKER

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.

Subodh Tiwari (Neeraj)

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.

ASKER CERTIFIED SOLUTION