Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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" wrote in message ... 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 |
#7
|
|||
|
|||
"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? |
#8
|
|||
|
|||
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? |
#9
|
|||
|
|||
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" wrote in message ... 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 |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |