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?

  • how about filter out every 4th column into a separate sheet with one cell formula? – user0 Jun 10 '19 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 '19 at 10:51
  • Please add a brief description of your search/research efforts as is suggested on How to Ask. – Rubén Jun 14 '19 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)))

| improve this answer | |

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.