In Excel: select the column HEADERS of the extra columns (click the first, Shift+click or Ctrl+click the rest), right-click, and choose Delete — that removes the columns themselves; pressing the Delete key instead only clears their contents and leaves the empty columns, and the bloated scroll area, in place.
Click the header of the first extra column to select the whole column.
Shift+click the header of the last extra column for a contiguous range, or Ctrl+click individual headers for non-adjacent ones.
Right-click any selected header and choose Delete — not the Delete key, which only clears contents.
Press Ctrl+End to check where Excel now thinks the data ends; if it still jumps too far right, save the file, close it, and reopen it.
If the scroll area still has not shrunk after reopening, select from the last real column to the sheet edge and delete again.
What this does
Deleting the column structure (right-click ▸ Delete on the header, which shifts everything after it left and shrinks the sheet) is a different action from clearing content (selecting cells and pressing Delete, which empties them but keeps the columns exactly where they were). Excel also remembers the furthest cell that was EVER used — visible as an oversized scrollbar or Ctrl+End jumping far past the real data — even after that content is cleared. Deleting the actual columns, not just their contents, is required to shrink that used range, and Excel sometimes needs a save-and-reopen to fully recalculate it afterward. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. Treat “remove extra columns in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected columns shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.
A worked example
A report has real data in A1:F200, but pasted junk once reached column BZ, so the sheet now scrolls sideways to BZ and Ctrl+End lands there instead of at F200. Clicking the G column header, Shift+clicking the BZ header, right-clicking, and choosing Delete removes columns G through BZ entirely — Ctrl+End should now correctly stop near F200. If it still does not, saving the file, closing it, and reopening it forces Excel to recalculate the used range, after which the scrollbar and Ctrl+End match the real data. A sheet that scrolls or prints far past its real data is almost always leftover empty columns rather than a bug, and the fix is one right-click away once you know Delete on the header — not the Delete key — is what actually removes them. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Treat “remove extra columns in excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.
Common mistakes
- Pressing the Delete key on selected columns expecting the columns to disappear — that clears content only; the empty columns and the inflated scrollbar remain.
- Deleting only some of the extra columns and assuming the used range shrinks proportionally — it does not update until every column past the real data is gone.
- Skipping the save-and-reopen step and concluding the fix "did not work" when Ctrl+End still points too far right immediately after deleting.
- Deleting a wide range of columns without checking whether any of them are referenced by formulas elsewhere in the workbook, producing
#REF!errors.
Frequently asked questions
How do I delete multiple extra columns at once in Excel?
Click the first column header, Shift+click the last one to select the whole range, then right-click ▸ Delete.
Why does my sheet still scroll far past my data after I cleared the extra columns?
Pressing Delete only clears contents; the columns — and the sheet's remembered used range — stay the same size. Right-click ▸ Delete on the column headers themselves, then save and reopen the file if Ctrl+End still points too far.
Does Google Sheets have the same fix?
The same manual approach works — right-click a column header (or a multi-header selection made with Shift+click, Ctrl+click, or Ctrl+Shift+Right Arrow to select to the sheet's edge) and choose Delete columns. Sheets has no separate one-click "remove unused columns" feature, and it does not carry Excel's hidden used-range bloat the same way, since a sheet's row/column count is a directly visible, adjustable setting rather than an invisible high-water mark.