Results 1 to 3 of 3

Thread: Cell Padding

  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Oklahoma, Oklahoma, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Padding

    Because Word tables can be quirky to work with <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>we are using Excel. However, I can't figure out how to "pad" the cells/set top and bottom cell margins (as I do in Word tables) so that the gridlines do not print so closely to the text. I'm not readily finding a way to accomplish that. Can it be done?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Cell Padding

    Press Ctrl-A, Format Cells, select the Alignment tab and set the vertical alignment to center. You can then Format,Row, and increase the height to give the required space above and below the contents. Another trick is to set the font size on an unused column to a size bigger than the point size you are working with. Unfortunately Excel has not got Word's paragraph formatting.

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Cell Padding

    There isn't an exact parallel to Word's column spacing for table cells, paragraph formatting (points before and after) and autofit. In Excel combine font size, the various Format Cell Alignment commands, and Format Row Autofit and Format Column Autofit to get the "border margins" you want.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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