I have a column in Excel 2007 whose width is set to 200. This means that it is longer than the width of my screen. If I scroll the worksheet from left to right, it will move column by column, which means that I can only view part of the long column. How do I change this such that it doesn't "snap to column" and I can scroll the worksheet freely?
I don't think you can, at least not in any version of Excel I've seen. The left hand side starts with a column's left margin, and that's it.
A couple of options you do have: