recording a macro<\/a>.<\/p>\n\n\n\nAdd a name and choose a keyboard shortcut. You can’t use the\nsame shortcut as before because the shortcut should look like this:<\/p>\n\n\n\n
Ctrl + [letter]<\/strong><\/p>\n\n\n\nCtrl + Shift + [letter]<\/strong><\/p>\n\n\n\nI’m going to use Ctrl\n+ Shift + I<\/strong> to run this macro. To do it, move the cursor to the small\ntextbox, under the Shortcut key<\/strong> and\npress Shift + i<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nClick OK<\/strong>.<\/p>\n\n\n\nNow, use the Ctrl +\nShift + +<\/strong> shortcut one last time and from the insert, window choose “Entire row<\/strong>“. Click OK<\/strong>.<\/p>\n\n\n\nStop recording the macro immediately after that by clicking the stop button in the bottom-left corner.<\/p>\n\n\n\n <\/figure>\n\n\n\nTo update or change the code in your macro, you can navigate\nto View >> Macros >> Macros<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nSelect the macro. You can click Options<\/strong> to change a shortcut, or Edit<\/strong> to view the code inside this macro.<\/p>\n\n\n\nIf you followed the steps to the letter, your code should look like this.<\/p>\n\n\n\n
Sub InserRow()\n'\n' InserRow Macro\n'\n' Keyboard Shortcut: Ctrl+Shift+I\n'\n Selection.EntireRow.Insert\nEnd Sub<\/code><\/pre>\n\n\n\nMost of this is a comment about the keyboard shortcut and macro name. You can delete them. Below the comment is the most important part – the actual code.<\/p>\n\n\n\n
Selection.EntireRow.Insert<\/code><\/pre>\n\n\n\nThat’s it, now you can insert row(s) with the following\nshortcut: Ctrl + Shift + I<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"To insert a row or rows in Excel using a keyboard shortcut, you have to select at least one cell, otherwise, the shortcut…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Insert Row Shortcut in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n