Stop Excel shifting right when line count reaches 1000

[NeilT123]

I have a spreadsheet that now has just over 1000 lines. I regularly use my mouse wheel to scroll up and down the sheet but now as I move from line 999 to 1000 the spreadsheet shifts to the right a little and back to the left when scrolling up the sheet.

I believe that the cause is when the line number goes from 3 digits to 4 digits and vice versa. It is only a small issue but is quite annoying. Does anyone know how to fix this? Or maybe how to specify the width of the column to the left of column A.

Thank you for any suggestions

Neil

 

[SkipVought]

...and when you get to 10000
...and when you get to 100000

I've never lost any sleep over this one. But I'd suggest Sominex, if you need some help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hjgoldstein]

You could always set Excel not to show column and row headers at all.

Aspiring to mediocrity since 1957

 

[mintjulep]

Wow.

Your world is so perfect that this is your biggest worry?