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. To insert multiple rows, select the same number of rows that you want to insert. You can insert multiple rows at once by first selecting the number of rows you want to insert. In the 'Insert' dialog box, check the 'Entire Row' radial button and then click 'OK.' 3. 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.
#Insert row shortcut excel download
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 shortcut can be used for inserting a single row at a time. This key combination will insert a row above your current row. The most commonly used keyboard shortcut for inserting a row in Excel is Ctrl + + (plus sign). 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.
0 kommentar(er)
