strange excel question

[Christo]

i am doing something in a pre designed excel spreadsheet

I have a column a cell where i am entering the following data.

Enter the weight of each item below. To finish calculating enter the
value 0.


after the word "Below" i press the ENTER key, to make the rest of the text
go onto the next line, this doesn't happen and it goes down to the next cell

can anyone tell me how i can make the text after the word "belo" appear on a
new line within the same cell

I am using Office XP


this is for a dry run table of a c++ program i have developed, ironic how a
student in advanced programming cant figure out how to put text in a cell
onto a new line in the same cell

it is because the particular cell is too wide i need it so i can print this
out on one sheet of A4 and having to stretch this particular cell to fit
that text means i cannot do this

so anyone got any suggestions i would greatly appreciate it

Thanks

Chris

[William]

Hi

After you have entered the word "below", press "Alt" and "Enter"
simultaneously rather than "Enter" on its own.

--
XL2002
Regards

William

willwest22@yahoo.com

"Christo" <chris@juststuffd.co.uk> wrote in message
news:348kaiF490cetU1@individual.net...
| i am doing something in a pre designed excel spreadsheet
|
| I have a column a cell where i am entering the following data.
|
| Enter the weight of each item below. To finish calculating enter the
| value 0.
|
|
| after the word "Below" i press the ENTER key, to make the rest of the text
| go onto the next line, this doesn't happen and it goes down to the next
cell
|
| can anyone tell me how i can make the text after the word "belo" appear on
a
| new line within the same cell
|
| I am using Office XP
|
|
| this is for a dry run table of a c++ program i have developed, ironic how
a
| student in advanced programming cant figure out how to put text in a cell
| onto a new line in the same cell
|
| it is because the particular cell is too wide i need it so i can print
this
| out on one sheet of A4 and having to stretch this particular cell to fit
| that text means i cannot do this
|
| so anyone got any suggestions i would greatly appreciate it
|
| Thanks
|
| Chris
|
|

[Christo]

>
> After you have entered the word "below", press "Alt" and "Enter"
> simultaneously rather than "Enter" on its own.
>
> --
> XL2002
> Regards

haha thnks a load man, I remember doing that in college now.. funny how
thing ilude your mind

[Ken Wright]

Gets worse as you get older I assure you :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Christo" <chris@juststuffd.co.uk> wrote in message
news:348o1gF479bcvU1@individual.net...
>
> >
> > After you have entered the word "below", press "Alt" and "Enter"
> > simultaneously rather than "Enter" on its own.
> >
> > --
> > XL2002
> > Regards
>
> haha thnks a load man, I remember doing that in college now.. funny how
> thing ilude your mind
>
>