All of sudden Copy is including hidden columns

how could it have been doing this by default all this time until now?

it worked for so long, no one out there?

I can't BELIEVE this isn't an option among all the options Excels offers. Anyway, VBA to the rescue.

Created this in my personal workbook:

Sub SelectVisible()
    Selection.SpecialCells(xlCellTypeVisible).Select
    Selection.Copy
End Sub

Then assigned this macro to Ctrl-C. Voila.

Note, doesn't work for single cells when there are rows/cols hidden elsewhere on the sheet.
not sure why (it expands to select the whole sheet for some reason)