Go to Qiita Advent Calendar 2024 Top
LoginSignup
4
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

@izuki_y

Excel 備忘録

Last updated at Posted at 2020-01-11

太字だけフィルタリングする方法

1.PNG

  1. 最初に太字の部分のフィールドを選択(重要）する
    2.PNG

  2. [検索と選択]--[置換]--[オプション]
    3.png

  3. 検索する文字列--書式--太字
    置換後の文字列--書式--太字　+　塗りつぶし(任意の色）
    7.png

太字の箇所のセルの色が変わるよ
8.PNG

  1. [並べ替えとフィルタ]-[フィルタ]
    9.png

  2. ドロップダウンをクリックして、[色フィルタ]で、色を選択する

  3. フィルタした部分だけ必要ならフィールドを選択して「Alt+;」を押してコピーする12.png
    13.PNG

4
1
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
4
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?