μžλ™ ν•„ν„°

ν˜„μž¬ μ„ νƒλœ 데이터 ν•„λ“œμ˜ λ‚΄μš©μ— 따라 λ ˆμ½”λ“œλ₯Ό ν•„ν„°λ§ν•©λ‹ˆλ‹€.

Icon AutoFilter

μžλ™ ν•„ν„°

ν•„ν„°λ§ν•˜λ €λŠ” λ‚΄μš©μ΄ ν¬ν•¨λ˜μ–΄ μžˆλŠ” ν•„λ“œ 이름에 μ»€μ„œλ₯Ό 놓고 μžλ™ ν•„ν„° μ•„μ΄μ½˜μ„ ν΄λ¦­ν•©λ‹ˆλ‹€. μ„ νƒν•œ ν•„λ“œμ˜ 이름과 같은 λ‚΄μš©μ΄ μžˆλŠ” λ ˆμ½”λ“œλ§Œ ν‘œμ‹œν•©λ‹ˆλ‹€.

예λ₯Ό λ“€μ–΄ λ‰΄μš•μ˜ λͺ¨λ“  고객을 ν‘œμ‹œν•˜λ €λ©΄ "λ‰΄μš•" ν•­λͺ©μ΄ μžˆλŠ” ν•„λ“œ 이름을 ν΄λ¦­ν•©λ‹ˆλ‹€. 그러면 μžλ™ ν•„ν„°κ°€ λ°μ΄ν„°λ² μ΄μŠ€μ—μ„œ λ‰΄μš•μ˜ λͺ¨λ“  고객을 ν•„ν„°λ§ν•©λ‹ˆλ‹€.

You can remove the current AutoFilter with the Reset Filter/Sorting icon or with Data - Filter - Reset Filter.

To filter with several field names simultaneously, click the Default Filter icon. The Standard Filter dialog appears, in which you can combine several filter criteria.

Please support us!