Pasting copied AutoFiltered cells in Excel2007

[Guest]

In earlier versions of Excel, pasting copying AutoFiltered cells into another
workbook/worksheet results only in the displayed cells pasted.

However, performing the same commands results in the entire cells copied to
the new workbook/sheet.

How can this be done in Excel2007?

 

[Dave Peterson]

There have been a couple of posts that describe the same situation.

But when those posters go back to verify that behavior, it seems to change to
what you want.

Can you test it once more?

If it still fails, you can always use:
Ctrl-g (or F5, same as Edit|Goto in the old menu system)
special
visible cells only

Then copy|paste.

 

[Guest]

Ok, got it using the F5 option. How about using the mouse? I copied some
AutoFiltered cells and rightclicked on a new worksheet, there appears to be
no such commands that pastes only the visible cells.

Thanks.

 

[Dave Peterson]

In earlier versions of excel, you could customize a toolbar to show an icon that
would limit your selection to just the visible cells in that current selection.

Maybe you can add that equivalent icon to the QAT.

Look for Select Visible cells somewhere(!).

(I don't use xl2007 enough to know where it is and I don't have xl2007 running

 

[Ron de Bruin]

Must also look for it but you can always use this shortcut to select the visible cells in the selection

Alt ;

 

[Dave Peterson]

That's the one, er, one of the many shortcuts I can't remember.

Thanks, Ron.

 

[Ron de Bruin]

That's the one, er, one of the many shortcuts I can't remember.
I have a list on my Memo board Dave

For the OP

1) Office Button > Excel Options
2) Customize
3) Choose "Commands Not in the Ribbon" in the "Choose Commands from" list
4) Select the command named "Select Visible Cells"
5) Add
6) OK

 

[Dave Peterson]

I have 1000's of lists/notes/post-its, too. Never can find the one that I
want/need, though.

That's the one, er, one of the many shortcuts I can't remember.

I have a list on my Memo board Dave

For the OP

1) Office Button > Excel Options
2) Customize
3) Choose "Commands Not in the Ribbon" in the "Choose Commands from" list
4) Select the command named "Select Visible Cells"
5) Add
6) OK

 

[Guest]

Hi there - ALT+; will select visible cells only.
Kristin

 

[Dave Peterson]

Yep. That's what Ron posted a few hours ago <vbg>.

Hi there - ALT+; will select visible cells only.
Kristin