Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Copy visible cells on Filtered data

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Copy visible cells on Filtered data

There are a few people that report this in the newsgroups
I have no solution for you

Workaround:

You can select your filtered data like this

Select a cell in the table and use Ctrl *
If there are no empty rows/columns in your data table all cells are selected

Then use Ctrl ; to select the visible data

Then Ctrl c to copy and paste it where you want with Ctrl v




--

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


wrote in message ups.com...
Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default Copy visible cells on Filtered data

Hi,

Select the filtered data, Press Ctrl and drag to a new location, to check
whether the visible data is copied to a new location.

Challa Prabhu

" wrote:

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Copy visible cells on Filtered data

Select your filtered data. Press F5 key. click on "Visible Cells Only". Copy
that data and paste anywhere.

Tell us if it works.....

" wrote:

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Copy visible cells on Filtered data

Select your filtered data. Press F5 Key. click on Special button. then click
on "Visible cells Only". copy and paste data.

" wrote:

Myself and a person I work with just installed Excel 2007. If I
filter a sheet and copy the filtered data, Excel will only copy what
is visible. If I try it on my friends computer (using the same
methods and data), his Excel copies all the data, not just the
filtered rows. Any ideas?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I only delete/clear the visible cells in a filtered list? Merv Excel Worksheet Functions 5 March 2nd 07 08:00 PM
Copy/Paste Visible cells only Ashley Excel Discussion (Misc queries) 1 October 17th 06 09:17 PM
Copy visible cells only Nethie Excel Discussion (Misc queries) 1 October 13th 05 09:31 PM
Help to adapt Formula syntax to work with Visible Filtered Cells Sam via OfficeKB.com Excel Worksheet Functions 6 September 16th 05 11:42 PM
average of visible cells in a filtered range dave roth Excel Worksheet Functions 5 May 23rd 05 12:56 PM


All times are GMT +1. The time now is 04:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"