Pasting copied AutoFiltered cells in Excel2007
 

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?

Pasting copied AutoFiltered cells in Excel2007
 

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.

LYH888 wrote:

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

Pasting copied AutoFiltered cells in Excel2007
 

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" wrote:

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.

LYH888 wrote:

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

Pasting copied AutoFiltered cells in Excel2007
 

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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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

Thanks, Ron.

Ron de Bruin wrote:

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
That's the one, er, one of the many shortcuts I can't remember.

Thanks, Ron.

Ron de Bruin wrote:

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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

Ron de Bruin wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
That's the one, er, one of the many shortcuts I can't remember.

Thanks, Ron.

Ron de Bruin wrote:

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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

"Dave Peterson" wrote:

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

Ron de Bruin wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
That's the one, er, one of the many shortcuts I can't remember.

Thanks, Ron.

Ron de Bruin wrote:

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Pasting copied AutoFiltered cells in Excel2007
 

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

Kristin Broggi wrote:

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

"Dave Peterson" wrote:

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

Ron de Bruin wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
That's the one, er, one of the many shortcuts I can't remember.

Thanks, Ron.

Ron de Bruin wrote:

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

Alt ;

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Dave Peterson" wrote in message ...
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
on this pc.)

LYH888 wrote:

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" wrote:

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.

LYH888 wrote:

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


--

Dave Peterson

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson