How To Insert A Row In Excel On A Mac

What is Insert Row in Excel?

The insertion of an excel row is simply the addition of a new (bare) row to the worksheet. The insertion of a row is eased with the assistance of shortcuts. A shortcut reduces the time taken to perform a task. This is because pressing a single fundamental or combinations of keys assist shorten an otherwise lengthy process.

For instance, while working on some financial entries, a bank executive noticed that a row containing the totals of the columns is missing. A quick insertion of a blank row is carried out with the help of the shortcut keys "Ctrl+Shift+plus sign (+)."

Shortcuts considerably better the productivity of the Excel users. These shortcuts demand not exist memorized. This is because, with regular usage, one tends to learn them.

This article discusses the major shortcuts of inserting a row in Excel. For improve clarity, all techniques have been explained with the help of examples.

Table of contents

• What is Insert Row in Excel?
  • Top 3 Keyboard Shortcuts to Insert a Row in Excel
    • Example #1–Insert a Row Using "Ctrl+Plus Sign (+)" or "Ctrl+Shift+Plus Sign (+)"
    • Example #2–Insert a Row Using the "Insert" Dialog Box
    • Case #3–Insert a Row Using "ALT+I+R"
  • How to Insert Multiple Rows Using a Shortcut Key?
    • Example #iv–Insert Multiple Rows Using "Ctrl+Plus Sign (+)" or "Ctrl+Shift+Plus Sign (+)"
  • Oftentimes Asked Questions
  • Recommended Articles

Top 3 Keyboard Shortcuts to Insert a Row in Excel

The top three shortcuts to insert a row in Excel are listed every bit follows:

1. "Ctrl+plus sign (+)" or "Ctrl+Shift+plus sign (+)"
2. "Insert" dialog box
3. "ALT+I+R"

Apply the shortcut which works on your device and is like shooting fish in a barrel to be applied. Once the insertion of a row is complete, one can printing F4 to repeat the last task.

Allow us consider some examples to understand the working of these excel shortcuts An Excel shortcut is a technique of performing a manual job in a quicker way. read more than .

Instance #1–Insert a Row Using "Ctrl+Plus Sign (+)" or "Ctrl+Shift+Plus Sign (+)"

The post-obit image shows the names (column A) and the date of nascency (cavalcade B) of ten people. We desire to perform the post-obit tasks:

• Insert a new row 6 with the shortcuts "Ctrl+plus sign (+)" or "Ctrl+Shift+plus sign (+)."
• Show how to format the newly inserted row (row half dozen).

The steps to insert a new excel row (row 6) are listed equally follows:

1. Select any cell of row half-dozen. Press the shortcut keys "Shift+spacebar" together. The entire row 6 is selected, equally shown in the following image.

   
   

2. In one case the entire row is selected, press the keys "Ctrl+plus sign (+)" or "Ctrl+Shift+plus sign (+)." The keys of each shortcut must be pressed together.

   In the succeeding image, we have applied the former shortcut [Ctrl+plus sign (+)].

   Note 1: The shortcut "Ctrl+plus sign (+)" works only on those devices which take a numeric keypad (number pad) to the right of a regular keyboard. For this shortcut to work, press the "Ctrl" key from the regular keyboard and the plus sign (+) from the number pad.

   Note 2: The shortcut "Ctrl+Shift+plus sign (+)" works on devices which practice non have a separate numeric keypad. Such devices have a regular keyboard.

   
   

3. A blank row half dozen is inserted with both the preceding shortcuts (entered in stride ii). This new row is shown in the post-obit prototype.

   With the insertion of the new row 6, the entries of the initial row 6 are shifted downwards to row 7. Moreover, a paintbrush icon appears immediately below the newly inserted row (row 6).

   
   

4. To format the new row half dozen, hover the mouse over the paintbrush icon. Thereafter, click the drop-downward arrow, as shown in the succeeding image. The formatting styles displayed are explained as follows:

   • Format same as to a higher place: This applies the formatting of the immediately preceding row (row five) to row 6.
   • Format same as below: This applies the formatting of the immediately following row (row 7) to row vi.
   • Clear formatting: This removes the formatting of row 6.
   1 can select any of the preceding styles. Based on this pick, the newly inserted row (row 6) is formatted.

   Note: The paintbrush icon may not announced each time a new row is inserted. In case it does not appear, i can format the newly inserted row in either of the following ways:

   • Select the newly inserted row, right-click and select "format cells" from the context carte.
   • Use the format painter icon from the "clipboard" group of the Home tab of Excel.

   
   

Example #two–Insert a Row Using the "Insert" Dialog Box

Working on the data of example #1, we want to insert a new row half dozen with the "insert" dialog box. Utilise the shortcut method.

The steps to insert a row with the "insert" dialog box are listed as follows:

Step 1: Select whatever jail cell of row 6. Press the keys "Ctrl+plus sign (+)" or "Ctrl+Shift+plus sign (+)." The keys of each shortcut must be pressed together.

The "insert" dialog box opens with both these shortcuts. The succeeding image shows the result of using the former shortcut [Ctrl+plus sign (+)].

Annotation i: The shortcut "Ctrl+plus sign (+)" works with keyboards having a numeric pad on the correct side. The shortcut "Ctrl+Shift+plus sign (+)" works on all the regular keyboards.

Note 2: If a prison cell is selected prior to pressing the preceding shortcuts (entered in step i), the "insert" dialog box is displayed. Nevertheless, if a row is selected, these shortcuts insert a new row directly.

Step two: The "insert" dialog box displays the post-obit options:

• Shift cells correct: This shifts the content of the selected prison cell (selected in pace one) to the cell on the immediate right.
• Shift cells down: This shifts the content of the selected jail cell (selected in stride ane) to the immediately following cell.
• Unabridged row: This inserts a new row preceding the row of the selected prison cell (selected in step 1).
• Entire column: This inserts a new column to the immediate left of the selected jail cell (selected in step i).

Since we want to insert excel row 6, we select the selection "unabridged row." A new, bare row 6 is inserted, as shown in the following paradigm. With this insertion, the entries of the initial row 6 shift to row 7.

Example #3–Insert a Row Using "ALT+I+R"

Working on the data of example #1, we desire to insert a new row vi with the shortcut "Alt+I+R."

The steps to insert a row with the shortcut "Alt+I+R" are listed as follows:

Stride 1: Select any cell of row half-dozen. We have selected cell A6, as shown in the following image. Alternatively, ane can select the entire row 6 with the help of "Shift+spacebar."

Footstep ii: Press the keys "ALT+I+R" to insert a new row. A blank row 6 is inserted, equally shown in the following prototype. With this insertion, the entries of the initial row 6 shift to row 7.

Annotation: The shortcut "ALT+I+R" does not piece of work in all the versions of Excel. Information technology works simply in the modern versions of Excel.

How to Insert Multiple Rows Using a Shortcut Cardinal?

Let the states consider an instance to understand the insertion of multiple rows The top four methods to insert multiple rows are in excel are - Using INSERT Pick, Using shortcut Primal - shift + space bar, Copy & Paste Method, Using the Proper noun Box. read more  with the assistance of shortcuts. For inserting multiple rows, 1 must know beforehand the number of rows to be inserted. This is because Excel inserts the same number of rows equally the initial rows selected.

Example #4–Insert Multiple Rows Using "Ctrl+Plus Sign (+)" or "Ctrl+Shift+Plus Sign (+)"

Working on the data of example #1, nosotros want to insert 5 rows (row 6 to row 10) showtime from row 6. Use the shortcut method.

The steps to insert multiple rows by using shortcuts are listed equally follows:

Step ane: Select rows 6 to ten. This is because we want to insert five rows starting from row 6. The rows tin can exist selected in either of the following ways:

• Select cell A6. Hold the "Shift" key and press the down arrow to select the cells A6 to A10. Press "Shift+spacebar" to select rows 6, 7, eight, 9, and x in one get.
• Printing and drag the left button of the mouse on the row numbers 6, vii, 8, ix, and x.

The selected rows are shown in the following image.

Stride 2: Once the required number of rows is selected, press the keys "Ctrl+plus sign (+)" or "Ctrl+Shift+plus sign (+)." The keys of each shortcut need to be pressed together.

In the succeeding paradigm, the rows six, vii, 8, 9, and 10 are inserted with the keys "Ctrl+plus sign (+)." Hence, five blank rows are inserted beginning with row half dozen. With this insertion, the entries of the initial rows 6, 7, viii, nine, and 10 are shifted downwards to rows xi, 12, 13, 14, and 15.

Annotation 1: Use the shortcut "Ctrl+plus sign (+)" on the keyboard having a split numeric keypad. On a regular keyboard, use the shortcut "Ctrl+Shift+plus sign (+)."

Notation 2: If multiple rows are selected, both the preceding shortcuts (pressed in step two) insert multiple rows. Since the number of inserted rows is the same equally the number of rows selected initially, one must make the selections carefully (in step 1).

Oft Asked Questions

1. Ascertain "insert row shortcut". State the process of inserting an excel row with the different shortcuts of Excel.

The "insert row shortcut" is just a shortcut to insert or add a row to the worksheet. At that place are different shortcuts available for inserting rows in Excel. One tin can select any of them depending on the version of Excel and the kind of keyboard being used.

The process of inserting an excel row with the unlike shortcuts is stated equally follows:

a. "Ctrl+Shift+plus sign (+)"–Select the entire row preceding which a row is to be inserted. Then, printing the keys of this shortcut together.
b. "Insert" dialog box–Select any cell preceding which a row is to be inserted. Thereafter, press the keys "Ctrl+Shift+plus sign (+)" together. Finally, select "entire row" from the "insert" dialog box.
c. "Alt+I+R"–Select any jail cell or an entire row preceding which a row is to exist inserted. So, printing the keys of this shortcut together.

Annotation 1: The pointers "a"" and "b" work with regular keyboards. The pointer "c" works in the modern versions of Excel.

Note ii: To select a row, click the row number with the left push of the mouse. Alternatively, select a cell and press "Shift+spacebar".

2. What is the process of inserting an excel row without using a mouse in Excel?

The steps for inserting an excel row without a mouse are listed as follows:

a. Select any jail cell of the row preceding which a new row is to be inserted.
b. Press "Shift+spacebar" together to select the unabridged row.
c. Press the keys "Ctrl+Shift+plus sign (+)" together.

A new row will be inserted preceding the option in step "a".

Note: To insert multiple rows without using the mouse, select multiple cells with "Shift+downward arrow". Hold the"Shift" key and press the down arrow. Thereafter, printing "Shift+spacebar" to select these rows. And so, press the keys "Ctrl+Shift+plus sign (+)" together.

three. How to insert a row in an Excel table with the help of a shortcut?

The steps to insert a row in a table with a shortcut are listed as follows:

a. Select a jail cell preceding which a new row is to be inserted.
b. Press the shortcut "Ctrl+Shift+plus sign (+)" together.

A new, bare row is inserted within the table.

Note: Alternatively, one tin press "Shift+spacebar" in step "a". In this example, this shortcut does not select the unabridged row of Excel. It selects the row within the tabular array only.

Recommended Articles

This has been a guide to inserting a row in Excel. Here we discuss how to insert a row or rows using the top 3 shortcut methods and footstep-by-pace examples.Yous may acquire more about Excel from the following manufactures–

• VBA Insert Row To insert rows we use worksheet method with the insert command to insert a row, we likewise provide a row reference where we want to insert another row like to the columns. read more
• Deleting Row Excel Shortcut
• Excel Rows to Columns Rows can be transposed to columns by using paste special method and the data can exist linked to the original data by simply selecting 'Paste Link' form the paste special dialog box. It could also be done past using INDIRECT formula and Accost functions. read more
• How to Convert Columns to Rows? At that place are 2 ways to convert columns to rows: 1) using the Excel Ribbon Method. 2) The Mouse Method. read more
• How to Create an Excel Spreadsheet? To create an excel spreadsheet, exercise the post-obit: 1.Open MS Excel two.Select New from the Menu dropdown listing 3. Click the Blank workbook button to start a new worksheet. The keyboard shortcut for this is Ctrl + Northward. read more

Source: https://www.wallstreetmojo.com/insert-row-shortcut-in-excel/

Share this post