LoginSignup
3
0

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 1 year has passed since last update.

@youzhenin株式会社ディーバ

【小技】Excelで行の高さや列の幅が0の箇所をまとめて見える高さに変更する

Last updated at Posted at 2022-06-17

結論

シートを全選択して行の高さや列の幅が0の行番号や列名の位置をダブルクリックする

概要

以下のような、高さが0の行(行番号2, 5, 6, 10, 11, 12)をまとめて見える高さに変更する
image.png

手順(2 Step)

  1. シートを全選択する
    image.png

  2. マウスで絶妙な位置をダブルクリックする
    マウスカーソルのアイコンは以下のどちらでもよい
    image.png
    image.png

見ていない！オレは見てないぞ なあーんにも見てないッ！
image.png

3
0
0

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
3
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?