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. If you’re unable to see certain columns, it might be because they are hidden or outside the viewing area, in which case you can use the scroll bar or adjust the column width. In Google Sheets, the process is similar, where you can hide or unhide columns by selecting them and then using the /”Hide/” or /”Unhide/” option from the context menu. To eliminate infinite columns in Excel, you can simply select the column header to the right of the last column you need, right-click, and choose /”Delete./”

Let’s break down this formula.

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

1) CHOOSECOLS
This could be a custom function or a macro created by a user or a third-party add-in. It is not a standard Excel or Google Sheets function.

2) A5:H17
This likely represents a range of cells from cell A5 to cell H17. The function may be designed to work on this range.

3) 1, 3, 5
These are numerical arguments being passed to the custom CHOOSECOLS function, but without knowing the specific function’s definition, it’s unclear what these numbers do. They could potentially indicate which columns from the range A5:H17 are to be selected or manipulated in some way.

To understand the function’s exact purpose and behavior, you would need to access its source code or documentation if it’s a custom function, or consult the documentation of any third-party add-in that provides this functionality.

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

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

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

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

Display only selected columns in Excel – Excel Tip and Tricks

Please take the opportunity to connect and share this video with your friends and family if you find it useful.