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.

I have also uninstalled and reinstalled the program and still having the same
issues.

"Tanya" wrote:

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.

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]


"Tanya" wrote in message ...
I have also uninstalled and reinstalled the program and still having the same
issues.

"Tanya" wrote:

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.

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.

"macropod" wrote:

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]


"Tanya" wrote in message ...
I have also uninstalled and reinstalled the program and still having the same
issues.

"Tanya" wrote:

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.

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" wrote in message
...
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.

"macropod" wrote:

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]


"Tanya" wrote in message
...
I have also uninstalled and reinstalled the program and still having the
same
issues.

"Tanya" wrote:

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.

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" <peter_t@discussions wrote in message ...
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" wrote in message ...
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.

"macropod" wrote:

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]


"Tanya" wrote in message ...
I have also uninstalled and reinstalled the program and still having the same
issues.

"Tanya" wrote:

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.

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" wrote in message
...
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" <peter_t@discussions wrote in message
...
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" wrote in message
...
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.

"macropod" wrote:

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]


"Tanya" wrote in message
...
I have also uninstalled and reinstalled the program and still having
the same
issues.

"Tanya" wrote:

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.