ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adjust cell height (https://www.excelbanter.com/excel-discussion-misc-queries/263268-adjust-cell-height.html)

johncaleb

adjust cell height
 
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.


Jim Thomlinson

adjust cell height
 
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.
--
HTH...

Jim Thomlinson


"johncaleb" wrote:

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.


Gord Dibben

adjust cell height
 
Not a formula.

You could make the row heights taller than you need then
formatalignmentverticalcenter


Gord Dibben MS Excel MVP

On Thu, 6 May 2010 10:34:01 -0700, johncaleb
wrote:

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.




All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com