hi, i would like to know how to continue writing in a single cell. i am
compiling a report and have divided my spread sheet into rows and columns.
when i start entering the data(mostly words) and hit the "ENTER" button, the
cursor moves onto the next cell. i want to continue writing in the same cell
because i want to utilise the other cells for some other data. I would like
to know which options to choose so that when i hit the 'ENTER' button, it
just moves to the next line within the same cell and not the nest cell!
PLEASE HELP...i am stuck here!

On Tue, 2 Mar 2010 21:08:01 -0800, Ron
wrote:

hi, i would like to know how to continue writing in a single cell. i am
compiling a report and have divided my spread sheet into rows and columns.
when i start entering the data(mostly words) and hit the "ENTER" button, the
cursor moves onto the next cell. i want to continue writing in the same cell
because i want to utilise the other cells for some other data. I would like
to know which options to choose so that when i hit the 'ENTER' button, it
just moves to the next line within the same cell and not the nest cell!
PLEASE HELP...i am stuck here!

Try holding down the ALT key when you hit ENTER.

Hope this helps / Lars-Åke

use alt-enter

--


Gary Keramidas
Excel 2003


"Ron" wrote in message
...
hi, i would like to know how to continue writing in a single cell. i am
compiling a report and have divided my spread sheet into rows and columns.
when i start entering the data(mostly words) and hit the "ENTER" button,
the
cursor moves onto the next cell. i want to continue writing in the same
cell
because i want to utilise the other cells for some other data. I would
like
to know which options to choose so that when i hit the 'ENTER' button, it
just moves to the next line within the same cell and not the nest cell!
PLEASE HELP...i am stuck here!

To break for a new line in the cell, press Alt + ENTER
Joy? hit the YES below
--
Max
Singapore
---
"Ron" wrote:
hi, i would like to know how to continue writing in a single cell. i am
compiling a report and have divided my spread sheet into rows and columns.
when i start entering the data(mostly words) and hit the "ENTER" button, the
cursor moves onto the next cell. i want to continue writing in the same cell
because i want to utilise the other cells for some other data. I would like
to know which options to choose so that when i hit the 'ENTER' button, it
just moves to the next line within the same cell and not the nest cell!
PLEASE HELP...i am stuck here!