Excel hotkey insert row how to#
Excel hotkey insert row download#
Excel hotkey insert row mac#

And be sure to check out our other articles on Excel shortcuts for more tips on how to work faster and more efficiently in Excel. Experiment with different combinations to see what works best for you. These are just a few of the different keyboard shortcuts that you can use to insert rows in Excel on your Mac. To insert multiple rows at the beginning of the sheet and shift the other rows down, select the number of rows you want to insert, then press Option + Spacebar. To insert a row at the end of the sheet and shift the other rows up, press Control + Option + Spacebar.ġ5. To insert a row at the beginning of the sheet and shift the other rows down, press Option + Spacebar.ġ4. To insert multiple rows below the current row and shift the other rows up, select the number of rows you want to insert, then press Control + Option + Return.ġ3. To insert multiple rows above the current row and shift the other rows down, select the number of rows you want to insert, then press Option + Return.ġ2. To insert a row below the current row and shift the other rows up, press Control + Option + Return.ġ1. To insert a row above the current row and shift the other rows down, press Option + Return.ġ0. To insert multiple rows at the end of the sheet, select the number of rows you want to insert, then press Control + Option + Spacebar.ĩ. If your keyboard has no Keypad, you can press Shift + Ctrl + + keys to insert rows or columns. To insert multiple rows at the beginning of the sheet, select the number of rows you want to insert, then press Option + Shift + Spacebar.Ĩ. To insert a row at the end of the sheet, press Control + Option + Spacebar.ħ. To insert a row at the beginning of the sheet, press Option + Shift + Spacebar.Ħ. To insert multiple rows below the current row, select the number of rows you want to insert, then press Control + Option + Return.ĥ. To insert multiple rows above the current row, select the number of rows you want to insert, then press Option + Shift + Return.Ĥ.

To insert a row below the current row, press Control + Option + Return.ģ. To insert a row above the current row, press Option + Shift + Return.Ģ.

Excel hotkey insert row mac#

In this article, we'll show you 15 of the best Mac Excel shortcuts to insert a row.ġ. If you're a Mac user, you're in luck, because there are a number of different keyboard shortcuts that you can use to insert rows in Excel on your Mac.

Your spreadsheet is complete.If you work with data in Microsoft Excel, you know how important it is to be able to insert rows quickly and efficiently. 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. Select a cell preceding which a new row is to be inserted. Let’s say you’re building a schedule that shows sales by month for a few states. The steps to insert a row in a table with a shortcut are listed as follows: a.

Excel hotkey insert row 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. Copy contents of cell above into active cell formulas are an exact copy. 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.