adjust cell height

J

johncaleb

Is there a formula to adjust cell heights in a cell so there's a certain
amount of pixels above and below the letters/numbers? This is so the numbers
aren't so crowded in the cell if formatted "text-wrapped"?

thanks.
 
J

Jim Thomlinson

You can auto fit the row height. There is no option for pixels above and
below similar to Word where you can format the text to have leading and
trailing space.
 
G

Gord Dibben

Not a formula.

You could make the row heights taller than you need then
format>alignment>vertical>center


Gord Dibben MS Excel MVP
 

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

Similar Threads

Internal margin for row height autofit 1
Configure Formula Bar 6
Auto-adjust row height does not work correctly 2
Formatting Excel 3
Auto Cell Height Adjustment for text entered 3
How do I autofit row height to adjust to new text on Excel form? 1
Cell padding 1
automatically adjust row height in excel 2000 2

Top