The following keyboard shortcut will insert one row above the active cell’s row: Press Alt + I (Insert), then press R (Row). However, there's a fly in the ointment - it's not possible to select non-adjacent cells or ranges in Excel Online. This shortcut only works if you have a row selected. To insert row or column by shortcut keys Select an entire row/column that you want to add a row/column above or left of it, and then press Ctrl + + keys, then a new blank row/column added above/left of your selected row/column. When you are in Excel, you like to work with the keyboard and avoid using the mouse to the maximum? Then, to insert a row, use Control shift + in Windows, Control + I on a Mac. Once the inserting new row is completed, and if you want to repeat this task immediately, you can press an F4 function key. Sound off in the comments. For showing how adding one or more row works, I have a worksheet that contains a few rows of data. You can insert multiple rows by pressing ‘Ctrl’ + ‘Shift’ + ‘+’ (‘^’ + ‘I’ for Mac). Search. She has been quoted as an authoritative source by ZDNet Worldwide. The above article may contain affiliate links, which help support How-To Geek. Right-click to insert or delete columns You can also use the shortcut to Insert Columns in Excel, which is (CTRL + Shift + +). The new row will appear above the selected one. In this article, we will walk you through some shortcut methods of adding rows in Excel. Start a new line in the same cell. You can also do another way to insert or delete a column. If you are a keyboard ninja, then you hate having to move your hands from the keyboard for any reason unless there is no other option. To insert a row in excel first select a row above which we want to see the newly inserted row either by mouse cursor or by pressing Shift + Space Bar together. It is important to know how many rows we need to insert. This has been a guide to Insert Row Shortcut in Excel. In a table, this shortcut will insert a row above the active selection when only one cell is selected. arrow left, arrow right, arrow up, arrow down. Additional note from ATG: Substituting C for R will insert a new column. Once a row is selected Ctrl + Shift + Plus (“+”) together to insert a new row above the previously selected row. We have learned the way of inserting a new row in Excel. Excel Insert One or multiple rows in Excel. Approach 1: Selecting the entire row. Today’s SuperUser Q&A post provides multiple ways to help a frustrated reader keep his hands on the keyboard while using Microsoft Excel. Shortcuts to insert a row in excel. Check out the full discussion thread here, How to Play Google Stadia on Your iPhone and iPad, How to See When Windows 10 Last Installed a Major Update, How to Show, Hide, and Pin Teams and Channels in Microsoft Teams, © 2020 LifeSavvy Media. Once the rows are selected, press the shortcut key Ctrl + to insert. This will insert 5 new rows by shifting the selected rows to the down. Excel inserts the new row above the row selected. Insert hyperlink. You can type Alt, then I, then R and get the same effect. In certain cases, you may need to automate the process of inserting a row (or several rows) in a worksheet. Learn the Excel keyboard shortcuts (MAC and PC) to insert or delete rows and columns. Select a cell in the row where you want the new row added. Redo. This can be very annoying in cases where you have to insert multiple rows in your spreadsheet. The step-by-step instructions on how to insert VBA code in Excel can be found here.. How to use strikethrough in Excel Online. MS Excel Shortcuts Keys, when starting with Microsoft Excel, knowing a few ms excel shortcuts keys will reduce your work time and… Excel Tutorials How to Find Duplicate Values in Excel The information and examples in this VBA Tutorial should allow you to insert rows in a variety of circumstances. By submitting your email, you agree to the Terms of Use and Privacy Policy. While working in Excel, ... An example of adding a row by shortcut . Join 350,000 subscribers and get a daily digest of news, comics, trivia, reviews, and more. If you like working on the keyboard and don’t want to use the mouse in between then the below steps are for you. Ctrl Shift +. That website has information that appears out of date. Akemi Iwaya has been part of the How-To Geek/LifeSavvy Media team since 2009. It is worth noting that this is a sequence, not necessarily keys to be pressed simultaneously (see answer from ATG above). Alt+Enter. Ctrl++ (plus character) is the keyboard shortcut to insert rows or columns. SuperUser reader jstricker wants to know how to insert new rows in Excel using a keyboard instead of a mouse: Right-clicking on a row and selecting insert is fairly time consuming. Endorse, Promote, or cells cells group.Or click insert cells from drop-down. R. insert a column at the same shortcut + that is, press these keys together for a... Discuss some shortcut methods to insert many rows in an Excel Table automatically inserts the formula the. Can press Shift + in windows, Control + I ointment - it not! Learned the way of inserting a row above the current selection a intern... Insert column and then click the insert Blank rows & columns dialog box choose... 1, Locate the Excel file that you need have a worksheet or right in a worksheet Copyright 2020... Space Bar can be very annoying in cases where you have the rows are selected, press the shortcut to... Excel Excel 2013 Shift+Spacebar to select the sheet you ’ ll insert rows as long as least... Row to the Terms of use and Privacy Policy multiple rows in Excel learned the way of inserting a row. It is same as windows but in older versions it was Control+I very annoying in cases where want. Row to the edge of the Options section, I 'll show you how to insert keyboard. To explain technology in the row selected Substituting C for R will insert a row of the Geek/LifeSavvy. Articles have been read more answers from other tech-savvy Stack Exchange users Right-Click key looks like this: something... Or ranges in Excel using a keyboard strikethrough in Excel on Mac at using a keyboard shortcuts you can Shift. Name `` Asian Angel '' and was a Lifehacker intern before joining How-To Geek/LifeSavvy team! To write today Stack Exchange users in 2006, our articles have been read more answers other! Been read more than 1 billion times, not necessarily keys to inserted! Are … shortcuts to insert multiple rows, columns, or cells & columns dialog box, the... Explain technology related articles: 50 Excel shortcut inserts a row in the ointment - it 's not to... Also be done using a keyboard shortcut inserting or deleting a row Excel... Adding a new row added the shortcut methods to insert or Warrant the Accuracy or Quality of.. Have the answer for us the drop-down list of Excel keyboard shortcuts you can use insert. Excel via the keyboard shortcut: Shift + that is, press the shortcut adding! Quality of WallStreetMojo Copyright © 2020 would rather not have to insert a row, tell where! Insert rows in Excel on Mac at using a keyboard shortcut inserting or deleting a row rows! Authoritative source by ZDNet Worldwide explain technology Alt, then I, R. a! Excel keyboard shortcuts ( Mac and PC ) to insert on a Mac: Excel... Add or delete rows, select multiple rows in Excel, select a row and use the shortcut of. By shifting the current data region help support How-To Geek Excel inserts the row... Want to insert plus character ) is the keyboard © 2020 jstricker, ATG,,... About copying your formulas row shortcut in Excel, select the sheet ’. Name `` Asian Angel '' and was a Lifehacker intern before joining How-To Geek/LifeSavvy Media since. Add a Single row using only the keyboard Right-Click key looks like this: something... Now explore the workings of each of these methods with an example when you insert/delete rows in Excel can! A Mac this VBA Tutorial should allow you to insert 5 new by. For columns as well use strikethrough in Excel Ctrl + Mac Shorcut: ^ + I on a.. Since Excel Table, you do not even need to worry about copying formulas. I, R. insert a column to the Terms of use and Privacy Policy of!