Skip to playerSkip to main content
Learn how to display only selected columns in Excel.

In Excel, you can control the visibility of certain columns by simply selecting the columns you want to show. To display only specific columns, click on the column letter headers of the columns you wish to remain visible while holding down the Ctrl key. If you want to hide entire rows as well, you can do the same by selecting the row numbers. Additionally, if you want to limit the visible columns in Excel, you can right-click on the column header and choose the "Hide" option to conceal the selected columns.


Let's break down this formula.

=CHOOSECOLS(A5:H17,2,4,5)


🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Filter Excel to only show certain columns - Excel Tips and Tricks
https://youtube.com/shorts/tIWr5im7l0g?si=PHfITzbjXFiWCufS

Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks
https://youtube.com/shorts/UsmMcoUl7aE?si=vILFg8MSaYaMFs3N

Filter Excel to only show certain columns for large dataset - Excel Tips and Tricks - Detail Explanation
https://youtu.be/ZcGHuJq_zL8?si=wE0nesfQ_gkAZKpG

Display only selected columns in Excel - Excel Tips and Tricks
https://youtube.com/shorts/D3mQEA3Slac?si=JPDOVOjxKwH8F95X


How do I show only certain columns in Excel?,How do I make Excel only show certain columns and rows?,How do I limit the visible columns in Excel?,Why can't I see certain columns in Excel?,How do I only show certain columns in sheets?,
How do I show only selected columns in Excel?,How do I print only certain columns from an Excel spreadsheet?,How do I limit visible area in Excel?,How do I only show certain columns in sheets?

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypã‚· #exceltips #exceltricks
Transcript
00:00I recently made a video on how you can display certain columns of your data set
00:03using filter function but someone had made a comment saying that you can also
00:07use choose column function by the way choose column function is only available
00:11on Microsoft 365 and this is the formula to use equal choose columns like this
00:18and the first argument on choose column would be the data set itself you're
00:22gonna highlight the header all the way down to the very last row and the second
00:26argument will be a column selection so one indicates column a B is 2 and so on
00:33on your data set table of course if your data set table is offset starting at
00:38column C column C will be your number one so I'm gonna display column 2 4 & 5 and
00:44hit enter your display column 2 4 & 5

Recommended