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 で一行挿入するマクロ

0
Last updated at Posted at 2019-05-28

Excelで「一行挿入」は「行を選択 → Ctrl+'+'」で可能で、または「Alt + I + R」でも可能ですが、
個人的には「行を選択」したり三回メニューを選んだりするのが面倒なのでマクロにしてショートカットを(Ctrl + Shift + I)を割り当てて使っています。

例えば「3行挿入したい」ときでも Ctrl + Shift + I を三回繰り返すだけです。


Sub InsertLine()
'
' InsertLine Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
 
    Dim s As String
    s = Selection.Address
    Range(s).EntireRow.Insert
   
End Sub

Officeのアクセスキー」によれば、Alt → __I__nsert __R__ow でも行挿入できます。

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?