All of sudden Copy is including hidden columns

For about a year, since upgrading to Excel 2010, selecting say A:F where B:E is hidden would only copy the 2 visible columns.

Today it copies all 6.



is there a setting somewhere?

Try F5 - Special - Visible cells only, then slecte the range, copy and past.

thank you,
I'm aware of the workaround

I just want it to work as it did

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)

Has anyone discovered anything to cause this? I have the opposite problem, Excel used to (and is supposed to) default to copying hidden cells, but now it sometimes does not. An interesting detail is, I have a particular workbook from which hidden data is not copying. I can have it and another workbook with hidden columns both open, copy from the one and the data in hidden columns does not paste, copy from the other and it does. I can't find any setting for this and the only references I see in help are how to copy without the hidden data (since copying it is the default.)

weird

Obviously both have their uses.

I wish MS would wake up to this simple idea.

I just know there's a guru out there that knows what is going on.

As mine used to ignore hidden and now yours does, obviously there is some kind of condition causing this.