Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Excel 2007 Filtering Options

  
   Windows Help (Home) -> Microsoft Excel RSS
Next:  Style of header & footer  
Author Message
Woody

External


Since: Dec 4, 2008
Posts: 3



(Msg. 1) Posted: Mon Feb 15, 2010 4:07 am
Post subject: Excel 2007 Filtering Options
Archived from groups: microsoft>public>excel (more info?)
I am running Excel 2007 and when i filter a list and then highlight the
filtered results to cut and paste into another application, it also paste's
the hidden information from the filtered list, so i am getting everything
instead of just the filtered results.
Does anyone know if there is a setting i need to switch off that will
resolve this?
Thanks

 >> Stay informed about: Excel 2007 Filtering Options 
Back to top
Login to vote
TheExcelAddict

External


Since: Feb 15, 2010
Posts: 1



(Msg. 2) Posted: Mon Feb 15, 2010 9:48 am
Post subject: Re: Excel 2007 Filtering Options
Archived from groups: per prev. post (more info?)
Press ALT+; before copying. This will Select Vsible Cells Only.

Francis Hayes (The Excel Addict)
[URL="http://www.TheExcelAddict.com"]www.TheExcelAddict.com[/URL]

 >> Stay informed about: Excel 2007 Filtering Options 
Back to top
Login to vote
Daryl S

External


Since: Oct 19, 2009
Posts: 13



(Msg. 3) Posted: Mon Feb 15, 2010 10:18 am
Post subject: RE: Excel 2007 Filtering Options
Archived from groups: per prev. post (more info?)
Woody -

After you select the data you want to copy, but before you hit copy, do this:

Edit Go To Special Visible Cells Only (OK)

Then hit copy and go paste it where you want it.
 >> Stay informed about: Excel 2007 Filtering Options 
Back to top
Login to vote
Woody

External


Since: Dec 4, 2008
Posts: 3



(Msg. 4) Posted: Tue Feb 16, 2010 12:37 am
Post subject: Re: Excel 2007 Filtering Options
Archived from groups: per prev. post (more info?)
Thanks Guys, much appreciated. Smile


"TheExcelAddict" wrote:

> Press ALT+; before copying. This will Select Vsible Cells Only.
>
> Francis Hayes (The Excel Addict)
> [URL="http://www.TheExcelAddict.com"]www.TheExcelAddict.com[/URL]
>
> .
>
 >> Stay informed about: Excel 2007 Filtering Options 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Unable to open excel 2007 file in excel 2002 despite havin.. - Hi I have installed office compatibility pack for office 2007. However, every time I try to open an xlsx file, I get unrecognized format error in Excel 2002. I can open docx without an issue. It appears to be that the problem is related specifically....

Excel 2003 toolbars in Excel 2007 - I have used Excel 2003 for years and have made a rather heavy customization by defining new toolbars with buttons calling VBA. Unfortunately, with Excel 2007 toolbars no longer exist! Gates and his gang of developers have decided that we all have to..

Excel 2007 "Trusted Locations" - Is there any way to get Excel 2007 to let you use removable media as a "trusted location"? my a*istant has a Zip drive hooked to her PC that she's using as basically an external hard drive, but whenever she opens a saved spreadsheet, it alw...

Excel 2007 Won't print some borderlines - I am attempting to print a spreadsheet of accounts on which I have used a dotted line (Rt-click / Format Cells/ Borders / Line) so that the accountant can easily follow the lines of income and expenditure. They all show up fine on the Print Preview..

Application.FileSearch in Excel 2007! - Hello, I recently upgraded to 2007 about 8 months ago, and had not run this report I developed since the upgrade and have since googled and found that Application.FileSearch no longer exists. I have been trying to use some of the code snippets to modify....
   Windows Help (Home) -> Microsoft Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]