#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic row height adjust ckemler Setting up and Configuration of Excel 1 December 22nd 09 05:26 PM
How do I set a cell to automatically adjust it height to expand Fred Excel Discussion (Misc queries) 1 February 29th 08 10:10 PM
How do I adjust row height to set cell margins to zero? marina Excel Discussion (Misc queries) 4 August 13th 06 06:11 PM
Auto-adjust cell height to accommodate contained text. PETBerkeley Excel Discussion (Misc queries) 5 October 28th 05 05:50 PM
Excel adjust row height upon merging 2 cell with word wrap RT Excel Discussion (Misc queries) 3 July 16th 05 07:06 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"