#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Row Height

Is there a way to use the autofit function with an "at least" setting. I
want all the rows to be at least 18.00 point, but to grow when wrapping. If
I set the row heights manually to 18 they don't grow, if I use auto fit, they
go back to 12.00 point.

Help
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 63
Default Excel Row Height

Row height and column width are based upon the Normal style. If you click on
a blank cell and then click on Format - Style and make sure the Normal style
is selected in the drop-down box at the top of the window you can click the
Modify button to change the font. If you set the Normal style font to Arial
14 you will find that the row height is automatically set to 18.00 provided
that there are some cells formatted with the Normal style on that row. If
you don't like using a size 14 font for your data you can change the format
of your cells to whatever font you want but the row height will still be
based upon the Normal style and size to at least 18 points if you are using a
size 14 Normal font.

Andrea Jones

"Barb Parker" wrote:

Is there a way to use the autofit function with an "at least" setting. I
want all the rows to be at least 18.00 point, but to grow when wrapping. If
I set the row heights manually to 18 they don't grow, if I use auto fit, they
go back to 12.00 point.

Help

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Can word wrap and merged cells auto row height properly in Excel wchernock Excel Discussion (Misc queries) 1 May 30th 06 03:04 PM
change excel row height without showing hidden rows LL Excel Worksheet Functions 1 April 15th 05 06:24 PM


All times are GMT +1. The time now is 11:41 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"