Here we're going to use a listed of alphabetized names. Enter data, or choose an existing workbook with data already pre-filled.Right-click a row number and select Insert from the resulting context menu.įuthermore, how do you insert a new row in a data set? How to Add Additional Rows Above or Below Your Excel data.Quickly add a blank row between multiple rows of data in an Excel spreadsheet Just as much, how do I insert a new row in every row in Excel? Your spreadsheet is complete.Keyboard shortcut to insert a row in Excel Now you can fill out the 2017 sales data. You have essentially “carved out” space in your spreadsheet. The number of rows inserted equals the number of rows of your original selection. Choose “Insert”.Įxcel will insert multiple rows above your selection. Then right-click anywhere in the row header for the rows you selected (i.e., right-click anywhere in the light green area). Doing this will add a kind of “spacer” row once we insert rows above this selection. Note: I am also selecting the blank row below the “2018 Total” row.

In our example, select all the rows containing 2018 data. You can insert multiple rows at once by first selecting the number of rows you want to insert. While you could just enter the key combination mentioned above multiple times, there is a faster way. But let’s say your boss also wants to see the 2017 sales info. You just completed a schedule for 2018 sales. Now you can fill in the info for February and complete your schedule. You should now see a blank row above the “March” row and below the “January” row. Then, while still holding the ALT key, press the key for the letter “R”. While holding the ALT key, first press the key for the letter “I”. Now you’ll need to perform a keyboard combination to insert a row. In our example, select a cell anywhere on Row 7 (i.e., the “March” row). When you insert a row, Excel will insert the row above your current row. Let’s insert a row in between January and March. You’ve built a draft schedule but then realized you accidentally skipped February. Let’s say you’re building a schedule that shows sales by month for a few states. If you would like to work in my example Excel file, you can download it here from Google Drive. Let’s break that down with some screenshots. This key combination will insert a row above your current row. The keyboard shortcut to insert a row in Excel is to hold the ALT key, press the “I” key, and then press the “R” key. But this keyboard shortcut, like all keyboard shortcuts, is a faster way. Did you know there is a keyboard shortcut to insert a row in Excel? Most people know that you can right-click on a row and then choose “Insert” to insert a row.

Insert a row in excel keyboard shortcut