Help us understand the problem. What is going on with this article?

[Excel]罫線の優先度を今一度整理する

More than 1 year has passed since last update.

異なる罫線が被る時、どちらの罫線が優先して表示されるのか軽くまとめる。
列削除や行削除でセルが削除される場合によく見かけるので、なんとなく知っておくと罫線が崩れるストレスをある程度軽減できる。

どういうこと?

こういうこと。
罫線問題.png

全部戦わせてみる

罫線は14種類しかないので「なし」を除いてすべての組み合わせを調べてみた。
全組み合わせ.png

結果

以下のような優先順位となった。
優先順位.png

10番の位置がアレだけど右下ほど優先順位が高い。

以上。

Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした