How do I disable Excel 2016 auto horizontal scrolling?

Question

When I expand a column that contains a lot of text and is very wide (more than the screen's width), Excel automatically horizontally scrolls so that the edge of the column is at the edge of the window.

That way it is impossible for me to reduce the width of that column because I cannot click and drag its edge! Is there a way to fix that annoyance? They thought this would be a feature, but I consider it an annoyance if it is not a bug.

Answer 1

I don't have Excel 2016, but here is how to reduce the column width to fit on the screen in older versions:

1. Right click on the column header (above the top row of editable cells).
2. Click Column Width
3. In the box that pops up, enter a number (try 150 to start with)

Obviously, you can repeat this with different numbers to get the column size that suits you.