How To Measure Cell Size In Excel?

[Negative Zero]

what is the uint of measurement for cell size in Excel? there seems to be one unit used for width, and a different unit used for cell height. i want to create cells that would print out to 1"x1" square. but i can't seem to figure it out. can someone help?

 

~NegZ

[TCH-Dick]

This is one of those weird ones. In Excel the number you see for the width is the number of digits(standard font) that will fit in the cell.

The number you see for the height is in Points(PostScript). Points can be converted to inches. You can use the Google calculator to convert.

Just type "inches to points" in the search bar.

 

1 inches = 72 points or 96 pixels

 

and for the width

 

1 inches = 13 or 96 pixels

[RJSkon]

If any body is interested.

 

There is a Freebie "Screen Caliper" that can be downloaded at, http://www.iconico.com/caliper/

The freebie version only reads in pixels, the paid version converts to all dimensions.

 

Without using the Google calculator to convert the points, using the Caliper I came up with 95 pixels x 95 pixels, but when I printed a sheet out in Excel the height came out to about 15/16 inch, the width was okay, the cell height may have to be adjusted to make up for the printer.

 

Richard

[TCH-Dick]

Thanks for the link RJ, it looks a good program. But like you said, the sizes might not be exact. The Points to Pixels measurements have been around from the days of monochrome monitors. Monitors have changed to color and in sizes since then, but sadly the measurements have stuck with software. So your numbers can match but your monitor or the software can cause it to vary. The same image can appear different depending on whether you are wanting to display it in windows, in a browser or print.