Insert Row in Excel Shortcut Key

Hossam Ali

Last update :

In Excel, inserting a row is a common task that can be accomplished quickly using a shortcut key. The shortcut key for inserting a row in Excel is Ctrl + Shift + "+" (the plus sign). This command adds a new row above the currently selected row, making it easy to expand your spreadsheet as needed.

insert row in excel shortcut key

How to Insert Row in Excel with Shortcut Key

To quickly insert a row in Excel, you can use the following keyboard shortcuts:

Windows:

Shortcut: Shift + Space, then Ctrl + Shift + "+".

First, press Shift + Space to select the entire row where you want to insert a new row.

Then, press Ctrl + Shift + "+" to insert a new row above the selected row.

Mac:

Shortcut: Shift + Space, then Control + I or Command + Shift + "+".

Press Shift + Space to select the entire row.

Use Control + I or Command + Shift + "+" to insert a row above the selected one.

Read:

How to Insert a Calendar in Excel

Shortcut to insert row in Google Sheets

Insert Row in Excel (Windows)
Shortcut Key: Ctrl + Shift + +
Highlight the row or the cell where you want to insert a new row, and press Ctrl + Shift + +.

Insert Row in Excel (Mac)

Shortcut Key: Command + Shift + +

Select the row or cell, then press Command + Shift + + to insert a new row.

Insert Row in Google Sheets

Shortcut Key: Ctrl + Shift + + (Windows) or Command + Shift + + (Mac)

In Google Sheets, the same shortcuts work as in Excel.

Insert Row in Excel (Office 365)

Shortcut Key: Ctrl + Shift + + (Windows) or Command + Shift + + (Mac)

For Excel 365, the same shortcut as above is used to insert a row.

Read:

How to Insert Headers and Footers in Excel

Delete Row Shortcut in Excel

Windows: Ctrl + -

Select the row(s) you want to delete, and press Ctrl + -.

Mac: Command + -

Select the row(s) and press Command + - to delete.

These shortcuts can help speed up your workflow when working with rows in Excel or Google Sheets.

Edit This Article

Tags basics

You may like these posts

Comments

window['__wavt'] = 'AOuZoY5TFBGIOPWAvH0b4VTDJN8fKXZx2w:1734781220979';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6571197898080719811','//www.excel-formula.com/2024/09/insert-row-in-excel-shortcut-key.html','6571197898080719811'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6571197898080719811', 'title': 'Excel Formula ', 'url': 'https://www.excel-formula.com/2024/09/insert-row-in-excel-shortcut-key.html', 'canonicalUrl': 'https://www.excel-formula.com/2024/09/insert-row-in-excel-shortcut-key.html', 'homepageUrl': 'https://www.excel-formula.com/', 'searchUrl': 'https://www.excel-formula.com/search', 'canonicalHomepageUrl': 'https://www.excel-formula.com/', 'blogspotFaviconUrl': 'https://www.excel-formula.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Excel Formula - RSS\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6571197898080719811/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/4317970457712986528/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-4646798504000105', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/361ce9cf7a112c52', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '4317970457712986528', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/s72-w640-c-h360/insert-row-in-excel-shortcut-key.webp', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/w640-h360/insert-row-in-excel-shortcut-key.webp', 'pageName': 'Insert Row in Excel Shortcut Key', 'pageTitle': 'Excel Formula : Insert Row in Excel Shortcut Key', 'metaDescription': 'In Excel, inserting a row is a common task that can be accomplished quickly using a shortcut key. The shortcut key for inserting a row in Excel'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Insert Row in Excel Shortcut Key', 'description': 'In Excel, inserting a row is a common task that can be accomplished quickly using a shortcut key. The shortcut key for inserting a row in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/w640-h360/insert-row-in-excel-shortcut-key.webp', 'url': 'https://www.excel-formula.com/2024/09/insert-row-in-excel-shortcut-key.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 4317970457712986528}}, {'name': 'widgets', 'data': [{'title': 'Excel Formula (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': 'Social Media icons', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Main Menu', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList001'}, {'title': 'search ...', 'type': 'BlogSearch', 'sectionId': 'searchform', 'id': 'BlogSearch2'}, {'title': 'table of contents feature', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML1'}, {'title': 'contact form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '4317970457712986528', 'title': 'Insert Row in Excel Shortcut Key', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/w640-h360/insert-row-in-excel-shortcut-key.webp', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'labels', 'label': ''}]}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'sidepar', 'id': 'FeaturedPost1', 'postId': '3228625590129259517'}, {'title': 'social media icons', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': [{'title': 'How to Insert a Calendar in Excel', 'id': 5580606121535032329}, {'title': 'How to Insert Headers and Footers in Excel', 'id': 4159951143012790634}, {'title': 'How to protect only certain cells in excel', 'id': 3067475874555434323}, {'title': 'How to Find Duplicate in Excel?', 'id': 3228625590129259517}, {'title': 'Insert Row in Excel Shortcut Key', 'id': 4317970457712986528}, {'title': 'Excel: How to protect cells?', 'id': 3964375002840130680}, {'title': 'How to Protect a Cell in Excel', 'id': 952918591763884819}, {'title': 'How to Automatically Apply and Update Formulas in Excel?', 'id': 7500195495322890619}, {'title': 'How to Apply the Same Formula to an Entire Column in Excel?', 'id': 3252630612995831484}, {'title': 'How to Auto Update Formulas in Excel When New Rows are Inserted?', 'id': 8775323811157573571}]}]}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'https://www.excel-formula.com/', 'id': '0', 'title': 'Home Page'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList001', 'menu', document.getElementById('LinkList001'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch2', 'searchform', document.getElementById('BlogSearch2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'AddOns', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'contact form', 'blogId': '6571197898080719811', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY5MXxx3NZLXU0zy-HUt_maucS123g:1734781220980', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3846405171-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'sidepar', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));