Measuring cell width and height for printed paper

[Pekka Numminen]

The width of cells is displayed in characters and pixels. The height
of cells is displayed in points and pixels.

How do I know how many inches or centimeters a certain number of
pixels will be on printed paper?

 

[John]

Hi
For one square inch.
Try 12.45 (144 Pixels) for the width and 72 (144 Pixels) for the height.
On my Dell printer its exactly one inch.
HTH
John

 

[Pekka Numminen]

Hi
For one square inch.
Try 12.45 (144 Pixels) for the width and 72 (144 Pixels) for the height.
On my Dell printer its exactly one inch.
HTH

For some reason, for me, the Page Layout view of Excel 2007 shows the
height and width of cells in _centimeters_ and pixels. Anyway, I
changed some cells to 144 pixels * 144 pixels and added border lines.
The Normal view actually then shows the width of each cell as 134
pixels. The outcome on paper: cells that have the width and height of
roughly 1.5 inches, measured using a ruler.

 

[Bill]

The width of cells is displayed in characters and pixels. The height
of cells is displayed in points and pixels.

How do I know how many inches or centimeters a certain number of
pixels will be on printed paper?

See the table at the bottom of this MS web page for approximate conversions:
http://office.microsoft.com/en-us/excel/HP011517241033.aspx

You can also use page layout view, display the horizontal and vertical
rulers, and change the measurements of the ruler to inches, cm, or mm by
using the Advanced tab on the Excel Options menu.

Bill

 

[John]

Hi Bill
Taken from Microsoft website ;{The height of cells is displayed in points and
pixels rather than in inches. When you drag the boundary of a row heading to
adjust the height of a row on the worksheet, a ScreenTip displays the height in
points and shows pixels in parentheses.}
The table shows 72 Points (96 Pixels) on my computer, I get 72 Points (144
Pixels).
Am I missing something ??
I thought it could be a mistake (Typo).
Regards
John
P.S. It was very nice of you to thank Dave Peterson for helping someone being
picked on by "SmartASS"

 

[Bill]

Hi Bill
Taken from Microsoft website ;{The height of cells is displayed in
points and pixels rather than in inches. When you drag the boundary of a
row heading to adjust the height of a row on the worksheet, a ScreenTip
displays the height in points and shows pixels in parentheses.}
The table shows 72 Points (96 Pixels) on my computer, I get 72 Points
(144 Pixels).
Am I missing something ??
I thought it could be a mistake (Typo).
Regards
John
P.S. It was very nice of you to thank Dave Peterson for helping someone
being picked on by "SmartASS"

John
It's probably not a typo, just a difference in screen resolution. 72
points should equal one inch.

MS offers macros to specify row height and column width in either inches
or centimeters here:
http://support.microsoft.com/kb/213422

OpenOffice.org's free Calc program uses inches as the default (at least
in the US) measurement for both row height and column width.

Quattro Pro has long offered inches, centimeters, and points as options
for these measurements. I haven't used the program in recent years, so I
am not positive if the three options are still available.

Bill

 

[Bill]

It's probably not a typo, just a difference in screen resolution. 72
points should equal one inch.

MS offers macros to specify row height and column width in either inches
or centimeters here:
http://support.microsoft.com/kb/213422

OpenOffice.org's free Calc program uses inches as the default (at least
in the US) measurement for both row height and column width.

Quattro Pro has long offered inches, centimeters, and points as options
for these measurements. I haven't used the program in recent years, so I
am not positive if the three options are still available.

Bill

I just inserted the MS macros in a 2007 Excel spreadsheet. At least on
my HP inkjet printer I get only an approximation of the desired heights
and widths. A one-inch height comes out at 0.95 inch and a two-inch
width comes out at 2.125 inches. It's not my printer acting up, either.
When I use OpenOffice.org's Calc program the height is one inch and the
width is two inches. The web page I referenced does say the macros are
for Excel 2000, but I don't think that should really make a difference.

It must be an Excel bug of some kind. If I copy and paste the resized
cells from Excel to either Word, Publisher or PowerPoint and print them
out from there the sizes are exact at 1 and 2 inches.

Bill