Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default width and height use diferent unit, what units are those?

Why
width units relation is 3 units/26 pixels
and
height is 3 units/4 pixels,
what kind of units use each one?,
how can I use a real scale in the work sheet?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default width and height use diferent unit, what units are those?

If you want to draw boxes use Word or a drawing program
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Isidro_Sarquis" wrote in message
...
Why
width units relation is 3 units/26 pixels
and
height is 3 units/4 pixels,
what kind of units use each one?,
how can I use a real scale in the work sheet?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default width and height use diferent unit, what units are those?

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.

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

"Isidro_Sarquis" wrote in message
...
Why
width units relation is 3 units/26 pixels
and
height is 3 units/4 pixels,
what kind of units use each one?,
how can I use a real scale in the work sheet?


Gord Dibben MS Excel MVP
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
cell width and height Brian Brandt New Users to Excel 3 February 14th 06 10:57 AM
variable height variable width stacked bar charts ambthiru Charts and Charting in Excel 3 January 18th 06 11:41 PM
how can I print a sheet without the height & width being adjusted pb Excel Discussion (Misc queries) 1 December 5th 05 03:56 PM
Vary column width and row height in the same worksheet Tess Excel Discussion (Misc queries) 1 August 4th 05 03:39 PM
Displaying column width and row height swirlygirl Excel Worksheet Functions 3 February 7th 05 09:53 PM


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