Forum Discussion

Copper Contributor

Apr 23, 2020

Scroll Bar Excel

My scroll bar on the right is jumping to the end of the worksheet. If I move the scroll bar with my mouse 1 cm it jumps to row 6543. Can you help me fix this? thanks

excel

deepkya

Copper Contributor

Apr 24, 2020

lowrain7 Check if there is any formatting beyond your data. Press CTRL+END or CTRL+DOWN arrow which will take you to the last row with your scroll bar at the end. Delete blank rows which will increase size of your scroll bar.

redheadfsa
Copper Contributor
Apr 25, 2020
deepkya thanks, but this doesn't seem to be working!
lowrain7
Copper Contributor
Apr 24, 2020
deepkya Thank you very much! I appreciate your help. The worksheet is fixed. It had over a million rows and there was a value in row 1048575.

WOW! Thanks again!