There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

To split cell and meger cells there is a check box in the formatt menu in the
allignment Tab. You can aways use tthis method of merging and splitinhg
cells.

Excell automatically hides items on the toolbar when these item arren't
used. You can get the missing item by clicking on the double-right arrrows
in the toolbar. My toolbar has 3 sets of these double right arrows. I don't
like when Excel hides items on the toolbar either.

"Doc Secretary" wrote:

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

No version of Excel has allowed you to split a cell into two separate cells.

You can use the line tool.........to the right of "Autoshapes" from the drawing
toolbar to draw a line through the middle of a cell, but it remains one cell.


Gord Dibben MS Excel MVP


On Fri, 23 Feb 2007 09:33:10 -0800, Doc Secretary <Doc
wrote:

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

Joel

Please describe how to split a cell.

I keep stating it is impossible but have been known to be wrong.


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:42:08 -0800, Joel wrote:

To split cell and meger cells there is a check box in the formatt menu in the
allignment Tab. You can aways use tthis method of merging and splitinhg
cells.

Excell automatically hides items on the toolbar when these item arren't
used. You can get the missing item by clicking on the double-right arrrows
in the toolbar. My toolbar has 3 sets of these double right arrows. I don't
like when Excel hides items on the toolbar either.

"Doc Secretary" wrote:

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

You are right you cant split the default cell in excel. You first have to
merge two cells together. Then you can split the cells to return them back
to there normal condition.

Merging cells can be done in the format - Cell - allign menu. therre is a
check box to perform a merge. Uncheck the box to split. I think the term
spilt is better than Un-Merge.

"Gord Dibben" wrote:

Joel

Please describe how to split a cell.

I keep stating it is impossible but have been known to be wrong.


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:42:08 -0800, Joel wrote:

To split cell and meger cells there is a check box in the formatt menu in the
allignment Tab. You can aways use tthis method of merging and splitinhg
cells.

Excell automatically hides items on the toolbar when these item arren't
used. You can get the missing item by clicking on the double-right arrrows
in the toolbar. My toolbar has 3 sets of these double right arrows. I don't
like when Excel hides items on the toolbar either.

"Doc Secretary" wrote:

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?

Thank you.

Gord

On Fri, 23 Feb 2007 12:26:05 -0800, Joel wrote:

You are right you cant split the default cell in excel. You first have to
merge two cells together. Then you can split the cells to return them back
to there normal condition.

Merging cells can be done in the format - Cell - allign menu. therre is a
check box to perform a merge. Uncheck the box to split. I think the term
spilt is better than Un-Merge.

"Gord Dibben" wrote:

Joel

Please describe how to split a cell.

I keep stating it is impossible but have been known to be wrong.


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:42:08 -0800, Joel wrote:

To split cell and meger cells there is a check box in the formatt menu in the
allignment Tab. You can aways use tthis method of merging and splitinhg
cells.

Excell automatically hides items on the toolbar when these item arren't
used. You can get the missing item by clicking on the double-right arrrows
in the toolbar. My toolbar has 3 sets of these double right arrows. I don't
like when Excel hides items on the toolbar either.

"Doc Secretary" wrote:

There used to be a pencil on my drawing toolbar that would allow me to draw a
line in a cell that would split it into two separate cells. How do I get
that function back? We recently installed Office 2003 at work, was this
function removed from this new version?