Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
GeoMulak
 
Posts: n/a
Default Is it possible to view or size column width and/or row height in .

Is it possible to view or size column width and/or row height in inches?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default


Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

For an interesting and enlightening discussion on this subject see

http://snipurl.com/dzz8

If you want to use VBA to set height and width in mm....which you could
convert to inches.

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol


Gord Dibben Excel MVP

On Wed, 13 Apr 2005 13:43:04 -0700, "GeoMulak"
wrote:

Is it possible to view or size column width and/or row height in inches?


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
Task Bar View of Column Width PhysicsLabCoordinator Excel Discussion (Misc queries) 0 March 10th 05 04:21 PM
with same font and pixel number different column width Christian Setting up and Configuration of Excel 0 February 1st 05 05:41 PM
Column Width Behavior Kirk P. Excel Discussion (Misc queries) 1 January 11th 05 07:35 PM
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 08:25 PM
Column Width Deborah M Excel Discussion (Misc queries) 1 December 6th 04 05:27 PM


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