How to enter several values separated by return key in a cell

  • Thread starter Thread starter Jane Humbrey
  • Start date Start date
J

Jane Humbrey

Hi Guys

G'day. I want to enter alpha, beta, gamma in an excel cell one by like :

Alpha(return key press)
Gamma(return key press)
Beta(return key press)
Zita

inside a single excel cell. But I couldn't. When I press the return key
after I entered the value Alpha it goes to next cell. How can we overcome
this and enter several values in one cell?

Thank you.

Jane
 
Just hit the space bar instead of enter.

But why would you want to do this?

--
Ken Russell

| Hi Guys
|
| G'day. I want to enter alpha, beta, gamma in an excel cell one by like :
|
| Alpha(return key press)
| Gamma(return key press)
| Beta(return key press)
| Zita
|
| inside a single excel cell. But I couldn't. When I press the return key
| after I entered the value Alpha it goes to next cell. How can we overcome
| this and enter several values in one cell?
|
| Thank you.
|
| Jane
|
|
 
Hi Jane

Alt Enter will insert a "line feed" (ascii character 10).
 
Presumably you have formatted the cell to Wrap Text with Top alignment
- when Alt + Enter does what you wish.

REgards
BrianB
======================================================
 
Thanks Brian. It worked.

Regards
Jane


BrianB said:
Presumably you have formatted the cell to Wrap Text with Top alignment
- when Alt + Enter does what you wish.

REgards
BrianB
======================================================


"Ken Russell" <[email protected]> wrote in message
Click to expand...
 
Hi Guys

It worked. But we need to format the cell to Wrap Text with Top alignment.
Thanks a lot.

Regards
Jane
 
Hi Ken

No, it didn't work. But I found the way.
We need to format the cell to Wrap Text with Top alignment and hit the
Alt+Enter key to enter those values. To keep the values related to a row I
want to do this.Thanks a lot.

Cheers
Jane
 
Hi Ken

No, it didn't work. But I found the way.
We need to format the cell to Wrap Text with Top alignment and hit the
Alt+Enter key to enter those values. To keep the values related to a row I
want to do this.Thanks a lot.

Cheers
Jane
 
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

Grouping rows based on like data in a cell and then separating them 2
Find text and enter in new cell 4
Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
enter key behavior - by sheet 4
Last Modified By in a cell by user 3
Where was I before pressing enter/return or tab key 1
How to enter start and end date/time in excel based on some specific value. 7
Populate cell with multiple non-blank text values 3

Back
Top