5
3

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 5 years have passed since last update.

Excelにテキストで貼り付けるときにセル内改行させる方法

Posted at

Excelでテキストで貼り付けるときにセル内改行させる方法

一瞬悩んだのでメモ

環境

Mac Hi-Sierra
Excel for Mac バージョン16.16.4

方法

1つのセルにしたい行をダブルクオーテーションで囲めばOK

1行目
2行目
"3行目
3行目のセル内改行
3行目のセル内改行その2"
4行目

貼り付け結果

image.png

泥臭い作業をするには便利。。。

5
3
4

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

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?