View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Instructor44 Instructor44 is offline
external usenet poster
 
Posts: 4
Default Unable to get column width I want in Excel 2007

My computer at home uses Body Font 11. However I will check with the
computers at school to see if it is different. I think it's interesting that
I can change to 15 on my own worksheets, but not on a student's that I have
downloaded. This has been a question for a few semesters and I thought
"Now's the time to figure this out." I also wonder what is normal for the
publisher. My students download their files from the publisher's website.

Thank you, Michael for you response. This gets me thinking!

"Michael R" wrote:

I don't have a definitive answer but found that the increments that Excel
uses to determine column width depend on the default font defined in your
"Normal" style. (see also http://support.microsoft.com/kb/214123)

What font does your "Normal" style have?

"Instructor44" wrote:

,I am an instructor teaching Excel 2007. There is an assignment where my
students have to change the width of several columns. They would like a
column width of 15.00. If they use the mouse to change the width, they can
get either 14.75, 14.88 or 15.13. If they right click on the column and click
Column Width then enter 15 or 15.00 and click ok, they still get 15.13 when
checking with the mouse. As I'm grading these assignments I have attempted to
change the widths and find I'm not able to get 15.00 either. Can anyone help
me?