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.


--
davewill
------------------------------------------------------------------------
davewill's Profile: http://www.excelforum.com/member.php...o&userid=26450
View this thread: http://www.excelforum.com/showthread...hreadid=397192

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 ,
davewill
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.

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


--
davewill
------------------------------------------------------------------------
davewill's Profile: http://www.excelforum.com/member.php...o&userid=26450
View this thread: http://www.excelforum.com/showthread...hreadid=397192

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

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" wrote in message ...
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

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

I'm guessing that you mean indenting from the left edge of the cell. If
so then go to FormatCellAlignment
Under "Horizontal" choose "Left (Indent)"
Now specify the amount of indentation using the spinner control
labelled "Indent:"


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=397192