Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 155
Default Pixel discrepency

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 155
Default Pixel discrepency

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.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 293
Default Pixel discrepency

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.


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 155
Default Pixel discrepency

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.



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Pixel discrepency

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.







  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 293
Default Pixel discrepency

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.





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
Color Count Macro discrepency Whois Clinton Excel Programming 3 July 29th 08 03:15 PM
Number discrepency Ian Excel Programming 2 June 8th 07 02:58 PM
Transparency Discrepency Quahaug Excel Programming 8 October 18th 06 12:11 PM
HOW DO I ADJUST ROW HEIGHT BY PIXEL? western jet Setting up and Configuration of Excel 0 March 8th 06 08:44 PM
Pinpoint pixel ksel[_2_] Excel Programming 4 January 20th 04 03:23 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"