Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

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:

  • Decrease the width of the column, add wrapping to any cells that go beyond the edge of the cell and view the contents in a multi-line format. This is probably how you want to provide an output version (eg, printed report, spreadsheet fragment for a word doc, powerpoint presentation etc) in any event

  • Use <Ctrl-Mouse wheel> to zoom in and out of your spreadsheet. This might make it difficult to read the contents of the too-wide column in zoomed-out mode, but you will see how the overall sheet looks.

share|improve this answer
    
Thanks! I think I have no choice but to do that. – Rayne Jan 29 '13 at 2:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .