Excel XP (2002) Auto Filter problem

G

Guest

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
..
 
K

Ken Wright

Select what you can see after having filtered and then do Edit / Go To / Special
/ Visible cells. Now do what you gotta do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Auto Filter Problem 2
Excel XP (2002) auto filter 1
remembering the same filtering criteria 13
Select specific column for auto filter 4
Auto fill typing in cells problem 2
Custom auto filter (Dates) 2
Column hidden and Auto filter 2
Controlling auto-filter with VBA 1

Top