Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-07-2013, 04:13 AM
Aquinax Aquinax is offline Can command Advanved Filter do without selecting header(i.e. just process cells)? Windows XP Can command Advanved Filter do without selecting header(i.e. just process cells)? Office 2003
Novice
Can command Advanved Filter do without selecting header(i.e. just process cells)?
 
Join Date: Jun 2013
Posts: 17
Aquinax is on a distinguished road
Default Can command Advanved Filter do without selecting header(i.e. just process cells)?


I'm using the command Advanved Filter to filter out duplicate data entries quite frequently and it pains me to every stipulate the header for a row of data as the program asks to do. Yet sometimes it(Excel) goes about this filtering business without pestering me about its need for a header. And does it without fault (the first row is included in the data to be filtered and is not treated as a header). So I'm asking those more experienced - is it possible to 'tell' the program to never ask me for a header when Advanced Filtering and always treat the first row as a header?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
In Excel 2007-After Selecting Visibe Cells-How do I "Copy to Visible cells" Only mag Excel 0 10-28-2012 08:04 PM
automating a repetitive process vthomeschoolmom Excel Programming 1 02-28-2012 07:41 PM
Can command Advanved Filter do without selecting header(i.e. just process cells)? Selecting blank cells in criteria apolloman Excel 6 08-24-2011 05:38 AM
Can command Advanved Filter do without selecting header(i.e. just process cells)? filling multiple cells whislt using Filter VinceO Excel 1 05-09-2011 06:38 AM
Configuration process problem Dunn2009 Outlook 0 10-02-2009 02:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft