automatic carriage return

T

Tbledsoe

How can I perform an automatic carriage return after entering data in a cell
....
 
G

Gord Dibben

Not automatic, but hit ALT + ENTER to get a new line in a cell.

Excel has no other way to know when you want a carriage return.

Gord Dibben Excel MVP
 
L

L. Howard Kittle

Hi Tbledsoe,

Bernard and Gord pretty much hit the nail on the head, Excel cannot read
your mind. I'm going on a wild guess with this...

Enter data in a cell, hit the TAB and then enter data in that cell, hit TAB
again. Continue entering data using the TAB until you want to go to the
next row and back to just below the first cell in the next row. On the last
entry in the row hit ENTER. Acts like a carriage return on a typewriter.
Then use TAB again until ready for the next row where you would hit ENTER
again.

HTH
Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting text divided by carriage returns 2
HELP! Un-editable Carriage Returns in Footnotes 1
Parse Before Line Break 3
Hard carriage return at the end of cell 2
Request help determining line length and end of line carriage returnsthrough document 0
data spans multiple rows within each cell is collapsed when FILTER is used 0
Enter carriage return in Excel 2010 text string 2
Automatic Carriage Return 2

Top