Using Excel 2021 Pro, but I think this problem is common to many versions.



I have a workbook with four sheets, created years ago. Each sheet has different formatting. Two of the sheets are plagued by the short vertical scrollbar problem, whereas the other two sheets have appropriately-sized scrollbars. I've tried selecting all rows below the bottom active row and using clear>all, but it didn't work. I also tried entering ActiveSheet.UsedRange in the VB Immediate window, but that didn't do anything. On one of the problem sheets, if I select all the rows, the last row is 1,048,576, and the scroll bar (probably not the right term) remains small. On the non-problem sheets, I can scroll quickly from top to bottom (the last row with data). If I drag that scroll bar to the bottom and then continue dragging, the bar instantly changes from small to long/tall. Hope that make sense.

What am I not seeing about the formatting or layout of the sheets with the good scroll bars versus the formatting or layout of the sheets with the short scrollbars?

There are no comments on the problem sheets nor any cell contents below the apparent bottom rows. The sheets have no macros.

Can someone please help me fix this common problem?