How to enter a two line column heading in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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.
 
JulieD said:
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.
Click to expand...
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)
 
Ron Coderre said:
Hold Dow the [Alt] key when you press Enter. That will insert a "carriage
return".

Regards,
Ron

Sharon said:
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?
Click to expand...
Click to expand...
 
Thanks Ron, that's exactly what I needed
Sharon

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

Regards,
Ron

Sharon said:
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?
Click to expand...
Click to expand...
 
Thanks for the help!
Sharon

gls858 said:
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
Click to expand...
 
Back
Top