I originally posted this two weeks ago. I got no replies. I suppose this is a boring topic for the experts, but that doesn't make it any less important to me. I'd be grateful if someone would refer me to a solution from older posts or just post the solution with steps a toddler could follow. I read the posts related to this issue, but they didn't help me resolve my problem. Thank you.
Quote:
Originally Posted by LaPlume
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?
|