If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel XP (2002) Auto Filter problem
I turn on autofilter to limit my view of data in my list,
I then try to change the contents of the viewed data; but the underlining hidden data will also change if I try to use autofill or try to make a "global" edit / replace change. Has anyone seen this? - it used to work in previous versions of Excel. Any known patches? Thx .. |
#2
|
|||
|
|||
Excel XP (2002) Auto Filter problem
Select what you can see after having filtered and then do Edit / Go To / Special
/ Visible cells. Now do what you gotta do. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- wrote in message ... I turn on autofilter to limit my view of data in my list, I then try to change the contents of the viewed data; but the underlining hidden data will also change if I try to use autofill or try to make a "global" edit / replace change. Has anyone seen this? - it used to work in previous versions of Excel. Any known patches? Thx . --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.600 / Virus Database: 381 - Release Date: 28/02/2004 |
Thread Tools | |
Display Modes | |
|
|