Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.