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.
On this page7
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. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “remove extra columns in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
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.