expanding the ruler's comand line?

**yoniman** · 03-24-2009, 05:34 AM

Hi all
When not programming I sometimes use very long commands (e.g. multiple conditions with data importing from closed files). The command line in the rule expands such it hides the columns headings making the writing very uncomfortable. is there a way to force the line to be wider without spilling into the data (like another ruler line)?

Ideas appreciated

yoniman

**alski** · 03-24-2009, 06:12 AM

They have fixed this in Excel 2007 and have a scrollable formula bar which you are referring to as a ruler. The only thing I can suggest is that you change the font in the Tools - > Options -> General Tab -> Standard Font. The lowest this seems to go to having just tested a couple is font size 8. It will tell you you need to restart excel for the changes to occur.

**yoniman** · 03-24-2009, 07:13 AM

Thnks alski
My only comfort is that I'm not the only one having this problem.

How is the switch from 2003 to 2007? Any problems accessing old files? Any major changes that I will have difficulties getting used to?