This tool removes all completely empty columns within the dataset on your worksheet.
Deleting these blank columns makes your worksheet less cluttered and easier to navigate.
With fewer unnecessary gaps, your data is more organized and professional-looking, which helps when you use tables, sort, filter, or analyze the information.
Tip: To remove only the empty columns within a specific range only, use our "Select, Hide, or Delete Rows or Columns Based on Custom Criteria..." tool.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords to help you find this tool:
Delete all empty columns in Excel, Remove blank columns, Delete blank columns, Remove empty columns from worksheet, Clean up empty columns in Excel
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
ASAP Utilities helps you save time and do what Excel alone can't.
You can get started right away. No training needed.
Most users start with a few tools. Many end up using ASAP Utilities daily.
Used by teams in 28,500+ organizations.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial