Hidden columns - how to copy only the unhidden columns?

[plumberef]

I have columns A, B, C, D, E, F ............BZ

Some of these columns are hidden (say they do not meet my criteria).

But when I select the unhidden columns and copy to another sheet, those hidden columns are also copied. How can I copy only the unhidden columns?

Many thanks.

[benishiryo]

hi plumberef. select the range like you did (Column A:BZ). then press ALT + ;
that is to select visible cells only. a longer way is to press CTRL + G -> Special -> select Visible cells only -> OK. then copy

[plumberef]

https://support.office.com/en-ca/art...2-8b814412847e

Found the answer, see above link.

[plumberef]

hi plumberef. select the range like you did (Column A:BZ). then press ALT + ;
that is to select visible cells only. a longer way is to press CTRL + G -> Special -> select Visible cells only -> OK. then copy

Noted and thanks.