Excel guide · 4 min read
Excel scroll bar too small: how to fix it
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| A | B | C | |
|---|---|---|---|
| 1 | What you see | Likely cause | Fix |
| 2 | Ctrl+End jumps far below your data | Used range includes empty cells | Delete the empty rows, then save |
| 3 | Thumb tiny right after a paste | Whole columns or a huge block pasted | Delete the extra rows and columns |
| 4 | Formula filled to row 1,048,576 | Fill-down went too far | Delete the rows below the data |
| 5 | Borders or fill far below the data | Formatting on empty cells | Delete those rows, not Clear |
| 6 | Horizontal bar short, vertical fine | Sheet tabs take the space | Drag the three dots to the left |
Why the scroll bar shrinks
The vertical scroll bar's thumb (the bar you drag) is sized to fit the sheet's used range: the area from A1 to the last row and column Excel has ever stored something in. With 300 rows of data and a used range down to row 500,000, the thumb is tiny, and nudging it jumps you thousands of rows into empty space.
"Something" doesn't have to be visible. A stray space, a border, a fill colour or a formula that returns "" all count. The table above lists the usual culprits.
1. Find the last used cell with Ctrl+End
Click any cell and press Ctrl+End. Excel jumps to the bottom-right corner of the used range. If that's the last cell of your data, the used range is fine and the scroll bar size is right. If it lands at row 48,000 or column XFD, everything between your data and there is what's shrinking the thumb.
To see what's down there, press Ctrl+Up arrow from that cell to jump back to the nearest content. If you find a value or formula you didn't expect, check whether anything refers to it before you delete it.
2. Delete the empty rows and columns, don't clear them
Pressing the Delete key only clears contents. Formatting stays, and so does the used range. You need to delete the rows and columns themselves.
- Click the row number of the first empty row below your data.
- Press Ctrl+Shift+Down arrow to select every row down to the bottom of the sheet.
- Right-click a selected row number and choose Delete.
- Click the column letter of the first empty column to the right of your data and press Ctrl+Shift+Right arrow.
- Right-click a selected column letter and choose Delete.
- Press Ctrl+S to save. Press Ctrl+End again: it should now land on your last real cell.
3. If the scroll bar is still tiny after saving
Excel usually resets the used range when you save. If Ctrl+End still goes too far, close the workbook and open it again.
If that doesn't do it either, check that you deleted both directions: rows below and columns to the right. Ctrl+End shows which one is still too big. A row at 1,000,000 with a far-right column XFD means both need deleting.
The last resort always works: select your real data, copy it, paste it into a new sheet (Home > Paste > Keep Source Column Widths), check formulas that point at the old sheet, then delete the old one. The new sheet starts with a used range that fits the data.
Remember the used range is per sheet. Fix each sheet whose scroll bar is wrong.
4. After a paste, and how to stop it coming back
The most common cause is copying whole columns (clicking the column letters) and pasting them, or filling a formula down by double-clicking with a neighbouring column that runs too far. Copy only the cells with data, or select the data with Ctrl+A inside the table first.
Turn data into an Excel table with Ctrl+T. Tables grow as you add rows, so formulas and formats don't need to be filled to the bottom of the sheet in advance.
If it's the horizontal scroll bar that's short, it may just be squeezed by the sheet tabs. Point at the three dots between the tabs and the scroll bar and drag them left to give the bar more room.
Common mistakes
Pressing Delete on the empty area
That clears contents but keeps formatting. Right-click the row numbers and choose Delete.
Not saving afterwards
The used range resets on save. Save, and if needed close and reopen.
Fixing one sheet and expecting all to change
Each sheet has its own used range; repeat on every sheet that's affected.
Deleting rows a formula depends on
Press Ctrl+Up arrow from the last used cell to check for stray content before deleting.
FAQ
Why is my Excel scroll bar so small?
Excel thinks the sheet's used range is much bigger than your data, usually because of formatting, a stray value or formulas far below it. Delete those rows and save to shrink it back.
How do I reset the used range in Excel?
Delete (not clear) every empty row below and every empty column to the right of your data, then save. If Ctrl+End still goes too far, close and reopen the file.
Why does dragging the scroll bar jump to row 1,000,000?
The thumb is sized to the used range. If that runs to the bottom of the sheet, a tiny drag covers thousands of rows. Fix the used range and the scroll bar behaves again.
Does a big used range make the file larger?
It can, especially when the extra area holds formatting or formulas. Resetting it often makes the file smaller and faster too.
Related guides
- Excel running slow: how to find the cause and fix it
- How to reduce Excel file size
- Excel keyboard shortcuts for beginners
Updated