internal margin around text in a cell

[John Cutler]

Hi, all...

Within a cell (or the spreadsheet as a whole), is there a
way to specify the width of the "internal margin"?

I know this can be set for text boxes (separately for top,
bottom, right, left), but I have found no reference in
Help for doing this in a cell...

Where I use a double-line border above a cell, the top of
the text actually touches the border. For one column of
cells, "Wrap text" is checked, so effective row height is
variable from one row to the next. So far, I've managed by
manually adjusting each row height and formatting the text
to be "centered" vertically.

Thanks

John Cutler
Mapping Director / Ozark Regional Land Trust

 

[Frank Kabel]

Hi John
AFAIK there's no such option to change the internal cell margins

 

[Andy B]

How about Format/Cells/Alignment/Indent? Would that do the job?

Andy.

 

[Frank Kabel]

Hi Andy
this will only affect the left and right border of the cell. If I
understood the OP correctly he has the problem with the top border

 

[Andy B]

Frank

That's what you get when you don't read the question!! I was just the same
in school exams - I haven't changed!!

Cheers
Andy.

 

[Frank Kabel]

Frank

That's what you get when you don't read the question!! I was just the
same in school exams - I haven't changed!!

lol - I know that feeling: In the past it was my teacher, now it's my
customer
Cheers
Frank

 

[Dave Peterson]

If these cells contain text (not formulas), then maybe you could add an
alt-enter at the top (and bottom).

You can highlight that character in the formula bar and even give it a very
small height.

But I think changing the rowheight is easier.