Hi macropod,
The "Normal Font" will consistently affect the default width of a column in
a new workbook, irrespective of hardware or system settings. In particular
the width is 8 standard width characters (eg a numeral) plus a constant
width of cell padding. The default column width will always be 8+padding
where padding is recalculated to a factor of the character width (padding
factor will reduce towards zero as normal font size increases). The width is
then rounded to an integer number of pixels (I don't know if an intermediate
calculation to points then pixels is calculated with yet further rounding)
Another reason for different pixel column widths is the system setting for
Font size, typically 96dpi but large fonts are 120dpi. The OP mentioned
pixel width of 64 vs 80. That would be consistent with both users having
Arial-10 as their default normal font, but system fonts of 96 and 120dpi
respectively. However both system settings might be 96dpi but using
different Excel normal fonts as described above.
As you say Zoom can indeed display inconsistently, not only in different
systems but even within the same system and in the same session.
I haven't come across different monitors (or screen resolution settings)
affecting the pixel width of a default Excel column width (in pixels),
though of course I accept what you say.
As for printed sizes, yes these can vary though I suspect that is more
likely due to printer drivers and/or printer.
Regards,
Peter T
macropod said:
Sorry Pete, but I've seen this many times. Something as simple as a change
in monitor, with no other hardware changes, can affect how much Excel can
display in a column. Even something as simple as a change in the zoom
level can affect how much Excel can display is a column (quite apart from
the fact this changes thee # of pixels used). Excel is not a true wysiwyg
application - what gets printed is often laid out different to how it
appears on screen and shapes etc are invariably squashed vertically.
--
Cheers
macropod
[MVP - Microsoft Word]
Peter T said:
I'm not sure that hardware or screen resolution makes any difference. The
most likely reason for column widths being different in respective
systems is the Excel setting for the "Standard Font" which in turn
determines the "Normal" style's fault in a default new workbook
(Tools/General). Also the system setting for normal/large font size no
doubt changes the width, though most users use the standard setting which
results in 96 pixels / logical screen inch.
Regards,
Peter T
Tanya said:
Thank you very much!!!!!!! That changed the problem!!!! I have already
had
issues with the instructors not understanding hardware or settings that
are
different from one computer to another.
:
Hi Tanya,
The difference in relationships between pixel sizes and column widths
is dependant upon both the screen resolution and the display
driver for the computers concerned. Uninstalling & reinstalling Excel
won't change that. You could try changing the screen rsolution
setting via the display driver on your computer (provided it supports
the resolution of the other computer, but be aware this
affects all programs and how Windows looks in a general sense.
If your course tutor is trying to get you to do something that relies
on pixel sizes as a determinant of column widths, that
suggests a lack of understanding of how MS Windows and MS Excel work on
different hardware.
--
Cheers
macropod
[MVP - Microsoft Word]
I have also uninstalled and reinstalled the program and still having
the same
issues.
:
I am having issues with my column widths. I have not changed any of
the
defaults for the program. When I open excel the column width default
is 80
not 64. I am taking a course on excel and I can not do my homework
because I
cannot get the column width to the right size.
