LoginSignup
0
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.

@waokitsune(わお きつね)

エクセルでセル背景色が勝手に付くのを防止

Posted at

セル背景色が勝手に付く条件

同じ書式が 3行以上 設定されている場合に…
image.png

4行目のセルに入力すると…
image.png

上の行のセル背景色が付いてしまう。
image.png

防止方法

『ファイル』。
image.png

左下の『その他』『オプション』
image.png

『詳細設定』の『データ範囲の形式および数式を拡張する』をオフに。
image.png

参考サイトさん

バージョン

Microsoft Windows [Version 10.0.19045.3448]
Microsoft Excel for Microsoft 365 MSO (バージョン 2309 ビルド 16.0.16827.20130) 32 ビット

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