strange excel question

  • Thread starter Thread starter Christo
  • Start date Start date
C

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
 
Hi

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

--
XL2002
Regards

William

(e-mail address removed)

| 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
|
|
 
After you have entered the word "below", press "Alt" and "Enter"
simultaneously rather than "Enter" on its own.
Click to expand...

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