internal margin around text in a cell


J

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
 
Ad

Advertisements

F

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
 
A

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.
 
F

Frank Kabel

Andy said:
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
 
Ad

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top