+ Reply to Thread
Results 1 to 9 of 9

Cell Inset?

  1. #1
    Registered User
    Join Date
    08-19-2005
    Posts
    4

    Cell Inset?

    Is there a way to set a cell inset (space between text and cell border)? I would think it would be simple but I can't find it anywhere.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451
    I'm guessing that you mean indenting from the left edge of the cell. If so then go to Format>Cell>Alignment
    Under "Horizontal" choose "Left (Indent)"
    Now specify the amount of indentation using the spinner control labelled "Indent:"

  3. #3
    JE McGimpsey
    Guest

    Re: Cell Inset?

    one way:

    Format/Cells/Alignment/Indent and choose an indent level to set space
    between the left border and the text.


    You can customize the space, too:

    Use the underscore character in a Custom format. This will leave a space
    equal to the width of whatever follows it.

    For example, Format/Cells/Number/Custom _|_|@

    will leave the width of two pipes to the left of the text (@).

    In article <[email protected]>,
    davewill <[email protected]>
    wrote:

    > Is there a way to set a cell inset (space between text and cell border)?
    > I would think it would be simple but I can't find it anywhere.


  4. #4
    Registered User
    Join Date
    08-19-2005
    Posts
    4
    I'm actually looking for a feature that will create space on all four sides so that the text isn't up against the top and bottom also. Rows are different sizes so to use the row height feature I would have to choose each one seperatly and set the height. In InDesign I can set a cell inset on a table which allows me to choose, for example, .05 inches and each cell will have that much space on all four sides between the content and the border.

    Thanks,

    Dave

  5. #5
    gls858
    Guest

    Re: Cell Inset?

    davewill wrote:
    > I'm actually looking for a feature that will create space on all four
    > sides so that the text isn't up against the top and bottom also. Rows
    > are different sizes so to use the row height feature I would have to
    > choose each one seperatly and set the height. In InDesign I can set a
    > cell inset on a table which allows me to choose, for example, .05
    > inches and each cell will have that much space on all four sides
    > between the content and the border.
    >
    > Thanks,
    >
    > Dave
    >
    >


    Select cell right click > Format cell > alignment set horizontal
    to center, set vertical to center.

    gls858

  6. #6
    David McRitchie
    Guest

    Re: Cell Inset?

    Hi Dave,
    For vertical alignment you may have some success by selecting
    all cells then format, cells, vertical alignment: center
    then with all cells selected adjust the demarcation line between
    the row numbers by dragging to enlarge the height
    (you can also adjust the height from format, rows, height)

    To guarantee space on the right you can use the same technique
    for standard cell formatting that was shown with the width of two
    vertical lines (pipes), which may help when you doubleclick on
    the column borders to adjust width. You could just widen all
    columns more than needed with fussing the rightside of formatting.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "gls858" <[email protected]> wrote in message news:[email protected]...
    > davewill wrote:
    > > I'm actually looking for a feature that will create space on all four
    > > sides so that the text isn't up against the top and bottom also. Rows
    > > are different sizes so to use the row height feature I would have to
    > > choose each one seperatly [separately] and set the height. In InDesign I can set a
    > > cell inset on a table which allows me to choose, for example, .05
    > > inches and each cell will have that much space on all four sides
    > > between the content and the border.
    > >
    > > Thanks,
    > >
    > > Dave
    > >
    > >

    >
    > Select cell right click > Format cell > alignment set horizontal
    > to center, set vertical to center.
    >
    > gls858




  7. #7
    Registered User
    Join Date
    08-19-2005
    Posts
    4
    Thanks everyone. I think Excel is really missing out not allowing you to set a basic cell inset. In InDesign you set the inset and not matter how you size your rows and columns you always have the exact same inset on all cells where you have set it. You can set it by cell(s), column(s), row(s), or overall.

  8. #8
    David McRitchie
    Guest

    Re: Cell Inset?

    Hi Dave,

    It certainly would be useful.

    I can see a problem with a quick implementation due to a limit of
    4000 formats (combinations of format attributes).

    It would add 4 more format attributes (one for each
    border) and unless the same numbers were used in all cells the same
    way would cause problems -- especially since it is something you
    wouldn't really see. Perhaps if it were set as a global attribute, but then
    you wouldn't be able to squeeze some columns more than others to fit.

    I don't think I have actual problems with characters too close to a border
    to be able to read them properly in Excel. I know for instance that I do add
    extra space in HTML for just that reason. This can be corrected with styles
    in HTML if I wanted more space only on left and right but not all four sides.
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "davewill" <[email protected]> wrote in message
    news:[email protected]...
    >
    > Thanks everyone. I think Excel is really missing out not allowing you
    > to set a basic cell inset. In InDesign you set the inset and not
    > matter how you size your rows and columns you always have the exact
    > same inset on all cells where you have set it. You can set it by
    > cell(s), column(s), row(s), or overall.
    >
    >
    > --
    > davewill
    > ------------------------------------------------------------------------
    > davewill's Profile: http://www.excelforum.com/member.php...o&userid=26450
    > View this thread: http://www.excelforum.com/showthread...hreadid=397192
    >




  9. #9
    Registered User
    Join Date
    08-19-2005
    Posts
    4
    I'm a graphic designer so my tables aren't very large. They are never more than a few pages so having the inset in InDesign is great. I can see where it could be a problem for large spread sheets.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1