Forum Discussion

Tracy7212's avatar
Tracy7212
Copper Contributor
Aug 31, 2020
Solved

Vertical Scroll encompasses a million rows, most of which are blank

Hello, I have about 1400 rows with data, about 1000 of which are hidden most of the time.  If I pull the vertical scroll box to the bottom of the vertical scroll space, it gets to Row 400,000 - or m...
  • HansVogelaar's avatar
    Aug 31, 2020

    Tracy7212 

    Do the following in the desktop version of Excel.

    Select the first entirely blank row by clicking on its row number.

    Hold down Shift and drag the 'thumb' of the vertical scroll bar down until you see row 1048576.

    Hold down Shift and click on the row number of row 1048576.

    This will select everything from the first blank row to the bottom of the worksheet.

    On the Home tab of the ribbon, click Clear > Clear All.

    Press Alt+F11 to activate the Visual Basic Editor.

    Press Ctrl+G to activate the Immediate window.

    Type ActiveSheet.UsedRange and press Enter.

    Switch back to Excel and save the workbook.

    Does the vertical scroll bar now act normally?

Resources