I have several big tables, and I know that each 4th column is interesting for me, i.e B,F,J,N, etc (The total number of columns is different in different documents)

Is there an easy way (some sort of a script) I can use to hide all other columns in few clicks?

bumped to the homepage by Community 14 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

  • how about filter out every 4th column into a separate sheet with one cell formula? – user0 Jun 10 at 10:48
  • I guess that could work if nothing else, but it's less desirable since being able to occasionally unhide would be nice – RiaD Jun 10 at 10:51
  • Please add a brief description of your search/research efforts as is suggested on How to Ask. – Rubén Jun 14 at 15:16
  • for columns A, D, H, L, etc.

    ={Sheet1!A1:A, FILTER(INDIRECT("Sheet1!A1:"&ADDRESS(ROWS(Sheet1!A:A), 
     COLUMNS(Sheet1!1:1), 4)), NOT(MOD(COLUMN(Sheet1!1:1), 4)))}

  • for columns D, H, L, etc.

     COLUMNS(Sheet1!1:1), 4)), NOT(MOD(COLUMN(Sheet1!1:1), 4)))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.