How to Remove Extra Excel Columns Without the Inquire Add-In
Question details
The user wants to find a built-in method to remove unused extra columns at the end of a spreadsheet without having to rely on the Inquire Add-In.
- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Cleaning up a workbook to eliminate infinite scrolling and reduce file size by deleting empty columns at the right side of the active dataset.
- Observed behavior
- The user needs to select the unwanted columns using keyboard shortcuts, execute the delete command, and verify the columns are permanently removed after closing and reopening the file.
Scroll through the far-right sections of your worksheet to ensure there are no hidden reference tables or isolated formula calculations in the columns you are about to delete.
Delete Extra Columns Using Keyboard Shortcuts
Use the Ctrl+Shift+Right Arrow shortcut to quickly highlight all unwanted trailing columns and delete them via the context menu.
While the Inquire Add-in features a 'Clean Excess Cell Formatting' tool, you can achieve the same result manually. This built-in approach efficiently clears out all empty columns to the right of your data, helping to reset the used range of your worksheet.
Click directly on the lettered column header (e.g., 'H') of the first blank column immediately to the right of your data set.
Press and hold the Ctrl + Shift + Right Arrow keys on your keyboard. This will instantly select all columns from your starting point to the very edge of the spreadsheet.
Right-click anywhere on the highlighted column headers at the top of the screen and choose 'Delete' from the drop-down menu. If a prompt appears, select 'Entire column' and click OK.
Click the Save icon (or press Ctrl+S). Close the workbook entirely and then reopen it. This forces the application to recalculate the used range and confirms the columns are removed.
Easily Manage Your Spreadsheets with WPS Office
WPS Spreadsheet provides a highly intuitive interface for handling large datasets. You can seamlessly select and delete infinite blank rows and columns using familiar shortcuts without needing any specialized add-ins.
- 1. Open your file in WPS: Launch WPS Office and open your spreadsheet document.
- 2. Select the starting column: Click the header letter of the first blank column you want to remove.
- 3. Use the shortcut: Press Ctrl + Shift + Right Arrow to highlight all columns to the right.
- 4. Delete and save: Right-click the selected headers, click 'Delete', and then save your document to apply the changes.
Frequently Asked Questions
Why didn't my file size decrease immediately after deleting columns?
Spreadsheet software often caches the 'used range' of a worksheet. To fully clear the memory and reduce the file size after deleting extra columns, you must save the workbook, close the application, and reopen the file.
How do I delete extra columns if my keyboard shortcuts aren't working?
If Ctrl+Shift+Arrow isn't working, click the first empty column header, drag the scroll bar at the bottom all the way to the right, hold the Shift key, and click the very last column header (usually XFD) to manually highlight them all before right-clicking to delete.
Can I remove non-adjacent extra columns at the same time?
Yes. Hold down the Ctrl key while clicking the specific header letters of each separate column you wish to remove. Once all desired columns are highlighted, right-click any selected header and choose 'Delete'.
