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

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?


I would take the engineering approach that 14.86 or 15.13 is close
enough to 15.00 for all practical purposes and give your students a
passing grade on this part of their assignment. A column width that's
off by just one percent is close enough.

I taught Excel for several years as part of an introductory computer
class. Try teaching them macros, goal-seeking, or pivot tables. :<)

Bill