automatic carriage return

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I perform an automatic carriage return after entering data in a cell
....
 
And how will Excel know that you have finished data entry?
 
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
 
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
 
You must log in or register to reply here.

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
Parse Before Line Break 3
Excel: How to insert carriage returns in a formula to manipulate t 1
Carriage returns in the formula bar? 4
Split data in field on character return 0
how to copy excel carriage return to notepad w/out the quotations 4
Removing Mulitple Carriage Returns Within a Concantenate Formula 2
Text to columns delimited by carriage return 2

Back
Top