How to enter a two line column heading in excel

I am trying to learn excel 2003. How do I enter a two line column heading? I
don't want a double wide column for a couple digit entry under it, but when I
hit enter, it of course enters the data into the cell instead of returning to
the next line as in word processing.
Also, when I enter a formula that I want to continue in a column through its
entire length, what characters do I use? Is there a fill down command for
this?

Hold Dow the [Alt] key when you press Enter. That will insert a "carriage
return".

Regards,
Ron

"Sharon" wrote:

> I am trying to learn excel 2003. How do I enter a two line column heading? I
> don't want a double wide column for a couple digit entry under it, but when I
> hit enter, it of course enters the data into the cell instead of returning to
> the next line as in word processing.
> Also, when I enter a formula that I want to continue in a column through its
> entire length, what characters do I use? Is there a fill down command for
> this?

Sharon wrote:
> snip<
> Also, when I enter a formula that I want to continue in a column through its
> entire length, what characters do I use? Is there a fill down command for
> this?

High lite the cell and put the cursor in the lower right hand corner.
It will turn into a + drag the + down the column.

gls858

or if you have values in the column to the right or left of your formulas,
simply double clicking on the + will fill the formula down.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"gls858" <[email protected]> wrote in message
news:[email protected]...
> Sharon wrote:
>> snip<
>> Also, when I enter a formula that I want to continue in a column through
>> its entire length, what characters do I use? Is there a fill down command
>> for this?
>
> High lite the cell and put the cursor in the lower right hand corner.
> It will turn into a + drag the + down the column.
>
> gls858

JulieD wrote:
> or if you have values in the column to the right or left of your formulas,
> simply double clicking on the + will fill the formula down.
>
Learn something new everyday. Didn't know it would do that.
I'm sure your tip will come in handy. Thanks.

gls858

saves HEAPS of time
(that and the right mouse click drag to do the edit / paste special - values
thing)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"gls858" <[email protected]> wrote in message
news:%[email protected]...
> JulieD wrote:
>> or if you have values in the column to the right or left of your
>> formulas, simply double clicking on the + will fill the formula down.
>>
> Learn something new everyday. Didn't know it would do that.
> I'm sure your tip will come in handy. Thanks.
>
> gls858

"Ron Coderre" wrote:

> Hold Dow the [Alt] key when you press Enter. That will insert a "carriage
> return".
>
> Regards,
> Ron
>
> "Sharon" wrote:
>
> > I am trying to learn excel 2003. How do I enter a two line column heading? I
> > don't want a double wide column for a couple digit entry under it, but when I
> > hit enter, it of course enters the data into the cell instead of returning to
> > the next line as in word processing.
> > Also, when I enter a formula that I want to continue in a column through its
> > entire length, what characters do I use? Is there a fill down command for
> > this?

Thanks Ron, that's exactly what I needed
Sharon

"Ron Coderre" wrote:

> Hold Dow the [Alt] key when you press Enter. That will insert a "carriage
> return".
>
> Regards,
> Ron
>
> "Sharon" wrote:
>
> > I am trying to learn excel 2003. How do I enter a two line column heading? I
> > don't want a double wide column for a couple digit entry under it, but when I
> > hit enter, it of course enters the data into the cell instead of returning to
> > the next line as in word processing.
> > Also, when I enter a formula that I want to continue in a column through its
> > entire length, what characters do I use? Is there a fill down command for
> > this?

Thanks for the tips!
Sharon

"JulieD" wrote:

> or if you have values in the column to the right or left of your formulas,
> simply double clicking on the + will fill the formula down.
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "gls858" <[email protected]> wrote in message
> news:[email protected]...
> > Sharon wrote:
> >> snip<
> >> Also, when I enter a formula that I want to continue in a column through
> >> its entire length, what characters do I use? Is there a fill down command
> >> for this?
> >
> > High lite the cell and put the cursor in the lower right hand corner.
> > It will turn into a + drag the + down the column.
> >
> > gls858
>
>
>

Thanks for the help!
Sharon

"gls858" wrote:

> Sharon wrote:
> > snip<
> > Also, when I enter a formula that I want to continue in a column through its
> > entire length, what characters do I use? Is there a fill down command for
> > this?
>
> High lite the cell and put the cursor in the lower right hand corner.
> It will turn into a + drag the + down the column.
>
> gls858
>