 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008Problem with cell size
Hi I have Excel 2002, I am trying to set my cell size to 15 x 15, when I select Row Height 15 I get the required height but when I select column width 15 I get a much wider result, the cells are not square. What am I doing wrong? thanks Daniel The values for each of these sizes are in different units of measurement. From the help files... "On a worksheet, you can specify a column width of 0 (zero) to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font (standard font: The default text font for worksheets. The standard font determines the default font for the Normal cell style.). If the column width is set to 0, the column is hidden. You can specify a row height of 0 (zero) to 409. This value represents the height measurement in points (1 point equals approximately 1/72 inch). If the row height is set to 0, the row is hidden." Rick > Hi > [quoted text clipped - 7 lines] > > Daniel Rick thanks for your reply, it looks like I will have to do it by trial and error, but at least I know now regards Daniel > The values for each of these sizes are in different units of measurement. > From the help files... [quoted text clipped - 24 lines] >> >> Daniel You can try settings in Pixels but that is resolution-dependent from machine to machine. Rather than trial and error, which will fall apart if you give the file to a user with different Windows Settings or you change resolution yourself. If you want to use VBA to set height and width in mm. Ole Erlandson has code for setting row and column dimensions which will not be affected by resolution. http://www.erlandsendata.no/english/index.php?d=envbawssetrowcol Gord Dibben Excel MVP >Rick > [quoted text clipped - 32 lines] >>> >>> Daniel looks good, I'll give it a go. Thanks Daniel > You can try settings in Pixels but that is resolution-dependent from > machine to [quoted text clipped - 51 lines] >>>> >>>> Daniel Easy to use once you get the hang of it. Gord >looks good, I'll give it a go. > [quoted text clipped - 56 lines] >>>>> >>>>> Daniel |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.