Shulou(Shulou.com)11/24 Report--

The original title: "fantastic!" This Excel screening technique, I really regret not having encountered it earlier! "

Hello, everyone. I'm Xiao Yin.

Many people often sift through data when they work, such as numerical value, gender, and so on.

So. Have you screened the bold text data?

I didn't, but now I need it.

But my colleague told me, "bold text cannot be screened directly." "

"however, you can filter indirectly with the name manager. "

"Great God, ask for advice! "

❶, select the "Formula" tab, click "name Manager", and then click "New".

❷ in the pop-up box, enter "name" (defined here as "judgment bold"), and then enter the formula in "reference position":

= get.cell (20) PS. "20" indicates bold, and "A1" indicates the cell to be identified.

❸, click "OK", and then close the pop-up box.

Enter "= judge bold" in the right cell (line A1), press the [Enter] key, and finally double-click the fill handle to fill.

"well, now you can filter by this column. TRUE means bold and FLASE means not bold. "

"Wow, thank you very much! "

By the way, by the way, the shortcut key for screening is [Ctrl+Shift+L].

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Xiaoyin

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.