Tags: adding, border, cell, dear, diagonal, excel, fomat, microsoft, msdn, parts, separate, separation, software, text

Cell Separation

On Microsoft » Microsoft Excel

9,721 words with 8 Comments; publish: Wed, 04 Jun 2008 15:08:00 GMT; (306140.63, « »)

Dear all,

I want to separate a cell into two parts. I can do this by adding a diagonal

from "Fomat/Cell/Border". However, when I want to add text into two separate

parts, it cannot be done. The problem is the text description cannot be

separated into upper portion and lower portion as I expected. Can it be done

and how? Please advise.

Thanks.

All Comments

Leave a comment...

  • 8 Comments
    • You can have two lines of text in a cell by typing a few characters and then

      Alt-Enter and then some more characters which will be on the second line.

      If you preceed the second row characters it will move them to the lower

      right corner of the cell and the first line characters will be in the upper

      left area of the cell........then a right-to-left diagonal border as

      you've described will separate the cell and produce the visual effect you

      are looking for..........

      Vaya con Dios,

      Chuck, CABGx3

      "Freshman" <Freshman.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:43AC6AAE-C68E-4046-A57C-7D6A3EFD022E.excel.todaysummary.com.microsoft.com...

      > Dear all,

      > I want to separate a cell into two parts. I can do this by adding a

      diagonal

      > from "Fomat/Cell/Border". However, when I want to add text into two

      separate

      > parts, it cannot be done. The problem is the text description cannot be

      > separated into upper portion and lower portion as I expected. Can it be

      done

      > and how? Please advise.

      > Thanks.

      #1; Wed, 04 Jun 2008 15:09:00 GMT
    • Hi CLR,

      I cannot get the effect by following your gudieline. Have I missed anything?

      My steps are:

      Type: "Freshman" in a cell, then press Alt Enter;

      Type: "CLR" in the second line, then press Enter.

      The two lines of text still align on the left hand side and didn't separate

      as you've described. Please kindly tell me if my steps have missed something.

      Many thanks.

      "Freshman" wrote:

      > Dear all,

      > I want to separate a cell into two parts. I can do this by adding a diagonal

      > from "Fomat/Cell/Border". However, when I want to add text into two separate

      > parts, it cannot be done. The problem is the text description cannot be

      > separated into upper portion and lower portion as I expected. Can it be done

      > and how? Please advise.

      > Thanks.

      #2; Wed, 04 Jun 2008 15:10:00 GMT
    • Assuming your diagonal format for the cell

      is from top left to bottom right

      instead of :

      > Type: "Freshman" in a cell, then press Alt Enter;

      Type a few spaces (use the spacebar) before you type "Freshman", i.e. use

      the spaces to push "Freshman" a little to the right, then press Alt Enter

      and then just follow through with your

      > Type: "CLR" in the second line, then press Enter.

      You'd need to manually adjust the spacing a little after viewing how it

      looks with the diagonal drawn in

      And if your diagonal is running the other way, do the spacing for the 2nd

      text line in the cell instead of the 1st

      Keep the alignment for the cell on the left

      --

      Rgds

      Max

      xl 97

      --

      Singapore, GMT+8

      xdemechanik

      http://savefile.com/projects/236895

      --

      "Freshman" <Freshman.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:7210909E-2F9C-468E-9EAF-4D4F6E754E54.excel.todaysummary.com.microsoft.com...

      > Hi CLR,

      > I cannot get the effect by following your gudieline. Have I missed

      anything?

      > My steps are:

      > Type: "Freshman" in a cell, then press Alt Enter;

      > Type: "CLR" in the second line, then press Enter.

      > The two lines of text still align on the left hand side and didn't

      separate

      > as you've described. Please kindly tell me if my steps have missed

      something.

      > Many thanks.

      #3; Wed, 04 Jun 2008 15:11:00 GMT
    • Hi Max,

      Thanks again. Your method works. Cheers.

      "Max" wrote:

      > Assuming your diagonal format for the cell

      > is from top left to bottom right

      > instead of :

      > > Type: "Freshman" in a cell, then press Alt Enter;

      > Type a few spaces (use the spacebar) before you type "Freshman", i.e. use

      > the spaces to push "Freshman" a little to the right, then press Alt Enter

      > and then just follow through with your

      > > Type: "CLR" in the second line, then press Enter.

      > You'd need to manually adjust the spacing a little after viewing how it

      > looks with the diagonal drawn in

      > And if your diagonal is running the other way, do the spacing for the 2nd

      > text line in the cell instead of the 1st

      > Keep the alignment for the cell on the left

      > --

      > Rgds

      > Max

      > xl 97

      > --

      > Singapore, GMT+8

      > xdemechanik

      > http://savefile.com/projects/236895

      > --

      > "Freshman" <Freshman.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:7210909E-2F9C-468E-9EAF-4D4F6E754E54.excel.todaysummary.com.microsoft.com...

      > > Hi CLR,

      > >

      > > I cannot get the effect by following your gudieline. Have I missed

      > anything?

      > > My steps are:

      > >

      > > Type: "Freshman" in a cell, then press Alt Enter;

      > > Type: "CLR" in the second line, then press Enter.

      > >

      > > The two lines of text still align on the left hand side and didn't

      > separate

      > > as you've described. Please kindly tell me if my steps have missed

      > something.

      > >

      > > Many thanks.

      >

      >

      #4; Wed, 04 Jun 2008 15:12:00 GMT
    • The only thing you missed is how to read in MY sleep <g>.........I swear

      my response looked good to me last night just before I went to bed......but

      it sure didn't this morning. I see Max did come to my rescue and got you on

      the straight and narrow tho.......thanks Max... ...just typing leading

      spaces to either the top or bottom line, depending on which way the diagonal

      goes, will move that line's characters over to the right end of the cell.

      I do sincerely apologize for that first criptic response.

      Vaya con Dios,

      Chuck, CABGx3

      "Freshman" <Freshman.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:7210909E-2F9C-468E-9EAF-4D4F6E754E54.excel.todaysummary.com.microsoft.com...

      > Hi CLR,

      > I cannot get the effect by following your gudieline. Have I missed

      anything?

      > My steps are:

      > Type: "Freshman" in a cell, then press Alt Enter;

      > Type: "CLR" in the second line, then press Enter.

      > The two lines of text still align on the left hand side and didn't

      separate

      > as you've described. Please kindly tell me if my steps have missed

      something.

      > Many thanks.

      > "Freshman" wrote:

      > > Dear all,

      > >

      > > I want to separate a cell into two parts. I can do this by adding a

      diagonal

      > > from "Fomat/Cell/Border". However, when I want to add text into two

      separate

      > > parts, it cannot be done. The problem is the text description cannot be

      > > separated into upper portion and lower portion as I expected. Can it be

      done

      > > and how? Please advise.

      > >

      > > Thanks.

      #6; Wed, 04 Jun 2008 15:14:00 GMT
    • Hi Chuck,

      Thanks for your assistance too. I really appreciate your help. Thanks again.

      Freshman

      "CLR" wrote:

      > The only thing you missed is how to read in MY sleep <g>.........I swear

      > my response looked good to me last night just before I went to bed......but

      > it sure didn't this morning. I see Max did come to my rescue and got you on

      > the straight and narrow tho.......thanks Max... ...just typing leading

      > spaces to either the top or bottom line, depending on which way the diagonal

      > goes, will move that line's characters over to the right end of the cell.

      > I do sincerely apologize for that first criptic response.

      > Vaya con Dios,

      > Chuck, CABGx3

      >

      > "Freshman" <Freshman.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      > news:7210909E-2F9C-468E-9EAF-4D4F6E754E54.excel.todaysummary.com.microsoft.com...

      > > Hi CLR,

      > >

      > > I cannot get the effect by following your gudieline. Have I missed

      > anything?

      > > My steps are:

      > >

      > > Type: "Freshman" in a cell, then press Alt Enter;

      > > Type: "CLR" in the second line, then press Enter.

      > >

      > > The two lines of text still align on the left hand side and didn't

      > separate

      > > as you've described. Please kindly tell me if my steps have missed

      > something.

      > >

      > > Many thanks.

      > >

      > > "Freshman" wrote:

      > >

      > > > Dear all,

      > > >

      > > > I want to separate a cell into two parts. I can do this by adding a

      > diagonal

      > > > from "Fomat/Cell/Border". However, when I want to add text into two

      > separate

      > > > parts, it cannot be done. The problem is the text description cannot be

      > > > separated into upper portion and lower portion as I expected. Can it be

      > done

      > > > and how? Please advise.

      > > >

      > > > Thanks.

      >

      >

      #8; Wed, 04 Jun 2008 15:16:00 GMT