How do you insert a new row into a worksheet?

How do you insert a new row into a worksheet?

• A. Right-click a row number -> Insert
• B. Home tab -> Insert Row
• C. Data tab -> Insert -> Row
• D. Right-click a column letter -> Insert

Answer: (A)

To add a new row, use the row header to target the position where you want the row to appear. The row header is the numbered row on the left. Right-click that row header and choose Insert; a new blank row will be inserted above the row you selected. This works because the row header represents the entire row, so inserting there adds space for a full new row in that spot. Other paths aren’t as direct for rows: right-clicking a column header would insert a column, and options under the Data tab aren’t typically used to insert rows. The Home tab path can exist in some versions via a menu, but the quickest consistent method is using the row header.

To add a new row, use the row header to target the position where you want the row to appear. The row header is the numbered row on the left. Right-click that row header and choose Insert; a new blank row will be inserted above the row you selected. This works because the row header represents the entire row, so inserting there adds space for a full new row in that spot.

Other paths aren’t as direct for rows: right-clicking a column header would insert a column, and options under the Data tab aren’t typically used to insert rows. The Home tab path can exist in some versions via a menu, but the quickest consistent method is using the row header.