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

Excelでセルをコピーする時に末尾の改行をコピーしない

Last updated at Posted at 2017-10-19
#IfWinActive,ahk_class XLMAIN
^c::
SendInput,{F2}
SendInput,+{Home}
SendInput,^{Insert}
ClipWait
SendInput,{Esc}
return
#IfWinActive

こんな感じで無理矢理

  • Ctrl+Cを押した時に
  • F2キーを押してセル編集モード
  • Shift押しながらHomeで全選択
  • Ctrl+Insertで選択部分をコピーして
  • Escで抜ける

ってやる力技。

複数行選択時にCtrl+Cするとピヨるので、その場合は右クリックからコピーとかやってるんだけど、いい方法ないかな。

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