Tags: column, columns, consecutive, course, excel, insert, inserted, microsoft, msdn, order, shee, software, space, worksheet

How do I insert space between 2 consecutive columns of an XL Shee.

On Microsoft » Microsoft Excel

1,945 words with 4 Comments; publish: Thu, 22 May 2008 20:50:00 GMT; (306217.77, « »)

I want to have space between two consecutive columns of a worksheet (of

course, without having inserted another column between the two) in order to

have separated the Border Lines of the adjacent cells/columns. Please guide

me if it can be done in XL.

All Comments

Leave a comment...

  • 4 Comments
    • Can you achieve the effect that you're looking for by using a double

      vertical border down the right side of the left column and having no

      border down the left side of the right column?

      Rgds,

      ScottO

      "Shamshad Butt" <Shamshad Butt.excel.questionfor.info.discussions.microsoft.com> wrote in

      message news:1222EE13-11A9-4354-9F12-D1F1155D3902.excel.questionfor.info.microsoft.com...

      | I want to have space between two consecutive columns of a worksheet

      (of

      | course, without having inserted another column between the two) in

      order to

      | have separated the Border Lines of the adjacent cells/columns.

      Please guide

      | me if it can be done in XL.

      #1; Thu, 22 May 2008 20:51:00 GMT
    • I don't think it can be done, but if you apply a double line as a vertical

      border between the two columns, it has a similar effect.

      Stefi

      â'Shamshad Buttâ' ezt írta:

      > I want to have space between two consecutive columns of a worksheet (of

      > course, without having inserted another column between the two) in order to

      > have separated the Border Lines of the adjacent cells/columns. Please guide

      > me if it can be done in XL.

      #2; Thu, 22 May 2008 20:52:00 GMT
    • Dear ScottO

      Thanks for your help. Yours tip was fine but it will help only a little. In

      fact I want to create separate BOXES with clear SEPARATION.

      #3; Thu, 22 May 2008 20:53:00 GMT
    • Hi

      You could try Format>Cells>Alignment\>Horizontal>Right Indent and set the

      indent to as many characters as you wish.

      Regards

      Roger Govier

      Shamshad Butt wrote:

      > Dear ScottO

      > Thanks for your help. Yours tip was fine but it will help only a little. In

      > fact I want to create separate BOXES with clear SEPARATION.

      #4; Thu, 22 May 2008 20:54:00 GMT