Share via

Spacing within a cell

Anonymous
2012-09-24T14:00:59+00:00

All,

How can I add a fixed amount of space above and below the typing within a cell, where the cells may contain different amounts of text and not be the same size.

For example, I have a product description in a cell, and I want 1/4 in space above and below the type in each cell. Like a vertical margin.

Seevee

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2012-09-24T16:26:05+00:00

There's no provision for that type of spacing in XL.

You can easily set the row heights to the proper amount if the text consists of a single line - say 36 points plus the whatever your font height is - then format the cells to be centered vertically.

However, if you have any wrapped-text cells, row height won't change to maintain the spacing.

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest