Change to 'copy visible'?

[sordid]

Hello!
I am a brand new member, long time Excel user.
Yesterday, thought I had lost it;

Here;
https://support.office.com/en-us/ar...lls-only-6e3a1f01-2884-4332-b262-8b814412847e

It says this;

By default, Excel copies hidden or filtered cells in addition to visible cells.

And that has always been true in my experience.
I remember finding Alt+; specifically for the purpose of copying filtered data after simple filters had been applied and pasting it elsewhere, because by default it would paste everything.

I just tried what I thought was the same process, blank new spreadhseet, on two different machines and its only copy/pasting visible fields for me, by default. Filter>Ctrl+A>Ctrl+C>Ctrl+P= pasting only post-filter visible

Am I confused somehow?

Thank yoouuuuu!

 

[sordid]

Can anyone at least tell me if Excel on their computer is also behaving in a way contradictory to what MS describes in the link above?

 

[Fazza]

I think the design changed some time ago. Maybe ~10 years? So with Excel 2007 I guess.

Specifically, it was like you described and then changed to be only visible cells.

So, it seems that the description on the support website is wrong.

[Despite that I still use ALT-; out of habit, though it is no longer necessary.

The time of the change there were also changes to some shortcut keystrokes. Like CTRL-A. Used to pick the whole worksheet. Now just the used range - like CLTR-SHIFT-*. However doing another CTRL-A will then get the whole worksheet.]

EDIT: What I wrote isn't correct. I googled & found reference to hidden rows/columns as opposed to rows filtered to be not visible. Testing with hidden rows, they were all copied just like the support website says. Cheers

 

[Fazza]

So, HIDDEN rows copied as the website describes,
and FILTERED did not.

 

[sordid]

Thanks for checking it out!

This is super duper weird!
I would swear on a stack of bibles that this worked just like the MS site says, in v2010 and v2013, very recently.
That doesnt make sense, I know!

 

[skyshow1]

FYI, this was just recently driving me nuts as well. In summary:

All visible and HIDDEN cells are copied to the clipboard
Only visible FILTERED cells are copied to the clipboard

This is still inconsistent with Microsoft's documentation here:

Copy visible cells only

In addition, in the desktop application, if you turn on the Clipboard view, there is this note which is incorrect: "By default, Excel copies hidden or filtered cells in addition to visible cells."

The note should really say: "By default, Excel copies hidden cells in addition to visible cells; however, cells not visible through filtering are not copied."

-- or something to that effect.