Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adjusting Cell Margins (W2K / Excel 2K, SR1)

    Does anyone know how to adjust the cell margins in Excel? By this I mean the distance that the text is set off from the edge of the cell.

    In Word, one accomplishes this in a table by Table -> Table Properties -> Options... (see attached GIF).
    Attached Images Attached Images
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adjusting Cell Margins (W2K / Excel 2K, SR1)

    Al

    Excel has no generic equivalent. However, it does set spacing as follows:

    a) in a general format, the spacing is effectively 0
    [img]/forums/images/smilies/cool.gif[/img] in a numeric format, the character "_" reserves a space to hold a character
    e.g _-$* #,##0_-;-$* #,##0_-;_-$* "-"_-;_-@_-
    specifies that this number format reserve a space big enough to hold a minus sign in front of the dollar and at the end of the number

    In full, the whole string says
    * reserve such spaces if the number is positive
    * use a real minus in front of the number if negative
    * reserve spaces and print a hyphen if zero
    * reserve spaces around text

    Accordingly, you can specify spacing in a limited way by specifying a custom cell format. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adjusting Cell Margins (W2K / Excel 2K, SR1)

    Format | Cells | Alignment | Indent
    is the easiest, but probably too large an indent for you, and only for left alignment. More options in XL2002.

    You should be able to use a custom format to get smaller indents:
    <pre>_-#_X;-#_X</pre>

    where the width of X is the width of the indent, ie, you can use I for a much smaller indent, but this dosn't work for me in XL97. HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Upstate, South Carolina, USA
    Posts
    253
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adjusting Cell Margins (W2K / Excel 2K, SR1)

    Andrew and Sam,

    Many thanks for your information and suggestions. I didn't know about the special space character in Custom format. It looks, however, like it'll only function as a first_line_indent or a single forced space. Sam, you're correct even "1" is a pretty large indent.

    Now, of course, the way to solve this is a huge kludge. Create extra rows and columns without borders and use them as margins.

    Oh well, it a shame that the Office development groups don't use a or a larger shared code library of "features."
    Al
    "Do or do not do. There is no try." -- Yoda
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •