Can Excel Filter Horizontally? Yes, and Here's How (5 Ways)

Excel has built-in filters for rows, but nothing for filtering columns. In this video, I show you five ways to filter your data horizontally in Excel, so you keep only the columns you need). You will learn how to: • Use the FILTER function with a TRUE/FALSE row, checkboxes, or a drop-down list to pick columns • Pick columns by their position with CHOOSECOLS • Transpose, filter, and transpose back with Paste Special (no formulas needed) • Hide unwanted columns with two keyboard shortcuts using Go To Special (Row Differences): Ctrl + \, then Ctrl + 0 • Remove columns with Power Query, then just refresh when your data changes 0:00 Intro 0:21 FILTER function 4:46 CHOOSECOLS function 5:37 Paste Special + Transpose 7:32 Go To Special (Row Differences) 10:22 Power Query ➡️ Download file: https://www.dropbox.com/scl/fi/v9ngjr... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c... ✅ Free VBA course - https://trumpexcel.com/excel-vba-course/ ✅ Free Power Query Course - https://trumpexcel.com/power-query-co... ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... #Excel #ExcelTips #ExcelTutorial #SumitBansal