In a table, how can I select to display only certain columns and not others.

Please try

=FILTER(Table1[#All],TRANSPOSE(B11:B16="Yes"))

Try N2 formula

Formula:

Please Login or Register  to view this content.

with header

Formula:

Please Login or Register  to view this content.

=FILTER(Table1[#All],TRANSPOSE(IF(B11:B16="Yes",1,0)))

Originally Posted by Bo_Ry

Please try

=FILTER(Table1[#All],TRANSPOSE(B11:B16="Yes"))

Hi Bo_Ry, Thank you for your answer which does indeed answer the question as contained in my header. It was not exactly the answer I was looking for (my fault). My header was not completely clear.

What I meant to say is "In a table, how can I select to display only certain columns and not others...SO THAT I CAN INPUT THE DATA MORE EASILY". I want to enter data in to the table with a reduced number of columns, not just "Display" it. Thanks anyway, the Filter command seems very useful to me for other reasons.

Thanks @wk9128, thanks @Glenn Kennedy

alternatively use a VBA UserForm

Why not simply "Hide" those columns not required?

If you want to select those columns (as per "Columns to display" image ) then VBA can do this.

OR use "Custom Form" in "Developer" which will display all Visible columns and provides a friendly input form. No VBA!

https://www.howtoexcel.org/how-to-cr...m-without-vba/

Originally Posted by JohnTopley

Why not simply "Hide" those columns not required?

Because the columns into which I need to enter data change frequently, and are not contiguous. That means that before each data entry I would need to hide 35 to 59 non-contiguous columns, and after each data entry I would need to unhide them and hide different columns. I am really looking for something where I can hide specific groups of columns with one or two clicks. For example for entering one type of data I might only need columns A, F, +B, BX, BZ and CS, For a different type of data entry I might only need columns A, X, AR, CB and CT. Therefore I am looking for a simple tool I can use to rapidly hide the other columns (and unhide). Something like (imaginary) =HIDECOLUMNS(), which could be invoked quickly with a simple click.

Originally Posted by JohnTopley

If you want to select those columns (as per "Columns to display" image ) then VBA can do this.

To be clear, it's not really "DISPLAY" I want, but rather a way to enter the Data with a much reduced number of columns. As for VBA, I have never really been able to learn it, I tried a few times). I gave up after people told me the Mac version is really so cut down so as to be useless. That was several years ago, so maybe it has got better.

see big yellow banner - how to upload your workbook - with 10 - 12 rows of desensitised data.
far easier then to give a solution relevant to 'real world' requirement.

from your post it would appear you have in excess of sixty columns.
even if the data entry form was available to you on 'Mac', it would no cover your requirement as it is limited to 32 columns max on Windows PC.
This limitation does not exist if you construct a UserForm using VBA.

Pity so you are left with VBA. See post #10/#12 from torachan (these forms are his speciality!)

But look here:

https://www.contextures.com/exceldat...pdateform.html

You will need to provide a file with ALL columns PLUS identify which ones are data-entry fields as I assume many are formulae.

And do want a VBA Userform only to display selected [i.e variable number of] data entry columns (as per your original request)?

If moving to a PC is a viable(better?) option than learning some VBA then look at doing so.

The FORM function will only display visible columns so unless you have (or want) more than 32 columns visible at any one time, it will suffice.

If as requested you post a your real file, I'll have a "play" with the FORM option anyway!

@TRICKYT57, at nearly 70 you are a 'spring chicken' compared to some of us aged persons.

If the hidden column is fixed,

You may try selecting column you want to hide
then go to Ribbon > DATA > Group

https://support.microsoft.com/en-us/...%20even%20open.

Originally Posted by Bo_Ry

If the hidden column is fixed,

You may try selecting column you want to hide
then go to Ribbon > DATA > Group

https://support.microsoft.com/en-us/...%20even%20open.

Bo_Ry, Thank you so much for the suggestion to use the Group function on the Ribbon. It's exactly the kind of solution I was looking for. With some re-arrangement of my columns into a different order, the group function will allow me to instantly hide (with just one click) all columns except those into which I will enter data. It's one click instead the previous five mouse actions -per column to hide, so a real time saver for me.

Even more importantly, it can act as a permanent marker of which columns I need to hide, instead of having to figure it out each time. That's a big time saver too!

Although the "Group" function has been sitting in my ribbon for years, it never occurred to me to figure out what it does.

The ability to "nest" groups or have sub-groups is particularly useful to my set up. Thank you so much for taking the time to figure out what I was trying to achieve and pointing me to the solution.

We can now mark this as "SOLVED". I will try and do that if I can see the button.