Hello!

Please,give me lots of help for the request to solve a problem on auto filter

ㅇ situation
- quantity of record : approximately 40,000 records
- sorts of record : 4 kinds of numbers(1,2,3,4)
. 1=18,000 numbers
. 2 =10,000 numbers
. 3 = 8,000 numbers
. 4 = 4,000 numbers

ㅇ operation
1. choose just 1 by [data]-[filter] - [auto filter]
2. select and drag the range of filtering
3. type AAA on keyboard
4. touch <Ctrl> key and enter key at the same time
5. and make the auto filter unlocked
(original) only 1 should be changed into 18,000 numbers of AAA
(result) it shows all 40,000 numbers of AAA are changed. ???

Isn't there anybody?
Is who knowing about the above phenomenon.

Best regards...^^